On Monday, I completely missed that the SQL Server Release Services team published two cumulative updates for SQL Server 2008. I'd blame jury duty, but that didn't start until Tuesday, and only lasted two days. Well, better late than never. Cumulative Update #8 for SQL Server 2008 Service Pack 2 KB : http://support.microsoft.com/kb/2648096Build ...

It is quite difficult recently for me to find some time to write a new post, so I don’t seem to be leading the rankings of the most frequent bloggers. I rarely recently have opportunity to lay my hands on the code too, so natural sources of ‘inspiration’ are less often. Hopefully this will change in 2012 and I will have more opportunities to write ...

Ever since I started writing SSIS packages back in 2004 I have opted to store configurations in .dtsConfig (.i.e. XML) files rather than in a SQL Server table (aka SQL Server Configurations) however recently I inherited some packages that used SQL Server Configurations and thus had to immerse myself in their murky little world. To all the people ...

Very early this morning, Microsoft released two new cumulative updates for the SQL Server 2008 platform. Cumulative Update #7 for SQL Server 2008 Service Pack 2If  SELECT @@VERSION  is between 10.00.4000 and 10.00.4322KB article is KB #2617148There are 18 fixes posted to the KB articleThe new build number is 10.00.4323See the blog post ...

The first cumulative update for SQL Server 2008 SP3 is available. Build number: 10.00.5766 KB Article: KB #261714619 fixes Please note: this update is not for SQL Server 2008 R2 or for SQL Server 2008 with @@VERSION < 10.00.5500. 

I was at PASS Summit 2011 in Seattle and had a chat with Jack Richins of Microsoft on the SQL Server audit feature after his presentation. A question came up with regards to whether the SELECT permission should be checked when an UPDATE statement is being executed, and whether the behavior (i.e. you may get UPDATE even if you only want to audit ...

I’ve been at SQL Pass and it has been a really great conference. I will write soon more technical content, there are a few notes about the good and the bad of the overall experience that I’d like to share. The keynote of David J. Dewitt has been great. If you want to understand the *right* positioning of NoSQL movement and Hadoop technology, ...

Today Microsoft released Service Pack 3 for SQL Server 2008. The build number is 10.00.5500. The announcement blog post from SQL Server Release Services team:http://blogs.msdn.com/b/sqlreleaseservices/archive/2011/10/06/sql-server-2008-sp3-is-now-available.aspx List of fixes:KB #2546951 : List of issues that are fixed by SQL Server 2008 Service ...

Last night, the SQL Server Release Services Team published Cumulative Update #6 for SQL Server 2008 SP2:http://support.microsoft.com/kb/2582285 There are 13 fixes listed, and the build # is 10.00.4321. NOTE: This cumulative update is NOT for SQL Server 2008 R2.  

This evening Microsoft released cumulative update #16 for SQL Server 2008 SP1:http://support.microsoft.com/kb/2582282/There are only seven fixes listed, and the build # is 10.00.2850. NOTE: This update is NOT for SQL Server 2008 R2.