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 … Continue reading Index Analysis May Update
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 … Continue reading 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 … Continue reading Security Questions: What permissions are required to create temporary tables?
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 … Continue reading SQL Server Security Webcast Questions – Series Introduction
Updated June, 2016 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 … Continue reading Get Just The Tools: SSMS Download
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 … Continue reading Presentation Materials “Discovering the Plan Cache” #SQLSat175
Last Thursday, I delivered a presentation for Pragmatic Works Training on the T's. The session for last week was Introduction to SQL Server Security, a part of last month's series of introductory presentations. The abstract for the sessions is: One of the most often overlooked feature sets of SQL Server is it's security features. The focus … Continue reading Webcast Presentation Materials: Introduction to SQL Server Security
It's the start of the month of May, or at least the first Monday in May. Hopefully you aren't nursing too much pain from a weekend that included two fairly dissimilar holidays. First, there was Star Wars Day on Saturday. Followed by Cinco de Mayo on Sunday. There should have been something in there for … Continue reading May 2013 – Monthly SQL Server Checklist
There are countless sources for information on SQL Server available today. There are books, webcasts, conferences, and blogs. With all of these sources, it is easy to forget that there are white papers available from Microsoft. It is important that we make an effort to read the white papers that are available. The trouble is, … Continue reading 5 SQL Server White Papers Every DBA Should Read
We are down to the last few days before first SQL Saturday in Fargo. It's been some work pulling it all together, but with the help of Ted Krueger (Blog | @Onpnt), Sarah Strate (Blog | @DanceM0m), and Jes Borland (Blog | @grrl_geek), we are almost ready for the weekend. The question I have for you is... … Continue reading Fargo SQL Saturday (#SQLSat175) Schedule Is This Weekend
Strate SQL 