[OT] : OS X Lion, Boot Camp & VMWare Fusion
I recently upgraded my MacBook Pro and Mac Pro to OS X Lion, and I've only come across two minor issues. On the Mac Pro I have a really skittish Magic TrackPad … regardless...
Monthly Archive: July 2011
SQL Server v.Next (Denali) : Breaking change to sys.dm_exec_sessions
If you're not OCD about prefixing every single column in a query, this is one that might bite you. Today you might have code that assumes that, because database_id is in sys.dm_exec_requests but not...
New cumulative updates for SQL Server 2008 SP1 & SP2 are available!
In addition to SQL Server 2008 R2 SP1 CU1, Microsoft today also released cumulative updates for the SQL Server2008 branches (Service Pack 1 and Service Pack 2). You can download these updates from the...
SQL Server 2008 R2 SP1 CU1 is now available!
For those of you that held out on installing SQL Server 2008 R2 Service Pack 1 because it was missing the fixes from RTM's Cumulative Updates 7 & 8, your wait is over –...
SQL Server v.Next (Denali) : Putting Juneau CTP3 over Juneau CTP2
Okay, I'll be the first to admit, I tried to install CTP3 on a machine without first cleaning up the CTP2 bits. My primary motivation was to be able to query the catalog views...
SQL Server v.Next (Denali) : Getting Ctrl+R to work again
Ctrl+R is a good friend of mine – we go way back. It is very handy to use this command not only to hide the results pane away and focus on the query at...
SQL Server v.Next (Denali) : Juneau CTP3 is now available!
SQL Server Developer Tools (SSDT) – code-named "Juneau" – is now available. Many (including myself) believed that Juneau was simply a part of BIDS in CTP3, but after trying to use Juneau-specific functionality that...
SQL Server 2008 R2 Service Pack 1 is now available
And the hits keep coming! Microsoft not only released Denali CTP3 today, they have also released Service Pack 1 for SQL Server 2008 R2, which was first released as a CTP back in April...
SQL Server v.Next (Denali) : CTP3 Installation Walk-Through
In case you missed my previous post, you can now download CTP3. The delivery mechanism this time is a little different. Instead of downloading an ISO, you download a very small EXE, two .box...
T-SQL Tuesday #20 : T-SQL Best Practices
T-SQL Tuesday, the invention of Adam Machanic (@AdamMachanic), is what he calls a recurring, revolving blog party. Each month, a new host picks a topic, invites bloggers of all levels to join in, and...
SQL Server v.Next (Denali) : CTP3 is here!!!
The CTP3 of SQL Server Code-Named "Denali" is now available. You can download the bits here: <a href="http://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/default.aspx" title="http://www.microsoft.com/betaexperience/pd/SQLDCTP3CTA/enus/default.aspx" target="_blank" rel="noopener noreferrer">Download SQL Server "Denali" CTP3</a> <i>(You will need to use File Transfer...
SQL Server v.Next (Denali) : Breaking change to system databases
I talk about a SQL Server 2012 change in how a database may or may not be classified as a "system" database.
Using the catalog views : clearing out a "botched" schema
Use dynamic SQL to clear out a schema, removing constraints first so you don't have to figure out how to drop objects in dependency order.
An in-depth analysis of SQL Sentry's overhead
One of my first major projects at SQL Sentry was framed shortly after I joined the company: to publish an analysis of the overhead that Performance Advisor and Event Manager place on both the...