Monthly Archive: April 2011

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

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

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

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

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

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

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