[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...
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...
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...
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...
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 –...
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...
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 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...
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...
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, 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...
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...
I talk about a SQL Server 2012 change in how a database may or may not be classified as a "system" database.
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.
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...