Monthly Archive: April 2011
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...
Tip : Using DMVs to Adjust SQL Server Resource Governor Settings
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...
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...
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...
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...
Beta versions and evaluation editions expire, but you can keep it from ruining your day…
Some details behind a second collaborative book project with MVPs.
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...
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...
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...
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...
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 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...
I will be delivering my Deep Dives 2 draft on time.
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...
In Boston today I presented my "Bad Habits to Kick" deck to 66 people. You can download the deck and samples from the SQLSaturday web site or directly from http://bit.ly/AB-71-Slides. Like the Chicago event,...