|
|
|
|
Aaron is a senior consultant for SQL Sentry, Inc., makers of performance monitoring and event management software for SQL Server, Analysis Services, and Windows. He has been blogging here at sqlblog.com since 2006, focusing on manageability, performance, and new features; has been a Microsoft MVP since 1997; tweets as @AaronBertrand; and speaks frequently at user group meetings and SQL Saturday events.
July 2011 - Posts
-
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 of the settings I apply in system preferences, the cursor is very jumpy and Read More...
|
-
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 sys.dm_exec_sessions, you don't need to prefix database_id Read More...
|
-
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 following KB articles: KB #2555406 : Cumulative update Read More...
|
-
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 - CU1 is here and it contains these fixes. I didn't verify this for every fix individually, Read More...
|
-
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 to detect any metadata changes that I hadn't already talked about here. As Read More...
|
-
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 hand, but to also be able to bring the results back just as quickly - without having to run the query Read More...
|
-
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 this was not the case. As indicated Read More...
|
-
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 (build 10.50.2425). If you installed the CTP, SELECT @@VERSION will Read More...
|
-
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 files, and an HTML file that currently contains a set of links Read More...
|
-
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 then after all the submissions are in, writes a summary Read More...
|
-
The CTP3 of SQL Server Code-Named "Denali" is now available. You can download the bits here: Download SQL Server "Denali" CTP3 (You will need to use File Transfer Manager on Windows, and a Java applet on Mac OS.) If you are just interested in the Express Read More...
|
-
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 the assumption that a value between Read More...
|
-
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 them all in any arbitrary order, because there were foreign keys in place. Read More...
|
-
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 server(s) being monitored and on the server(s) doing the monitoring. Read More...
|
|
|
|
|
|