Monthly Archive: July 2011

[OT] : OS X Lion, Boot Camp & VMWare Fusion

[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...

SQL Server v.Next (Denali) : Breaking change to sys.dm_exec_sessions

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!

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!

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

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

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 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

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

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 #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!!!

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">Download SQL Server "Denali" CTP3</a> <i>(You will need to use File Transfer Manager on...

SQL Server v.Next (Denali) : Breaking change to system databases / database_id / DB_ID()

SQL Server v.Next (Denali) : Breaking change to system databases / database_id / DB_ID()

Currently you may have code that makes decisions based on sys.databases.database_id or the built-in DB_ID() function. I have seen a lot of code out there that checks the database_id, and behaves differently based on...

Using the catalog views : clearing out a "botched" schema

Using the catalog views : clearing out a "botched" schema

A user on StackOverflow had populated a custom schema with a bunch of tables, and needed to replace them with a new set of tables due to various changes. But he couldn't just drop...

An in-depth analysis of SQL Sentry's overhead

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...