This month, Rob Farley (Blog | @Rob_Farley) is running T-SQL Tuesday on plan operators. T-SQL Tuesday is a monthly blogging event where a number of us in the SQL Server community gets together to blog on a central topic. As mentioned, the topic is plan operators, or as Rob puts it: The topic is Plan Operators. If you ever … Continue reading T-SQL Tuesday – Evil Plan Operators – #TSQL2sDay
Today is the second Monday of June and guess what I didn't publish last week? That’s right, there wasn't an update and reminder to the SQL Server Monthly checklist. Not a big deal, of course, I was at TechEd with about 10,000 other people, talking about indexing SQL Server. Fortunately, for me, waiting a week … Continue reading June 2013 – Monthly SQL Server Checklist
During the keynote for TechEd North America 2013, Microsoft announced the planned release of SQL Server 2014. As part of this announcement, AlwaysOn Availability Groups will now support up to 8 readable secondaries, and include a number of improvements that will improve stability. While it hasn't been announced yet, it is probably safe to assume … Continue reading Looking to SQL Server 2014 High Availability In Standard Edition
This past Monday, I presented at TechEd North America for the first time. The session presented was Indexing Fundamentals for Microsoft SQL Server. Indexing is such a huge topic, that it was hard to boil down the fundamentals to a 75-minute presentation, but based on responses I think the resulting session was pretty good. If … Continue reading My TechEd Presentation: Indexing Fundamentals for Microsoft SQL Server
The other day Grant Fritchey (Blog | @GFritchey) linked out the video below. It's a quick little video, that isn't about the nail. As I watched it, it spoke volumes to me from both personal and professional experiences. Check it out quick and then I'll continue this blog post below. It's Not About the Nail from … Continue reading Thoughts About The Nail
As I mentioned in the introductory post, during 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: TRUNCATE TABLE Permissions
As I mentioned in the introductory post, during 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: Accessing SQL Server Securables
As I mentioned in the introductory post, during 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: Authentication Performance
As I mentioned in the introductory post, during 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: Difference between sysadmin and CONTROL SERVER Permission
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: Differences between “Grant” and “With Grant?”
Strate SQL 