THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
SQL Server 2012
Some things don't change - Partitioning
After spending the past couple of weeks at the MVP Summit in Seattle and at SQL Connections in Orlando, I thought I should blog about things that do not change in 2008 (at least partially). One of the reason s to partition your tables is to make it more managable. Although there has been some enhancements in the manner that partitions are ...
April 27, 2008
No More HCL - in 2008
The old Hardware Compatibility List which was renamed the ''Windows Catalog'' is no more. When creating a Clustered Solution, you need to have a system that is Certified for clustering or there will be no official support. This has been a point of pain in the past as organizations purchased a clustered solution and then one of the ...
December 19, 2007
Compression in DB Mirroring
When you start to look at SQL Server 2008, there is a sub-theme of using compression to help drive performance and usefulness. When I hear the word compression, my first thought is ''No - I remember Stacker''. How many years ago was that obscure reference? Too many... Stacker was a third party product for MS-DOS which ...
November 20, 2007
Who's got your DB's back?
While I was reviewing one of the sessions from the PASS Community Summit using the streaming media on some new things in SQL Server 2008, I stumbled across a new reason to mirror. The primary reason to mirror of course is availability and to give DBAs that warm fuzzy feeling that another up-to-date (or almost up-to-date if using Async mode) ...
November 9, 2007
Brought to you by