Tag Archives: sql server

Is It Time to Upgrade?

Posted on April 30, 2015 by way0utwest

There was a post from the SQL Server Data Platform Advisor the other day that noted it’s been almost 10 years since SQL Server 2005 was released and it’s time to upgrade. At least, if you want to remain in support. Microsoft … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Is It Time to Upgrade?

Searching for Plans

Posted on April 23, 2015 by way0utwest

Today’s editorial was originally published on Sept 13, 2010. It is being re-run as Steve is away at training. I was re-reading Conor Cunningham’s “Does Join Order Matter?” recently and found this quote in the post that stood out. As … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Searching for Plans

Embrace Stored Procedures

Posted on April 20, 2015 by way0utwest

I’ve read a lot of pieces on stored procedures. Most of the articles were for using stored procedures, quite a few were against their use, and a handful with extreme opinions. This piece from Rob Conery, while perhaps NSFW, is one … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Embrace Stored Procedures

ALTER SCHEMA TO ADD PERMISSIONS

Posted on March 18, 2015 by way0utwest

I’m sure some of you have wanted to do this: ALTER SCHEMA Steve AUTHORIZATION Steve You realize this doesn’t work, and you can’t grant the user Steve, rights to his schema after it’s created. You can do this: CREATE SCHEMA … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on ALTER SCHEMA TO ADD PERMISSIONS