Last Weeks Top “Reading” Links #37
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… Read more
0 comments, 93 reads
Posted in StrateSQL on 17 June 2013
Reblog: June 7 to June 13
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… Read more
0 comments, 156 reads
Posted in StrateSQL on 14 June 2013
The Side Effect of NOLOCK (video)
A while back I put together a blog post on the side effect of NOLOCK. Today I thought I’d push out a video of the issue, in hopes of reaching more people and changing more minds.
What are your thoughts?
4 comments, 129 reads
Posted in StrateSQL on 13 June 2013
Security Questions: Migrate Logins Between Servers
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… Read more
2 comments, 128 reads
Posted in StrateSQL on 13 June 2013
Security Questions: SQL Agent 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… Read more
0 comments, 124 reads
Posted in StrateSQL on 12 June 2013
T-SQL Tuesday – Evil Plan Operators – #TSQL2sDay
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… Read more
1 comments, 120 reads
Posted in StrateSQL on 11 June 2013
June 2013 – Monthly SQL Server Checklist
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,… Read more
0 comments, 124 reads
Posted in StrateSQL on 10 June 2013
Looking to SQL Server 2014 High Availability In Standard Edition
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… Read more
3 comments, 1,169 reads
Posted in StrateSQL on 10 June 2013
Last Weeks Top “Reading” Links #36
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… Read more
0 comments, 123 reads
Posted in StrateSQL on 10 June 2013
Temporary Post Used For Theme Detection (a44a873d-b704-4244-9b75-dfa7037289c9 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (155546b7-60c9-4c5a-baba-268c38ebcf1a – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
10 comments, 141 reads
Posted in StrateSQL on 8 June 2013
Reblog: May 31 to June 6
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… Read more
0 comments, 157 reads
Posted in StrateSQL on 7 June 2013
My TechEd Presentation: Indexing Fundamentals for Microsoft SQL Server
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… Read more
2 comments, 179 reads
Posted in StrateSQL on 6 June 2013
Last Weeks Top “Reading” Links #35
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… Read more
0 comments, 125 reads
Posted in StrateSQL on 3 June 2013
Thoughts About The Nail
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… Read more
5 comments, 140 reads
Posted in StrateSQL on 31 May 2013
Reblog: May 24 to May 30
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… Read more
0 comments, 123 reads
Posted in StrateSQL on 31 May 2013
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… Read more
5 comments, 142 reads
Posted in StrateSQL on 30 May 2013
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… Read more
5 comments, 643 reads
Posted in StrateSQL on 29 May 2013
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… Read more
1 comments, 135 reads
Posted in StrateSQL on 28 May 2013
Security Questions: Difference between sysadmin and CONTROL SERVER Permission
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… Read more
1 comments, 131 reads
Posted in StrateSQL on 27 May 2013
Last Weeks Top “Reading” Links #34
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… Read more
0 comments, 132 reads
Posted in StrateSQL on 27 May 2013



Subscribe to this blog