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

Archives: January 2014

Reblog: January 24 to January 30

Photo credit – Husso

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need to solve a problem or answer a question. It’s that whole “cha-ching” – buried treasure! feeling. That’s kind of the aim of this… Read more

0 comments, 194 reads

Posted in StrateSQL on 31 January 2014

Have You Studied SQL Server Enough?

Photo Credit – yum9me

SQL Server is a fairly big and complicated product.  There are quite a few areas that you can study, the database engine, Analysis Service, T-SQL development, and many others.  As you delve into each of these areas, how do you know when you’ve studied any area… Read more

4 comments, 268 reads

Posted in StrateSQL on 29 January 2014

February 2014 – SQL Server Monthly Maintenance Checklist

It’s a cold, cold day here in Minnesota.  A great day for staying in and working on some in-home tasks.  Maybe take some time to double check the furnace, check the air filter, and verify that all of the windows of the house are locked and sealed.  At… Read more

1 comments, 184 reads

Posted in StrateSQL on 27 January 2014

Last Weeks Top “Reading” Links #68

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow me on twitter (@StrateSQL).  And see these throughout the day as I tweet out links of things I find interesting.  While these links aren’t the answer… Read more

1 comments, 236 reads

Posted in StrateSQL on 27 January 2014

Does @StrateSQL Need a Unicorn Tattoo?

As I mentioned in a post a couple weeks back, I’ll be jumping into Lake Calhoun in a few weeks as part of the Minnesota Polar Plunge.  For this event, they cut a hole in the ice and allow us brave souls to jump into the lake and play… Read more

2 comments, 132 reads

Posted in StrateSQL on 26 January 2014

Reblog: January 17 to January 23

Photo credit – Mike Lynch

A good cure to a creepy doll is a good old post that is still useful. In this post, I’m going back over some of the posts that came out in this week in previous years. Having looked over these from time to time, I’m… Read more

0 comments, 196 reads

Posted in StrateSQL on 24 January 2014

Webcast Follow-Up: The Flavors of Non-Clustered Indexes

Earlier today, I presented a session for Pragmatic Works Training on the T’s titled The Flavors of Non-Clustered Indexes.  In the session, I discussed non-clustered indexes and some of the options available for building them.  It’s a topic I talk about often but is always an important one.

The… Read more

1 comments, 169 reads

Posted in StrateSQL on 23 January 2014

Last Weeks Top “Reading” Links #67

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow me on twitter (@StrateSQL).  And see these throughout the day as I tweet out links of things I find interesting.  While these links aren’t the answer… Read more

0 comments, 200 reads

Posted in StrateSQL on 20 January 2014

Reblog: January 10 to January 16

Photo credit – Jenn and Tony Bot

Sometimes old stuff is just as cool as new stuff. Over the past few years, I’ve written a few things that are worth a revisit from time to time. In this post, you’ll find a list of previous year’s blog posts that came… Read more

0 comments, 178 reads

Posted in StrateSQL on 17 January 2014

Webcast Follow-Up: Necessary Evils, Building Optimized CRUD Procedures

Earlier today, I presented a session for Pragmatic Works Training on the T’s titled Necessary Evils, Building Optimized CRUD Procedures.  In the session, I discussed some of the issues surrounding the use of CRUD-based stored procedures and the applications that use them.  Providing a number of tips for identifying… Read more

0 comments, 141 reads

Posted in StrateSQL on 16 January 2014

2014 Polar Plunge #SQLPlunge

In just a couple months… on March 1… I’m going to jump into a lake in Minnesota.  Now it’s cold in Minnesota.  In fact, they’re going to have cut a hole in the ice so that we can do this.

Why are me and a few friends doing this?  Well,… Read more

2 comments, 122 reads

Posted in StrateSQL on 14 January 2014

Last Weeks Top “Reading” Links #66

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow me on twitter (@StrateSQL).  And see these throughout the day as I tweet out links of things I find interesting.  While these links aren’t the answer… Read more

1 comments, 241 reads

Posted in StrateSQL on 13 January 2014

The DBA That Practices Database Restores

We are often told that we need to practice our restores. And it might not be obvious, but the reason is so that you remain cool, calm, and collected, like this grandma, in the face of adversity.

Read more

0 comments, 180 reads

Posted in StrateSQL on 10 January 2014

Reblog: January 3 to January 9

Photo credit – JStove

Old posts are like unicorns. You might see them just once, but it’d sure be nice to have them come back around every not and then. This connection might not make that much sense, but face it… there’s no such things as unicorns, so I can… Read more

0 comments, 107 reads

Posted in StrateSQL on 10 January 2014

I’m Speaking at the PASS BA Conference

This May PASS will be hosting their second annual Business Analytics (BA) Conference in San Jose, CA.  The conference brings business analysts together with IT pros for an opportunity to connect and learn together.  The idea being that through our shared experiences we can transform business with the power of… Read more

0 comments, 96 reads

Posted in StrateSQL on 7 January 2014

January 2014 – Monthly SQL Server Checklist

It’s the first Monday of 2014.  Time for a new year and some resolutions to be a better DBA.  Unlike a gym resolution, though, it’s time to make sure that you this resolution doesn’t fall by the wayside.  While SQL Server environments can run fine for days, weeks,… Read more

1 comments, 234 reads

Posted in StrateSQL on 6 January 2014

Last Weeks Top “Reading” Links #65

It’s Monday time for this week’s weekly link round-up.  If you want to catch these links “live” (so exciting), follow me on twitter (@StrateSQL).  And see these throughout the day as I tweet out links of things I find interesting.  While these links aren’t the answer… Read more

1 comments, 257 reads

Posted in StrateSQL on 6 January 2014

Reblog: December 27 to January 2

Photo credit – Scott Howard

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need to solve a problem or answer a question.  It’s that whole “cha-ching” – buried treasure! feeling.  That’s kind of the aim of… Read more

0 comments, 114 reads

Posted in StrateSQL on 3 January 2014

Wrapping Up 2013

Last year, I did a wrap up post of the year (also 2011 and 2010) to see where I landed from where I wanted to be.  At the end of that post, I came up with a number of goals for the year.  Now’s the time to see how… Read more

2 comments, 141 reads

Posted in StrateSQL on 1 January 2014