Microsoft Virtual Academy – New SQL Server 2012 Content Released
Microsoft has released 5 new SQL Server 2012 Microsoft Virtual Academy courses.
Breakthrough Insights using Microsoft SQL Server 2012 - Analysis Services
The 7 modules of this course will introduce you to concepts and practices such as:
- Developing and Managing a Business Intelligent Semantic Model
- Enriching your BI Semantic Models with Data Analysis Expressions (DAX)
- Leveraging Master Data Services (MDS) in your Data Warehouse
Breakthrough Insights using Microsoft SQL Server 2012 – Scalable Data Warehouse
The 7 modules of this course will teach you:
- What's new in Microsoft StreamInsight
- Symmetric Multiprocessing to Parallel Data Warehouse
- Using columnstore technology to revolutionize your query performance
- SQL Server Integration Services
- SQL Server Fast Track for data warehouse for dramatic speed improvements
- Going beyond relational data management into the realm of unstructured and spatial data management
Breakthrough Insights using Microsoft SQL Server 2012 - Reporting Services
The 9 modules of this course will teach you:
- What's new Microsoft SQL Server 2012 Reporting Services
- Introduce you to Self-Service Alerting
- What's new in Microsoft SQL Server 2012 Analysis Services and PowerPivot
- How to use Power View for insightful visual reports
- How to build great Business Intelligence Semantic Models for Power View
- Deploying and managing PowerPivot in Microsoft SQL Server 2012 for SharePoint
- A Deeper understanding of PowerPivot in Microsoft SQL Server 2012
- How to install and configure Reporting Services in SharePoint Integration mode
- An overview of Reporting Services in Microsoft SQL Azure
Cloud on your terms with Microsoft SQL server 2012: Scale on Demand
The 3 modules of this course will teach you:
- Virtualization in the Private Cloud (two parts)
- Beyond the Hype - Hybrid Solutions for On-Premise and In-Cloud Database Applications
Mission Critical Confidence using Microsoft SQL Server 2012
The 9 modules of this course will teach you:
- Microsoft SQL Server 2012 Security enhancements
- Microsoft SQL Server 2012 High Availability and Disaster Recovery Design Patterns, Architectures and Best Practices using AlwaysOn
- T-SQL Cookbook - Microsoft SQL Server 2012 Enhancements
- Mission Critical application testing with Distributed Replay
- AlwaysOn Failover Cluster Instances and other High Availability enhancements
- Improve Application Availability Using AlwaysOn - A Deep Dive Into Availability Groups
- AlwaysOn - Active Secondary Part 1 - Readable Secondary
- AlwaysOn - Active Secondary Part 2 - Enabling Backup On Secondary Replicas
- Using The Power Of Extended Events For Tracing And Troubleshooting
When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer
Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Twitter: @Mr_Wharty
MC ID: Microsoft Transcript
Send a message to everyone
Hello,
there is already a way to send a message to all the mailboxes without creating a distribution list and maintain it ?
Reply:
Hi, a distribution list would be best, but there is nothing stopping you from opening the GAL and selecting all the users. There is a limit to how many users you can send to at once, but I believe if the recipients are internal its a couple thousand.
Chad
Chad Mosman, MessageOps | www.MessageOps.com
------------------------------------
Reply:
------------------------------------
Start Menu (Page)
When I used the Developers Preview (DP), I reserved expressing an opinion about the new Start Menu (or whatever it is now called) until the Consumer Preview (CP) was released. I figured that since so many people vented vitriol towards the DP's implementation, MSFT would respond accordingly.
Well, here we are with the CP. And I have to admit that when I loaded CP bare-metal to several of my machines at home and work--so that I did not have an option to revert back w/out just cause--I started to like and enjoy the new Start Menu. Interestingly enough, I have went from a hater, (using the Start Menu in DP) to an understanding "liker" in the CP, back to a soon-to-be hater.
I now find myself trying to find ways of not hitting the Windows Key to invoke search. Although I like the way in which I can re-position Metro and the desktop apps, it seems more of a novelty than a real productivity enhancer. Yes, it is nice that I can rearrange icons and add labels (see below . . . more text below the image), but I find that is not enough.
The limited Start Menu customization does not address the missing functionality of a hierarchical menu/folder system.
Also, why must I click in the lower left corner and have the Start Menu fade in? Why not have a desktop version that slides in from the left? Being that the Start Menu (Metro version) is there by clicking on the two pixels in the lower, left corner; what is the harm in having a Start Menu orb (similar to the one with the Windows symbol in Windows 7) that does the same thing?
What would be nice is to have the Metro interface slide out from the Left--from the same area where the user must click--with the current background (wallpaper) blurred and with the icons exhibiting a drop shadow. This allows MSFT to maintain consistently between platforms while not producing a jarring interface break for desktop users.
Reply:
Darien:
Here's the issue as I see it:
Nothing about the start menu was "broken" for non-touch use. The font and icon size could be adjusted for (and by) individual users to support their needs. The high density (compactness) offered by the mouse/pointer interface allowed easy access to a plethora of options and actions, and while some hated any change at all, I loved the Office 2007 ribbon after 2 days of use. So much so that I upgraded (meaning bought brand new full retail as you know) copies of Office 2007 for the wife and I. That is an example of "good" change from my perspective, I felt stifled using the previous version, so I upgraded. $$$ to Microsoft.
I liked Vista, I build my own machines so performance is always near cutting edge, Vista was snappy and very "pretty" compared to the now very old XP UI. I only went to 1 full retail copy of Vista due to the early issues with print and other drivers, so I ran XP on 5 or 6 machines until 7 came along. Now every machine in my house (too many I know) is running Win7.
As I began working with 7, my thoughts regarding changes I'd like to see were related to missing functionality, for example, if you are going to introduce a new media format (.wtv) it just seems to make good sense to include an editor of some sort. A simple cut editor is all we needed, and it was sorely missed (still is). Many folks complained about the changes in Media Player, while I play music quite a bit while working, the problems never impacted me personally. But a quick look through the forums showed a sizeable number of complaints, why not address them?
The point (so far) is, there were genuine holes that needed to be plugged, but more importantly for this discussion, not once did I ever find myself wondering why the start menu didn't "get better". The reason of course is, it didn't NEED to. The "glitz" of the menu was "right", and unlike the horrible XP "new grouped tasks" never once did I long for the return of the classic menu in Vista or 7, a setting I automatically used on XP installations. So, it looks like I've adapted to changes over the years with little to no complaint, it would be inaccurate to label me "change adverse. In fact I've provided several examples of change I readily accepted, in fact, embraced.
Enter Win8DP. Ugh. This can't be happening. I'm supposed to fiddle around with my screeen like those people who pay $100s of dollars a month for smart phone service? No, this must just be "in your face" because they are trying to push developers to create apps for tablets. Found the red pill hack, and decided "thank God Windows it still there, I can't be productive with full-screen apps and zero multi-tasking.
So, I decided to play along, and re-installed without the red pill hack. I figured since Windows was still there, I could see what tablet and phone folks would have to work with. Note that I have a cell phone that makes actual telephone calls, it also is capable of "texting" but I'm NOT. My Aunt had a I-Pad that she was showing off, and it took me about 4, maybe 5 minutes to determine this was a media consumption device, and while nifty to browse while taking a dump (sorry, truth) I could never see myself needing or wanting one. I even decided if I was given one as a gift that it would be returned so I could get something I really wanted or needed.
Then I get word the start menu is gone. Win8 now represents the future of computing. Uhh, not a computing future of MINE, guaranteed. I get the CP, install it, and am disgusted. But, being a trooper, I decided to force myself to try and make it work.
I tried. Honestly. I did. "But you can just start typing and search...". I do not care. If I want to get to event viewer I can do it in a few navigation/clicks in Win7. If I'm going to be using it a lot, I can pin it to the taskbar, or make a tiny (compared to Win8) desktop icon. I can delete that icon, unpin from the taskbar, whatever I want to do, without having to type ONCE.
Need to change my Win8 user account stuff? OK, so now I need to either type to find it, or get pissed off enough to place a huge icon for it on the "desktop"? And so it goes, each any every thing I wanted/needed to do was met by not a simpler/faster way of doing it, but trying to find the stuff I do with great regularity that some "paradim shape shifter" decided I didn't need to do anymore.
I tried. I had a "desktop" that had "all" of my stuff on it, and it looked like hell. Of course when I say "all" of my stuff I'm being facetious, to replace the functionality of the start menu, it would be something on the order of 5 or 6 or more full screen widths of big nasty phone interface styled tiles set to "small". An even then, it wouldn't be as easy to find as the items in the start menu.
Humans process info without even thinking about it. Let me explain: When I go to the Win7 start menu and click all programs, a lot of processing has already been done. I didn't focus on and read each of the folder names or even pay much attention to their icons, I know where they are somewhat intuitively.
At some level, my brain (without planning it out) is looking for relative position (this is at the top/mid/bottom), then a fine tuning mechanism kicks in (I'm looking for a name thats significantly longer or shorter than the others in the immediate area) and only when this "not really paying attention yet" processing gets me into the right area by something akin to autopilot, I finally focus on which one to click. Sounds like a lot of work? Virtually instantaneous. And this isn't a special capability only I posess, we all do it.
So, can the same thing be done with the huge ugly phone inspired icons? I'm sure it can, but there are (2) key points:
1). The spread out nature of the phone icons makes it slower as I wait for the screen to slide to the left as I seek something not currently displayed. Yeah, I know, there will probably be a function to allow me to control the speed. Trouble is, the concept itself is broken, speeding it up only serve to try and mitigate an impact on productivity that shouldn't be there in the first place.
2). The start menu structure allows me to bypass tens of items that have nothing to do with what I'm looking for, in essential autopilot mode. I know my "custom" scripting folder is near the bottom, I can find it almost blind on muscle memory alone. If not find it, get scarey close. With the win8 "start" I have to see where I am in the several screen-widths worth of huge nasty icon, then start reading them in much more detail earlier because there is no "paying attention but not too much attention" mechanism at work for me. In other words, just because its "on the screen in one place, what could be easier?!?", it is in fact harder to find and nothing at all like easier.
The phone/tablet interface simply does not belong on productivity machines. Full screen apps and the lack of robust multi-tasking insures it can never work. I'm done trying to find work-arounds. I'm done trying to analyze how i can adapt my workflow to "the new paradigm". I'm done worrying about Microsoft chambering 2 rounds in their revolver when "tradition" dictates Russian Roulette (apologies to the Russians) is "played" with one. They now have twice as good an opportunity to kill their business as they would normally have, in fact it might equate to 5 rounds the gamble is so over the top.
If Microsoft wants to play in the tablet market, the ideal solution is of course to write a tablet OS. Examine the competition's products, decide who got what parts right and who got what wrong, and where possible, insert their own enhancements as they try to avoid infringement issues.
you don't make a great tablet OS by killing the desktop, and you don't improve on Win7 by adopting a "paradigm" that is supposed to service 2 wholely separate platforms (consumption and productivity) in one OS. To do so is frankly, stupid. You can't saddle either platform with the base requirements of the other, and you can't spend the tens of thousands of man hours required in order to make sure one groups needs don't hurt the other's. It makes no sense to even try, because you can only end up with 2 scenarios in the end, no matter how hard you try:
1). An OS that saddles both "paradigms" at the expense of one another.
2). An OS that has wholely separate content that has little or nothing to do with each other. In the end this amounts to huge amounts of code that will be installed on both platforms that does nothing for one or the other, meaning its even worse than bloatware, you wouldn't or couldn't use it even it you wanted to.
My best suggestion is to split them up RIGHT NOW, and assign part of the hundreds of people that are currently assigned to the "lets keep functionality from killing the two separate platforms" team, to a team that writes a bare-metal equivalent level emulator for developers so those who would like to. Take the rest of them and put them on the task of making virtualization that works like its supposed to (like VMWare WS8), get more people working on imagining and backup instead of providing the now traditional half-baked solutions, and please, for the love of god, build a .wtv editor. Got spare people, bet you do, how about Window Movie maker working with ALL formats, and don't let this scare you, even allow output to something other than DVD or the proprietary .WMx formats?
There's a lot to be done to get the desktop done right, and there is a lot to be done to get a world class tablet OS in place. Whomever thought the two would best be served together needs to find a shovel ready job, technology obviously isn't his or her first calling.
DAS
------------------------------------
Reply:
. . . and it took me about 4, maybe 5 minutes to determine this [iPAD] was a media consumption device, and while nifty to browse while taking a dump (sorry, truth) . . .
I do the exact same thing. Use it for "restroom" browsing and reading PDF versions of my books.
I am hoping that Steven and crew at MSFT will listen. Although I am able to make good use Windows 8 in its current implementation, I see that some others at my job--who use the couple of systems that I have setup for that purpose--are having great difficulty navigating and finding the Start Menu.
I am not really super-opposed, but MSFT will have to do some radical changes and bring back some lost functionality of the old version. Luckily, I can use the officially provided feedback tool to provide not only bug reports, but suggestions as well.
------------------------------------
Reply:
. . . and it took me about 4, maybe 5 minutes to determine this [iPAD] was a media consumption device, and while nifty to browse while taking a dump (sorry, truth) . . .
I do the exact same thing. Use it for "restroom" browsing and reading PDF versions of my books.
I am hoping that Steven and crew at MSFT will listen. Although I am able to make good use Windows 8 in its current implementation, I see that some others at my job--who use the couple of systems that I have setup for that purpose--are having great difficulty navigating and finding the Start Menu.
I am not really super-opposed, but MSFT will have to do some radical changes and bring back some lost functionality of the old version. Luckily, I can use the officially provided feedback tool to provide not only bug reports, but suggestions as well.
I feel very similar but I must admit that in CP you can now right click near the bottom of the metro screen and click the All Apps button to bring back a very large portion of the Programs available.
Right clicking in the left hand corner of the Desktop screen brings up some useful system facilities.
------------------------------------
Does SSAS Design Limit Columns Outside Hierarchy?
Among other things, I've spent a bit of time trying to understand how to design reports using SSAS and Report Builder, and have continually run into the same roadblock when I create drill down reports. I often find I need to add a column that requires information outside the hierarchy. I come from a programming background where I could put things wherever I wanted, but SSAS seems restrictive. Am I right or wrong about this?
For instance, managers need a report that shows Successful Quotes. So I created a drilldown report that simply contains the columns Year->Month->SuccessfulQuote and the Measure to the right of it, the Count of Successful Quotes.
Now, someone is saying I should add a column that shows Total number of Quotes. Since I've already drilled down to Successful Quotes, it seems I cannot simply add a column, but I have to change the whole structure. Can I simply add a column? Managers do not care if the column is in the hierarchy. They just want columns added with anything they want in them.
I am thinking about changing the structure to Year->Month->AllQuotes and then two Measures to the right, Successful, and Unsuccessful. But I really do not want to show All Quotes but only successful quotes. I cannot think of a way to showing the Count of All Quotes without listing them in the report. Is this possible?
- Edited by _sotomo_ Thursday, March 1, 2012 3:33 PM
Reply:
Hi,
Is "SuccessfulQuote" a member of an hierarchy? If so, why do you not put this into the columns, with "SuccessfulQuote" and "All" being selected?
Frank
------------------------------------
Reply:
Yes, SuccessfulQuote is a member of the hierarchy. I'm not sure I understand. l didn't want to select All, because of the large number of rows that would be returned.
I just wanted to show the Count of All Quotes, without showing the rows, in a column next to the Count of Successful Quotes (I do want to return rows for successful quotes).
Is this incredibly easy, something I'm just uneducated on? Or am I correct that SSAS insists all rows be returned regardless of whether they are needed by the enduser?
- Edited by _sotomo_ Friday, March 2, 2012 3:46 PM
------------------------------------
Reply:
Hi Dave,
In MDX, "All" is just one entry that is the sum of all its children.
Frank
------------------------------------
Reply:
Frank, I've moved on to another project, but I will try that next chance I get. Thanks!
------------------------------------
Analysis Service Issue?
Hello:
Analysis Services was running & now it has stopped working. Services Account & password are fine. i don't have enough info besides as shown below. Same info is also logged at log file.
Any help or pointer is greatly appreciated.
Thanking in advance.
Thanks
Error:-
The service cannot be started: File system error: The following error occurred while opening the file '\\?\D:\MSSQL\OLAP\Data\CryptKey.bin'. File system error: The following error occurred while opening the file '\\?\D:\MSSQL\OLAP\Data\CryptKey.bin'.
The file '\\?\D:\MSSQL\OLAP\Data\CryptKey.bin' could not be opened. Please check the file for permissions or see if other applications locked it.
The file '\\?\D:\MSSQL\OLAP\Data\CryptKey.bin' could not be opened. Please check the file for permissions or see if other applications locked it.
Reply:
vinu
------------------------------------
Reply:
i did that, no luck.
Thanks
------------------------------------
Reply:
Aaditya,
I have found some info from the below link. Please check this once.
http://technet.microsoft.com/en-us/library/cc917670.aspx
Access denied: If you receive an access denied error message, the service account may have been changed to a non-administrator account by using Computer Management or Services. If the service account is changed by using Computer Management or Services rather than SQL Server Configuration Manager, access to the encryption key file (CryptKey.bin in the ..\Data folder) and other files and folders is not automatically granted to the new service account. To solve this problem, you can temporarily change the service account to an administrator account (such as Local System) and start the SQL Server Analysis Services service. After this service starts successfully, you can then use the SQL Server Configuration Manager to change the account to the appropriate non-administrator account.
Tinto
------------------------------------
Problem in Adding SQL User to SharePoint Group
I have a pre created USer by UserName:a1
These are my setting for SQL Authentication
I have added <identity impersonate="true" /> in the web.config.
Membership Provider : XYZSqlMembershipProvider
Role Provider : XYZSqlRoleProvider
I have a Share Point Group : XYZOnline
When I try to add the user a1 to SharePoint group NIITOnline.
What exactly happen.
It redirected to login Page with http://xyzpublic/_layouts/Authentication/login.aspx?ReturnUrl=/_layouts/AccessDenied.aspx
When i create the log file through some programming then got the following error at
SPUser spUser = spWeb.EnsureUser("a1");
And the Error is: Thread was being aborted.
| <%@ Page Language="C#" %> |
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <script runat="server"> |
| protected void Button1_Click(object sender, EventArgs e) |
| { |
| Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(delegate |
| { |
| SPWeb spWeb = SPControl.GetContextWeb(HttpContext.Current); |
| //SPUser spUser = spWeb.EnsureUser("XYZOnline:" + "a1");I have also tried this |
| SPUser spUser = spWeb.EnsureUser("a1"); |
| SPGroup spGroup = spWeb.SiteGroups["XYZOnline"]; |
| spGroup.AddUser(spUser); |
| }); |
| } |
| </script> |
| <html xmlns="http://www.w3.org/1999/xhtml"> |
| <head id="Head1" runat="server"> |
| <title>Untitled Page</title> |
| </head> |
| <body> |
| <form id="form1" runat="server"> |
| <div> |
| <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" /> |
| </div> |
| </form> |
| </body> |
| </html> |
- Edited by VinaySingh Thursday, July 24, 2008 7:15 AM Some mistype
Reply:
| string strSiteUrl = SPControl.GetContextSite(HttpContext.Current).Url; Microsoft.SharePoint.SPSecurity.RunWithElevatedPrivileges(delegate |
| { |
| using( SPSite site = new SPSite(strSiteUrl)) { using( SPWeb spWeb = site.OpenWeb()) { |
| //SPUser spUser = spWeb.EnsureUser("XYZOnline:" + "a1");I have also tried this |
| SPUser spUser = spWeb.EnsureUser("a1"); |
| SPGroup spGroup = spWeb.SiteGroups["XYZOnline"]; |
| spGroup.AddUser(spUser); } } |
| }); |
This Code should solve - Access Denied Error.
The SPWeb object in ur code is built under normal user account and not the elevated privilege account.
------------------------------------
Reply:
My problem got solved with the minor addition in the code
spWeb.AllowUnsafeUpdates = true;
Otherwise it is throwing the error.
Share Point Developer
------------------------------------
Reply:
Rupali,
I was having as issue where the following code (specifically at the AddUser() call) was also resulting in a message "Thread was being aborted."
SPSite site = new SPSite("http://myserver"); SPWeb web = site.OpenWeb(); SPUser user = web.SiteUsers["mydomain\myuser"]; SPGroup group = web.Groups["My Group Name"]; group.AddUser(user); Your suggestion to run with elevated privileges also worked for me. I am adding this bit of information in case anyone has the same issue. Thank you!
------------------------------------
Reply:
Hello!
Instead of the usual EnsureUser I suggest to use the wrapper described here - SharePoint: Wrapper over EnsureUser. Also, in some cases, it make sense to use elevated SPSite and SPWeb created within RunWithElevatedPrivileges.
.Net Follower (http://dotnetfollower.com)
------------------------------------
4
- Moved by David Wolters Friday, March 9, 2012 4:23 PM moving to a more appropriate forum (From:Office Volume Activation)
- Edited by sannikolas Thursday, May 3, 2012 4:16 PM
Reply:
More exactely, I saw in briefing video, there must be the recent locations and pachage solution on that panel but for my panel are missing both and when I press the buton "publish to access services" is not responding.
------------------------------------
Reply:
------------------------------------
Reply:
------------------------------------
Etron EJ168 not compatible with Hyper-V 3.0
On a fresh install of Hyper-V 3.0 (role) on Windows Server 8 beta, a machine containing the Etron EJ168 USB3 chipset will hang at boot. Disabling of USB3 support resolves this issue, but leaves the user without USB3 functionality.
Motherboard: GA-H67MA-USB3-B3
Reply:
------------------------------------
SQL Server 2012 RTM Download Site
Following is the SQL Server 2012 RTM trial download page:
http://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx
Related articles:
Download Microsoft SQL Server 2012 RTM
SQL Server 2012 RTM Day Download Link Round-up
SQL Server 2012 RTM Available!
Kalman Toth, SQL Server & Business Intelligence Training; SQL SERVER BEST PRACTICES
- Edited by Kalman Toth Friday, March 9, 2012 6:30 AM
Powershell script/command to configure SSRS
I need to Configure SSL (https) for SSRS automatically.
I am trying to do it through powershell scripts.
I have found a way to create a self signed certificate . I am trying to use it configuring https. (that is a differnt powershell script and it works fine)
But i run into error while configuring in SSRS.
I am pasting my code and also the error i get.
Plz some one help.
sslbinding.ps1
----------------------------------------------------------------------------------------------------------------
function Config-SSRSSystemConfiguration($sslUrl, $certHash, $sslPort)
{
Write-Output "Configure SSRS SSL binding"
$serverClass = get-wmiobject -namespace "root\Microsoft\SqlServer\ReportServer\RS_MSSQLSERVER\v10\Admin" -class "MSReportServer_ConfigurationSetting"
if ($serverClass -eq $null)
{ throw "Cannot find wmi class" }
$lcid = [System.Globalization.CultureInfo]::GetCultureInfo("pt-PT").LCID
$result = $serverClass.RemoveURL("ReportServerWebService", $sslUrl, $lcid)
if (!($result.HRESULT -eq 0))
{ write-error $result.Error }
$result = $serverClass.ReserveURL("ReportServerWebService", $sslUrl, $lcid)
if (!($result.HRESULT -eq 0))
{ write-error $result.Error }
$result = $serverClass.RemoveSSLCertificateBindings("ReportServerWebService", $certHash, "0.0.0.0", $sslPort, $lcid)
if (!($result.HRESULT -eq 0))
{ write-error $result.Error }
$result = $serverClass.CreateSSLCertificateBinding("ReportServerWebService", $certHash, "0.0.0.0", $sslPort, $lcid)
if (!($result.HRESULT -eq 0))
{ write-error $result.Error }
$result = $serverClass.RemoveURL("ReportManager", $sslUrl, $lcid)
if (!($result.HRESULT -eq 0))
{ write-error $result.Error }
$result = $serverClass.ReserveURL("ReportManager", $sslUrl, $lcid)
if (!($result.HRESULT -eq 0))
{ write-error $result.Error }
$result = $serverClass.RemoveSSLCertificateBindings("ReportManager", $certHash, "0.0.0.0", $sslPort, $lcid)
if (!($result.HRESULT -eq 0))
{ write-error $result.Error }
$result = $serverClass.CreateSSLCertificateBinding("ReportManager", $certHash, "0.0.0.0", $sslPort, $lcid)
if (!($result.HRESULT -eq 0))
{ write-error $result.Error }
}
$cn = $env:computername
$getCert = Get-ChildItem -Recurse Cert: | Where-Object {$_.FriendlyName -eq "selfgenerated"}
$certHash = $getCert.Thumbprint
Config-SSRSSystemConfiguration "https://$($cn):443" $certHash 443
-------------------------------------------------------------------------------------------------------------------
I facing the below errors
PS C:\Users> C:\Users\Administrator\Desktop\sslbinding.ps1
Configure SSRS SSL binding
Config-SSRSSystemConfiguration : A Secure Sockets Layer (SSL) certificate is not configured on the Web site.
At C:\Users\Administrator\Desktop\sslbinding.ps1:55 char:31
+ Config-SSRSSystemConfiguration <<<< "https://$($cn):443" $certHash 443
+ CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
+ FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Config-SSRSSystemConfiguration
Config-SSRSSystemConfiguration : A Secure Sockets Layer (SSL) certificate is not configured on the Web site.
At C:\Users\Administrator\Desktop\sslbinding.ps1:55 char:31
+ Config-SSRSSystemConfiguration <<<< "https://$($cn):443" $certHash 443
+ CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
+ FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Config-SSRSSystemConfiguration
NOTE:
Let me know if you need more info..
The senselessness of Windows 7 search
I have these options set up in my Folder Options (Alt > T > o from any folder):
Search tab:
Always search file names and contents (this might take several minutes)
Include subfolders in search results when search results when searching in file folders
Say I have several files:
01simple.php
01simple-download-xls.php
01simple-download-xlsx.php
If I type "simple" into the search box, it says "No items match your search".
If I type in "01simple", it finds all three files.
If I type in "01simple-xls", it finds 01simple-download-xls.php
If I type in "download", it finds "01simple-download-xls.php" and "01simple-download-xlsx.php".
If I type in "-download", it finds every file in the folder.
If I type in "simple-download", it finds nothing.
How can this possibly be a useful feature with such inconsistent results? I have no idea if they're accurate without looking at every file, which makes the feature useless. I'm a programmer and need to find filenames or text in files quickly and easily and now I will have to download 3rd-party software to do something that Microsoft has removed from their wonderful operating system. How do they explain this?
- Changed type Arthur_LiMicrosoft contingent staff Monday, January 11, 2010 7:10 AM
Reply:
Check this out though, I know it's dreadful, but watch all 5 minutes of it. That's their intent. Nobel cause, but it doesn't help people like you and I.
If this was helpful, please vote by clicking the green triangle. If it solves the issue, click Propose as Answer. Thanks!
------------------------------------
Reply:
------------------------------------
Reply:
If this was helpful, please vote by clicking the green triangle. If it solves the issue, click Propose as Answer. Thanks!
------------------------------------
Reply:
Agreed. This doesn't make finding files by file name easy at all. I miss *.iso to find my images, for example.
use the keyword ext. or type.
ext: .iso Will return all files with the extension .iso.
type: .iso Will return any file registered as an ISO image.
Regards Jens Peter Karlsen.
------------------------------------
Reply:
If I type "simple" into the search box, it says "No items match your search".
jpk> That shouldn't confuse you as it works the same in WIN-XP search. To find text anywhere in a filename use a wildcard such as * (*simple returns all three files)
If I type in "01simple", it finds all three files.
JPK> Yes as in WIN-XP it will return all files that start with that.
If I type in "01simple-xls", it finds 01simple-download-xls.php
JPK> That is because - is taken as a wildcard (that is different from WIN-XP)
If I type in "download", it finds "01simple-download-xls.php" and "01simple-download-xlsx.php".
JPK> Like above.
If I type in "-download", it finds every file in the folder.
JPK> then you must have download as text in the files. To make sure you only search filenames use the prefix file:
If I type in "simple-download", it finds nothing.
JPK> Same as number 1.
How can this possibly be a useful feature with such inconsistent results?
JPK> Nothing inconsistent if you use the correct syntax.
JPK> For more about what the more advanced search can do for you:
http://www.microsoft.com/windows/products/winfamily/desktopsearch/technicalresources/advquery.mspx
Regards Jens Peter Karlsen.
------------------------------------
Reply:
------------------------------------
Reply:
47 years of programming and intimate computer work(Windows and Linux) says
microsoft invented Windows 7 because
(1) they were low on cash after Vista
(2) vista gave microsoft a bad name and Linux was/is taking over
(3) some dense people needed to express themselves.
The Windows 7 file find is ridiculous
The file find in XP Prof was great!
Now in Linux/Fedora 16, the file manager Dolphin has an equally stupid file search.
It starts looking as soon as you start typing
- Edited by landon1 Thursday, March 8, 2012 10:07 PM
------------------------------------
error in expression
=iif (fields!UnitType.value ,-1,
" ", iif(Fields!UnitType= 1, fields!quotesperzise.value + "/SF", iif(fields!UnitType = 2, fields!QuotePerSize.value +"/Ac",iif (fields!UnitType = 3, fields!QuotePerSize.value &"/U")))
iam using this expression to give values of a column quotepersize like Sf ,A, U according to a column unittype. can someone show me the correct expressionmsmustard
Reply:
There should be = sign instead of a comma in your first condition and also Fields!UnitType.Value instead of Fields!UnitType in rest of your conditions -
Try the following
=iif (fields!UnitType.value = -1," ",
iif(Fields!UnitType.value= 1, fields!quotesperzise.value + "/SF",
iif(fields!UnitType.value = 2, fields!QuotePerSize.value +"/Ac",
iif (fields!UnitType.value = 3, fields!QuotePerSize.value &"/U"," "))))
Hope this Helps!
------------------------------------
Reply:
=iif (fields!UnitType.value ,-1," ",... to = iif(Fields!UnitType.Value = -1," ",.... ?
Hope this Helps!
------------------------------------
Reply:
I see couple of problems with your expression.
1. In your first condition - You are passing 4 arguments where as IIF statement only takes 3
IIF(Condition,True-part,False-Part)
=Iif(Fields!UnitType.value= -1,"N,2","N,0",fields!quotepersize.value &"/sf")
2. You second IIF should be nested one within the first IIF and it is not.
Would you explain what is your condition/logic for this expression?
Hope this Helps!
------------------------------------
Envelope issue in a receive port
I have juste read following in MSDN document :
If your inbound message is an interchange, you cannot use the map you add at the receive port to transform the inbound instance to the envelope instance. The map you add at the receive port can only be used to transform the document instances inside the interchange. If you try to use the map to transform the interchange itself, you will receive an error message similar to the following:
The Messaging Engine failed while executing the inbound map for the message coming from source URL:"\\MyTest\Input\*.xml" with the Message Type "http://MyTest.InboundMessage". Details:"Document type "MyRecord" does not match any of the given schemas."
Does it mean that it is not possible to debatch a message with the envelope mechanism with a map in a receive port (XML Receive pipeline) ?
Christophe BRANDO http://christophe.brando.free.fr
Reply:
hi,
The Error
The Messaging Engine failed while executing the inbound map for the message coming from source URL:"\\MyTest\Input\*.xml" with the Message Type "http://MyTest.InboundMessage". Details:"Document type "MyRecord" does not match any of the given schemas."
tells that your generated schema has multiple root nodes.
you can confirm this by looking at the Schemas section in the BizTalk Administration Console.
Refer the below link, which helps to solve the issue.
http://seroter.wordpress.com/2010/04/08/debatching-inbound-messages-from-biztalk-wcf-sql-adapter/
Don't forget to mark the post as answer or vote as helpful if it does, Regards - Rajasekhar.R
------------------------------------
Reply:
I think the issue here is as follows:
-When a Map is executed on the Receive Port, BizTalk will actually call an XML disassemble Pipeline Component (this is why we can promote fields on the target schema and still have them promoted when hitting the MessageBox).
-If the target schema is an envelope schema (debatch schema), this will fail when the XML disassembler is called.
I don't see the problem though. We should always do the debatching on the pipeline BEFORE the maps are called. And the maps should be from the debatched message to some canonical internal format.
Morten la Cour
------------------------------------
Reply:
Hi Rajasekhar,
Generated schema doesn't have multiple root nodes.
Christophe BRANDO http://christophe.brando.free.fr
- Edited by Christophe BRANDO Wednesday, March 7, 2012 1:28 PM
------------------------------------
Reply:
------------------------------------
Reply:
I am pretty sure that you can't. I still think the question should be why? Why can't you do the de-batching on the source document in the pipeline without having to map it first?
Morten la Cour
------------------------------------
Reply:
I do agree with you La Cour ! Why ? Why ?? Seems to me that something could be improved...
Christophe BRANDO http://christophe.brando.free.fr
------------------------------------
Reply:
Christophe BRANDO http://christophe.brando.free.fr
------------------------------------
Reply:
Hi,
I would try to call the MAP in the custom pipeline using .net code.
HTH
Naushad
------------------------------------
Reply:
But why do you need XMLTransmit and not just PassTruTransmit? on the Send Port?
Morten la Cour
- Edited by la Cour Wednesday, March 7, 2012 2:06 PM
------------------------------------
Reply:
Same behaviour with PassTruTransmit !
Quite strange : does it mean that problem is not associated with DASM ou ASM pipeline component, but with schemas definition.
I do have 2 separate schemas : one for envelope and one for debatched message. Envelope schema has import of debatched message definition.
Christophe BRANDO http://christophe.brando.free.fr
------------------------------------
Reply:
Christophe BRANDO http://christophe.brando.free.fr
------------------------------------
Reply:
------------------------------------
Reply:
Christophe BRANDO http://christophe.brando.free.fr
------------------------------------
Reply:
Did it solve your problem?
HTH, Naushad (MCC/MCTS) http://alamnaushad.wordpress.com, My New TechNet Wiki Article "BizTalk Server: Performance Tuning & Optimization"
If this is helpful or answers your question - please mark accordingly! Please "Vote As Helpful" if this was useful while resolving your question!
------------------------------------
Reply:
Christophe BRANDO http://christophe.brando.free.fr
------------------------------------
HyperVBackup - New open source tool
Hi,
I just published an open source tool to perform Hyper-V VM backups, supporting also Cluster Shared Volumes (CSV), supporting Windows 2008, Windows 2008 R2 and Windows 8 (including Core and Hyper-V editions)
http://hypervbackup.codeplex.com/
One of the goals of this tool is to be very easy to use (unlike Diskshadow). Here's a basic usage sample:
HyperVBackup -a -o \\server\backup
The above command will backup all virtual machines found on the host, creating a separate zip file for each VM in the provided path (local or UNC).
In the current beta status, the backup features are already working 100%, while the restore features are under development.
Any suggestions and contributions will be highly appreciated :-)
Thanks!
Alessandro Pilotti
MVP ASP.Net / IIS
- Edited by AlexPilottiMVP Tuesday, March 6, 2012 11:50 PM
Reply:
Thanks! I've been waiting for something like that for a long time...
------------------------------------
Reply:
Hi,
I just published an open source tool to perform Hyper-V VM backups, supporting also Cluster Shared Volumes (CSV), supporting Windows 2008, Windows 2008 R2 and Windows 8 (including Core and Hyper-V editions)
http://hypervbackup.codeplex.com/
One of the goals of this tool is to be very easy to use (unlike Diskshadow). Here's a basic usage sample:
HyperVBackup -a -o \\server\backup
The above command will backup all virtual machines found on the host, creating a separate zip file for each VM in the provided path (local or UNC).
In the current beta status, the backup features are already working 100%, while the restore features are under development.
Any suggestions and contributions will be highly appreciated :-)
Thanks!
Alessandro Pilotti
MVP ASP.Net / IIS
How do you compare what you've did with upcoming VM Replica feature we're expected to have with Hyper-V 3.0?
-nismo
------------------------------------
Reply:
Hi Nismo,
the Replica feature addresses a separate need, which is increasing fault tolerance by keeping a copy of a VM up to date on a separate host. It should not be considered as a replacement of a regular backup policy.
Alessandro Pilotti
MVP ASP.Net / IIS
------------------------------------
Reply:
Hi Nismo,
the Replica feature addresses a separate need, which is increasing fault tolerance by keeping a copy of a VM up to date on a separate host. It should not be considered as a replacement of a regular backup policy.
Alessandro Pilotti
MVP ASP.Net / IIS
Why? I need to keep a copy somewhere so I keep it on another Hyper-V host with access to a proper dedupe/compression enabled storage (I need some storage server for management and some capacity to store backups on in any case). I can configure any snapshot intervals with 5 minute granulatiry and I have as many recovery points as I want. So what's the difference? :)
-nismo
------------------------------------
Reply:
Let's say that replica stands to Hyper-V as Log shipping / mirroring stands to SQL Server. In the DBMS world, log shipping and backups are both employed in a disaster recovery policy as they address slightly different needs. I'm expecting to do the same w our Hyper-V clusters once we'll start to deploy Windows 8.
Back to Hyper-V's Replica, don't get me wrong, I'm a HUGE fan of this feature and I cannot wait to start using it our datacenter as soon as it reaches production level.
There are unfortunately things that are still not public, so it's IMHO too early to start a discussion on Replica, which is also off topic in this thread. :-)
------------------------------------
robocopy from Server 2008 and later not usable anymore for server/client backup
Hello,
it took me a while to find out why Windows Server could not handle any more so many clients to backup with robocopy after it was updated from 2003 to 2008 R2. The backup is done with the command
robocopy \\myclient1\vss-d$ f:\myclient1\d /e /mir /b ...
This command takes more than 6 times longer on a better performing server hardware with 2008 R2 than before with old hardware and 2003. After analyzing I noticed that robocopy from 2003 Resource Kit (version XP010) immediately starts to mirror the directories. Beginning with version XP026 (2008/Vista) an additional pass before mirroring was introduced. The source tree is once scanned completely before robocopy really starts. A client with 115.000 directories and 620.000 files takes 13.5 hours for robocopy to finish (no transfer, only sync). After replacing robocopy with version XP010 it only takes a little less than 2 hours. The disadvantage is that the parameter /dcopy:t cannot be used.
I think it is necessary that robocopy gets back the speed of XP010.
Many Greetings
Michael
- Changed type Michael Zöllner Thursday, February 2, 2012 11:26 AM
Reply:
------------------------------------
Reply:
Probably for local copies robocopy XP026 or later are faster than the 'old style' XP010, I did not check it. For syncing to a network share I could improve the performance for the 'new' robocopy very, very little by adding /mt:1 not using the default 8 threads. But this improvement is only marginal so one still has to use robocopy XP010.
Many Greetings
Michael
------------------------------------
Reply:
------------------------------------
Reply:
Sending one container file is no option. I need robocopy's mirror mode. Most of the files are not changed and don't need to be copied. It's way too much data to be copied completely each day.
Many Greetings
Michael
------------------------------------
Reply:
------------------------------------
DPM 2010 & Exchange 2010
So I've had my DPM sync with exchange 2010 every hour for the past year so and everythings been cool no errors. About a month or two ago I started getting errors in DPM indicating that :
Recovery point creation jobs for Exchange Mailbox Database Archive Database on KDNAP-MBX01. have been failing. The number of failed recovery point creation jobs = 1.
If the datasource protected is SharePoint, then click on the Error Details to view the list of databases for which recovery point creation failed. (ID 3114)
Data consistency verification check failed for LOGS of Exchange Mailbox Database Archive Database on KDNAP-MBX01. (ID 30146 Details: Access is denied (0x80070005))
What I've noticed is the mailbox assistant will run while it is trying to do a sync, I've searched the internet and I've seen that this will cause problems. I've set the mailbox assistant from running every 4 hrs to 8 hrs and I've got less errors in DPM. However it still does occur. I think what has happpened here is that my archive database has grown larger over time and it takes the mailbox assistant longer to run now.
My question is, is there a way to get DPM to stop the mailbox assistant (Probably not) while doing a incremental or full backup
Or is there a way to get DPM to check if there is an event running prior to doing its backup some sort of maint window thing?
This error does clear itself up after the Mailbox assistant finished and DPM on its normal schedule next hour does it's sync. I just find it annoying that this is happening. Anyone else have an similar problem or a work around?
- Edited by Mike_Kubi Wednesday, March 7, 2012 3:22 PM
Reply:
Anyone? :)
------------------------------------
Populating a repeat field from a list
I have a sharepoint list created from another form(alpha). For simplicity, only two fields in the list FAILURE and SUBMITDATE. This list can have multiple FAILUREs with the same SUBMITDATE. Each FAILURE is recorded as a separate record.
In another form(beta). I need to list those multiple FAILUREs in a repeat field/table that correspond to another DATE field in the beta form, filter out all the FAILUREs that do not correspond beta DATE.
I can do a dropdown list all day with a filter on it just fine. But the users demand a populated list. I can populate a repeat field within beta with the whole sharepoint list of alpha. But can not figure out how to filter it.
I have seen some other threads describing this situation but I get mixed up the in the field definitions and where they are.
Anyhelp would be appreciated,
Andrew
sharepoint DateTimeControl differnt calender views
Hi Team,
i am using sharepointdatetime control,it is giveing default view but our requirement is need to give a option for the end users to chenge tear also on the top level of a calender.
right now as per the below image i am giving a option to chenge month only
thanks in advance
prboss
Reply:
Regards, Mahesh
------------------------------------
Information regarding VSS / VolSnap errors
We have seen a failure in our Third party backup software recently when trying to backup our file server. From the server event log I can see VolSnap 24 and VolSnap 35 errors indicating an issue with the size of the shadow copy. This is now a 1 TB disk, what is the recommended free space required for a disk of this size (10 % ?) What is this size dependendt on. Our full back up runs for 15 Hours at the weekend, would this length of time require a larger Allocation. Can the shadow copy be set to create on a seperate drive eg. G drive 1 TB data, H: Drive 100 GB for Shadow Copy / VSS only?
Any help with these questions or link to an overview of VSS would be appreciated.
Thanks.
- Changed type SriramB[MSFT]Microsoft employee Monday, December 7, 2009 6:23 PM not related to Windows Backup
Reply:
File Services and Storage Forum: http://social.technet.microsoft.com/Forums/en/winserverfiles/threads
Windows Server 2008 R2 General: http://social.technet.microsoft.com/Forums/en/windowsserver2008r2general/threads
Thanks
Sandeep
This posting is provided "AS IS" with no warranties, and confers no rights
------------------------------------
Reply:
------------------------------------
Filtering problem in reporting
Hi,i have to faced one problem that one is For example
Table Name:Emp
Empid Sal Status
1001 10000 0
1001 10000 1
1002 13000 0
1003 15000 0
1003 15000 1
This is table here i want to report is
Empid Sal Status
1001 10000 1
1002 13000 0
1003 15000 1 This Like.............
How to do that in reporting
Regards&Thanks
Vinodkumar.kapa
Vinodkumar.kapa
Reply:
If you can't do it in the query, you could do it in the report by grouping on Empid and Sal, and then in your field expression for Status, change it to =Max(Fields!Status.Value)
Cheers,
Martina
Martina White
------------------------------------
