As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions that there wasn’t time to answer. Instead of just a re-cap of all of the questions, instead I’ve opted to put together a post per topic. Hopefully, this will [...]
Index Analysis May Update
Seems I managed to make it through all of April without an update to the index analysis stored procedure. It wasn’t for lack of using it with clients, but a lack of time to get the changes out the door. A few months back, I added the option to look at just duplicate index or [...]
Security Questions: Grant Permissions to All Stored Procedures
As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions that there wasn’t time to answer. Instead of just a re-cap of all of the questions, instead I’ve opted to put together a post per topic. Hopefully, this will [...]
Security Questions: What permissions are required to create temporary tables?
As I mentioned in the introductory post, in the Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s, I received a large number of questions that there wasn’t time to answer. Instead of just a re-cap of all of the questions, instead I’ve opted to put together a post per topic. Hopefully, this will [...]
SQL Server Security Webcast Questions – Series Introduction
Earlier this month, I presented an Introduction to SQL Server Security session for Pragmatic Work’s Training on the T’s. A video of the session is available at the Pragmatic Works website. As a part of that session, I received a couple dozen questions about security that we didn’t have a chance to go over during [...]
Last Weeks Top “Reading” Links #33
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of things I find interesting. These tweets include “Reading” in the message and are items I’ve read over the past few days, usually after hours when sharing would be less than useful, and spaced out to [...]
Get Just The Tools: SSMS Download
Ever jump on a machine to connect to a SQL Server and find out… whoops! No tools. For some reason, the client machine doesn’t have SQL Server Management Studio (SSMS) installed. Now I’m not talking about not having the SSMS installed on the server, but on the local workstation that you need to connect to [...]
Last Weeks Top “Reading” Links #32
For those that follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet out some links of things I find interesting. These tweets include “Reading” in the message and are items I’ve read over the past few days, usually after hours when sharing would be less than useful, and spaced out to [...]
Reblog: May 3 to May 9
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront. As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value. Some posts from years gone by that you [...]
Presentation Materials “Discovering the Plan Cache” #SQLSat175
I’m a little late getting the information from my Fargo SQL Saturday session posted, titled ”Discovering the Plan Cache“. But it’s better a little late that never. Even though it was the end of the day, the session had great turnout and lots of good questions. Reviewing my session evals, I saw quite a few high [...]






_1262.png)

