I wanted to point out a nice performance improvement related to table valued parameters (TVP) in SQL Server 2012.   It’s not currently documented in our online documentation.   But we have had customers who inquired about this. When ...read more

  In my last post, I went over partial database containment and contained users.   This post will focus on the other piece of functionality in partial containment… collation.   The collation of data determines how data is sorted and compared ...read more

The concept of database containment basically means that all instance level dependencies are severed from the database.   If you have ever implemented log shipping or mirroring, you are probably aware of many of these.   Instance level logins ...read more

SQL Server has supported CLR usage since version 2005.  But support of .NET framework assemblies within SQL Server is limited per our support policy in KB http://support.microsoft.com/kb/922672 .   Some users chose to use .NET framework assemblies ...read more

I've ran across the following error a few times and thought I would post this out there for people to understand what is happening. ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: , Microsoft.ReportingServices ...read more