(Sal De Loera) I recently ran across a poorly covered topic in regards SSRS development using MDX parameters and datasets. After some trail and error and visiting a number of online resources, I found the approach below to be the most straight forward.

(Svetlana Golovko) A user supports an application that has three databases for three different environments. These databases are located on two different SQL Servers and have different names. The user needs to validate application users on each of these databases. How can he/she run a single query i

(Serdar Yegulalp) Windows Azure — Microsoft’s cloud infrastructure platform — has become a major part of Microsoft’s overall strategy, and the Windows Azure SQL Database, formerly called SQL Azure, has become a major component of Windows Azure itself.

(K. Scott Allen) The SqlBulkCopy class is invaluable for moving large amounts of data into SQL Server from a .NET application. I’ve been working with the class recently and taking notes on a few quirks and features.

(Pinal Dave) Here is another example where the error messages are very clear but often developers get confused with the message. I think the reason for the confusion is the word “Key” used in the error message.

(Kaushik Nagaraj) Recently we migrated one of our client’s SQL Server instances to a new server. During the migration we had moved the storage to the new server so the old server didn’t have some of the disk drives that were previously mounted on it.

(Jude O’Kelly) This question about selecting data using Entity Framework on StackOverflow got me thinking that a lot of LINQ to Entities code samples show very little consistency in how data is selected. Find(), Single(), SingleOrDefault(), First(), and FirstOrDefault() are often used interchangeabl

(Kenneth Fisher) The other day one of the developers I work with gave me a script similar to this:

(Ben Snaidero) Have you ever had to write a bunch of TSQL to do some data analysis on the table data in your database. If you have you’ll know that this can become a fairly time consuming and tedious task? SQL Server 2012 Integration Services has a feature called the Data Profiling task that can hel

(Scott Mattie) This is an article that I have been meaning to write for months. It was very exciting for me when I was trying to solve this issue and I was even more pleased with performing this task when I found a few DBA’s had never attempted this operation. I want to share that knowledge with you