(Thomas LaRock) Ideally your SQL instance would be configured to only allow for Windows Authentication. There may be times when mixed mode authentication is necessary at which point you will should configure a method to rotate the ‘sa’ password on a regular basis. You want the new password to be ran

(Pinalkumar Dave) Here is a question I received via email: “When SQL Server executes any query on multiple processors, do all processors process equal numbers of rows?”

(Jason Sobell) If you’ve used Entity Framework 4 with SQL Server, then you may well have hit the old ‘Default Value or Binding’ problem where EF4 insists that every property be provided, even if you intend it to be supplied by the SQL server.

(Bill Ramos) Just last week, one of our technical sales people asked me the question, when will we release the source RDL files for the Management Data Warehouse (MDW) feature that we shipped with SQL Server 2008. The reason that he asked was that his customer wanted to host the reports on a Reporti

(Paulo Morgado) After installing Visual Studio 2010 I, inadvertently ended up with SQL Server 2008 Express having already installed SQL Server 2008 Developer. Only when I was going to upgrade to SQL Server 2008R2 I found out I had two instances installed.

(Buck Woody) I was speaking with some folks yesterday about tuning a system, and they asked me about my methodology. As time goes on, I find myself doing things differently based on the situation, but there is a general approach I use that I’ll explain here. This isn’t a hard-and-fast rule; it’s jus

(Siddharth Mehta) There are two constraints with using SQL Server Integration Services 2008 R2 (SSIS hereafter) packages as a data source with SQL Server Reporting Services 2008 R2 (SSRS 2008 R2 hereafter). Firstly, SSIS is not enabled as a data source type itself on any regular SSRS 2008 R2 install

(Buck Woody) In a previous series I introduced you to a tool that is included with every Windows Server operating system, the Windows System Monitor [md] also known as Performance Monitor, or sometimes Perfmon (even though technically Perfmon is another tool). You can use the Windows System Monitor

(Pinalkumar Dave) I previously wrote about SQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer earlier and since then I have received many emails requesting to explain how it works. I assume that you can download and install the tool successfully. Once done just follo

(Sharon Bjeletich) How do you know if you have something out of the ordinary occurring on your database application system if you don’t have a good feel for what “ordinary” looks like?