|
|
|
|
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.
January 2010 - Posts
-
Today I presented "Management Studio Tips & Tricks" at SQL Saturday #34 in Waltham, MA. I had an audience of close to 100 (my biggest talk yet!), and unless they were stroking my ego, I achieved my primary goal for the session: to make sure that every Read More...
|
-
The behavior of column matching in subqueries is a little peculiar, to say the least. If you've been bitten by this behavior once, you're unlikely to have been bitten a second time, but for some of us it just takes a while to sink in. This morning I wasted Read More...
|
-
Michelle Ufford ( @SQLFool ) has just announced some shiny new updates to her popular index maintenance scripts. Read about them and contact her if you're interested in beta testing: http://sqlfool.com/2010/01/index-defrag-script-updates-beta-testers-needed Read More...
|
-
In essence, encryption of code within the engine is more like obfuscation than anything else. Unlike passwords and other sensitive data, the engine has to be able to read the code, so there has to be a way to reverse the so-called "encryption." While Read More...
|
-
Just a quick reminder that I will be presenting a Management Studio Tips & Tricks talk at SQLSaturday #34, this Saturday, January 30th at the Microsoft offices in Waltham, Massachusetts. I go on at 9:30 AM. There are plenty of other great speakers, Read More...
|
-
Give us easier to read execution plans Michelle Ufford ( @SQLFool ) recently asked for help pinpointing the most expensive node(s) in a complicated execution plan. Mladen Prajdic ( @MladenPrajdic ) has a useful workaround; he coded up a quick query to Read More...
|
-
It used to be very difficult to obtain hotfixes for SQL Server (sometimes even to learn about their existence), and they were often unsupported. They have made extremely great strides in this area, and in general, I find the new procedure much more convenient Read More...
|
-
I was tagged by Tim Mitchell ( twitter ) in a recent meme launched by Paul Randal ( twitter ), entitled, "What three events brought you here?" Well, I've lied told stories about this in the past. If you've read my previous posts about my career (in particular, Read More...
|
-
Late last night, the SQL Server Release Services team announced new cumulative updates for both SQL Server 2008 RTM and SQL Server 2008 SP1. There are too many fixes to mention, but I once again notice the trend that the "newer" branch (SP1) has more Read More...
|
-
Today I came across a self-created problem that could have been avoided if I had only followed my own advice . It wasn't directly and explicitly mentioned in this context, but the concept is the same. Let's start with the source of the problem: one stored Read More...
|
-
Control over procedure cache We are still waiting for more control over procedure cache. Adam Machanic wrote up this blog post highlighting a Connect item which he opened in 2007. It is currently closed as "won't fix" but it's been shown time and time Read More...
|
-
About two months ago, I began planning a cluster migration for one of our primary SQL Server 2005 clusters to newer hardware, and a simultaneous upgrade to SQL Server 2008 SP1. The old system runs Windows Server 2003 R2 Enterprise, 32-bit, with 4 dual-core Read More...
|
-
I am putting together a presentation on SSMS Tips & Tricks, which I will debut at SQL Saturday #34 . I already have a pretty full slide deck, but I am not the be-all and end-all of SSMS, so in the interest of distributing this information as widely Read More...
|
|
|
|
|
|