Monthly Archive: April 2011

If you disable the guest user, please read this!

If you disable the guest user, please read this!

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...

A couple of fixes for Plan Explorer

A couple of fixes for Plan Explorer

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...

More changes you might not have noticed in SQL Server 2008 R2 SP1 CTP

More changes you might not have noticed in SQL Server 2008 R2 SP1 CTP

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...

Connect Digest : 2011-04-25

Connect Digest : 2011-04-25

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...

SQL Server 2008 R2 SP1 CTP is now available

SQL Server 2008 R2 SP1 CTP is now available

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...

Using Qure Workload Optimizer for SQL Sentry

Using Qure Workload Optimizer for SQL Sentry

Last week at SQL Bits #8 in Brighton, England, SentryOne announced its partnership with DBSophic, makers of the Qure workload management suite. Qure Workload Optimizer is a tool aimed at analyzing a workload and...

Your Denali installation will self-destruct in 5… 4… 3…

Your Denali installation will self-destruct in 5… 4… 3…

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...

SQL Server MVP Deep Dives Volume 2 : Operation Smile

SQL Server MVP Deep Dives Volume 2 : Operation Smile

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...

Cumulative Update #7 for SQL Server 2008 R2 is available

Cumulative Update #7 for SQL Server 2008 R2 is available

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...

Connect Digest : 2011-04-18

Connect Digest : 2011-04-18

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...

Connect Digest : 2011-04-11

Connect Digest : 2011-04-11

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...

SQL Bits 8: "What's New in SQL Server Denali?"

SQL Bits 8: "What's New in SQL Server Denali?"

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...

A couple of issues you might have noticed on Connect

A couple of issues you might have noticed on Connect

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...

Connect Digest : 2011-04-03

Connect Digest : 2011-04-03

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...

SQL Saturday #71, Boston: "T-SQL : Bad Habits to Kick"

SQL Saturday #71, Boston: "T-SQL : Bad Habits to Kick"

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...