|
|
|
|
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.
April 2011 - Posts
-
As a matter of security, it is typically recommended to disable the guest user account across your user databases. For system databases, of course you have a tough time disabling guest access for tempdb and master, which are peripherally required for Read More...
|
-
This evening SQL Sentry has pushed out a new build of Plan Explorer 1.2 (build #6.1.32), fixing a couple of minor issues brought to our attention by users. Eric Humphrey ( @lotsahelp ) pointed out that our query timeout for generating an actual plan was Read More...
|
-
On Friday, after Microsoft released the CTP, I talked a little bit about the changes you will see in SQL Server 2008 R2 SP1 . Namely: new rowcount-related columns in sys.dm_exec_query_stats; extended functionality of the FORCESEEK query hint; a new FORCESCAN Read More...
|
-
I wanted to change it up a little this week. In every digest, I've pointed out a set of Connect items that I believe deserve more attention. What I fail to point out every week is the number of Connect items that actually get resolved with a fix. These Read More...
|
-
Just as I was about to shut my machine down on a Friday, Microsoft goes and releases something we've been waiting on for a long time: a Community Technology Preview (CTP) for Service Pack 1 is finally available for testing! I want to talk about a couple Read More...
|
-
Last week at SQL Bits #8 in Brighton, England, SQL Sentry (my employer) announced its partnership with DBSophic , makers of the Qure workload management suite. Qure Workload Optimizer is a tool aimed at analyzing a workload and providing suggestions to Read More...
|
-
I woke up this morning fully intending to test a scenario on Denali CTP1. I was surprised to see that, after installing Windows Updates overnight and rebooting, my Denali instance was not running. I tried to start it from the Services applet, and received Read More...
|
-
Two years ago, I was involved in a worthwhile project that produced a book called SQL Server MVP Deep Dives - a collection of chapters written by 50 or so fellow MVPs, assembled in a single volume and sold to the masses. The unique component of this project Read More...
|
-
Many of you are probably asking, "Where is Service Pack 1 already?" Patience, friends. It will come in due time. In the meantime, you can see if any of the fixes in CU7 for RTM are applicable to symptoms you are experiencing (there are 33 fixes in total, Read More...
|
-
This week I decided to focus on a few suggestions revolving around automation and making certain tasks easier to script or deploy. The first one that came to mind was a recent request from Nicholas Cain ( blog | twitter ), asking for a SCHEMA_ONLY backup Read More...
|
-
This weekend I have been in England for SQL Bits 8 . Today I am in London preparing for a client visit, but I had a fun-filled few days by the sea in Brighton. I presented four different times at this conference: two vendor sessions on execution plan Read More...
|
-
This week I decided to focus on some of the long-outstanding issues with IntelliSense in Management Studio. While I know many of you are using 3rd party tools like RedGate's SQL Prompt, not everybody has that luxury - in my case, I can't justify a license Read More...
|
-
At SQL Bits I presented my "What's New in Denali?" deck in two different sessions - once on Friday to about 120 people, and once on Saturday to about 80 people. You can download the deck and samples below. Read More...
|
-
The Cupboards are Bare Over the weekend, and hopefully due to an event unrelated to April Fools' Day, you may have noticed that most or all of your Connect items have disappeared. At least for the SQL Server connection, you will see items that have been Read More...
|
-
Thomas LaRock started up "Meme Monday" (http://thomaslarock.com/2011/03/meme-monday/) - the first installation called for telling a story in 11 words or less (a la Hemingway). I used that exact number to express my amazement that I was able to finish a certain nagging project on time. Read More...
|
-
This week's digest is sponsored by two different concepts: "sargability" and "DDL triggers." Sargability #653206 : The optimizer should be able to understand the invertability of built-in intrinsics on dates for the purposes of index sargability Here Read More...
|
-
In Boston today I presented my "Bad Habits to Kick" deck to 66 people. You can download the deck and samples from the SQL Saturday web site or directly from http://bit.ly/AB-71-Slides . Like the Chicago event, folks were encouraged to submit feedback Read More...
|
|
|
|
|
|