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 and master, which are peripherally required for a lot of different types of activity. You have […]

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 our query timeout for generating an actual plan was set to 30 seconds. This was an […]

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 hint; a new FORCESCAN query hint; support for 15,000 partitions (to match new functionality added in […]

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 week is the number of Connect items that actually get resolved with a fix. These are […]

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 1 is finally available for testing! I want to talk about a couple of things that […]

Using Qure Workload Optimizer for SQL Sentry

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 improve the overall performance of that workload. These suggestions can […]

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 a single volume and sold to the masses. The unique component of this project was that […]

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 Nicholas Cain (blog | twitter), asking for a SCHEMA_ONLY backup option – to make moving a […]

Quick Recap of SQL Bits 8

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 analysis (showing off […]

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 has that luxury – in my case, I can't justify a license for every single server […]