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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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 [...]
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)
