Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: June 2013

Reblog: June 21 to June 27

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, 359 reads

Posted in StrateSQL on 28 June 2013

Last Weeks Top “Reading” Links #38

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, 397 reads

Posted in StrateSQL on 24 June 2013

Reblog: June 14 to June 20

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, 340 reads

Posted in StrateSQL on 21 June 2013

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, 246 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, 363 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?

Read more

4 comments, 263 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, 281 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

1 comments, 311 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, 314 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, 285 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

10 comments, 1,711 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, 273 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)

Read more

0 comments, 361 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, 379 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, 322 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, 281 reads

Posted in StrateSQL on 3 June 2013