Rotating Header Image

Posts Tagged ‘SQL 2008’

SQL Bacon Nugget of Excellence Award @MladenPrajdic

Prior Winners: Lara Rubbelke – (post link | blog | @SQLGal) – Enterprise Policy Management Framework Tim Ford – (post link | blog | @SQLAgentMan) – Determine Free Space, Consumed Space, and Total Space Allocated for SQL Server databases This “award” has (unintentionally) not been handed out in a while but something that I’ve used [...]

I Want to Speak (Virtually) At YOUR Chapter!

On December 28th I’ll be doing a virtual presentation for MADPASS (The Madison SQL Server Users Group) on Doing More With Less… Policy Based Management Session Abstract: Do more with less… sound familiar? In this introduction to Policy Based Management presentation we will be going over what Policy Based Management is and how to use [...]

Check Constraints That Call Functions

Originally this blog post was going to be about how using check constraints that call functions basically eliminates SQL Server’s ability to do set-based operations and I was going to setup an example that inserted 10 rows to show that because of the check constraint that calls a function SQL Server ends up calling the [...]

The Change Data Capture (CDC) Easy Button

I’ve been working alot with CDC the last little while and found these couple of scripts very useful. These scripts are handy in a DEV type of environment… you should be alot pickier about what you use CDC for but if you’re looking to play around and get your hands dirty then these are the [...]

SQL Server 2008 SP2 Released

SQL Server 2008 SP2 has been released and I must be living under a rock because I had no idea it was coming. Fellow SQL blogger (and Canadian) Aaron Bertrand broke the news on his blog here Link to the Service Pack Link to the bugs that are fixed in SQL Server 2008 SP2 Note (from Aaron [...]

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.