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

Archives: April 2013

Last Weeks Top “Reading” Links #30

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

Posted in StrateSQL on 29 April 2013

Reblog: April 19 to April 25

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

1 comments, 373 reads

Posted in StrateSQL on 26 April 2013

5 SQL Server White Papers Every DBA Should Read

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… Read more

10 comments, 415 reads

Posted in StrateSQL on 25 April 2013

Fargo SQL Saturday (#SQLSat175) Schedule Is This Weekend

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),… Read more

0 comments, 197 reads

Posted in StrateSQL on 23 April 2013

Restoring Azure SQL Database to a Local Server

In last week’s post, I talked about the steps required to backup a Azure SQL Database.  That post leaves us asking what’s the use of having a backup of a database, if you aren’t going to restore it somewhere.  And more importantly, if you can’t restore a database, or… Read more

1 comments, 2,344 reads

Posted in StrateSQL on 23 April 2013

Last Weeks Top “Reading” Links #29

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

Posted in StrateSQL on 22 April 2013

Reblog: April 12 to April 18

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

Posted in StrateSQL on 19 April 2013

Backing Up Azure SQL Database to the Cloud

When I first started working with Azure SQL Databases, I wasn’t sure what it would take to backup a database.  In fact, I wasn’t even sure if this concept was appropriate when it came to databases hosted in “the cloud”.  What I found was that the concept of backing up… Read more

5 comments, 555 reads

Posted in StrateSQL on 18 April 2013

A Replacement for DBCC IND in SQL Server 2012

Each release of SQL Server is chalk full of new features and an assorted amount of bells and whistles.  Some of these, like Availability Groups and ColumnStore, are great additions and their introduction includes much fanfare.  Among all of those new features, is the occasional little bell which offers us… Read more

4 comments, 1,707 reads

Posted in StrateSQL on 17 April 2013

Last Weeks Top “Reading” Links #28

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

Posted in StrateSQL on 15 April 2013

Presentation Materials “What Are You Waiting For?” #SQLSat211

After lunch, I led the session “What Are You Waiting For?” at SQL Saturday Chicago #211.  It was another well-received session and the attendees definitely learned a lot about the value in wait stat analysis.  The only downside, was my snap decision to add an extended event demo… Read more

1 comments, 114 reads

Posted in StrateSQL on 13 April 2013

Presentation Materials “Discovering the Plan Cache” #SQLSat211


Just got done with my morning session, titled ”Discovering the Plan Cache“, for SQL Saturday Chicago #211 and wanted to get out my session deck and scripts for people.  The session got pretty high marks from the attendees and people seemed to get a lot of good information… Read more

2 comments, 123 reads

Posted in StrateSQL on 13 April 2013

Reblog: April 5 to April 11

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

Posted in StrateSQL on 12 April 2013

I See BI People

A tweet from Ted Krueger (Blog | @Onpnt) this morning…

inspired a little creativity…

 

Read more

0 comments, 320 reads

Posted in StrateSQL on 11 April 2013

Entertainment for the Traveling Consultant (UltraViolet Review)

Like many of us, I have a collection of favorite movies. These include Ghostbusters, Stripes, Serenity, and dozens more. I don’t always want to watch specific movies, but when the mood hits, it’s great to be able to grab one or another and relax for the the evening. Unfortunately, DVDs… Read more

4 comments, 330 reads

Posted in StrateSQL on 11 April 2013

Staggering SQLIO Sessions Across Multiple Volumes

In a previous post, I discussed running SQLIO against multiple files.  The purpose in using multiple files is being able to test not just a single volume’s capability to deliver data from storage, but to test the storage as a whole.  Doing so is important since, what ever application,… Read more

1 comments, 910 reads

Posted in StrateSQL on 10 April 2013

T-SQL Tuesday – Love For Presenting – #TSQL2sDay

This month, Bob Pusateri (Blog | @SQLBob) is running T-SQL Tuesday on presenting.  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. The topic that was chosen for this month is… Read more

2 comments, 234 reads

Posted in StrateSQL on 9 April 2013

Presentation Materials “Discovering the Plan Cache” #SQLSat206


This past weekend, I took a quick trek into the land of beer and cheese for the second annual Madison SQL Saturday event.  The event was a great success, but  can you expect less when one of the organizers is wielding a light saber.  For a change this time, instead… Read more

0 comments, 199 reads

Posted in StrateSQL on 8 April 2013

Chicago SQL Saturday (#SQLSat211) Is This Weekend


The Chicago SQL Saturday is coming up this weekend on Saturday, April 13th.  If you are waiting until the last minute to register to join in on the training, better stop waiting because the last open slots may be filling up.  I’ll be there (with the unicorn somewhere near by)… Read more

0 comments, 228 reads

Posted in StrateSQL on 8 April 2013

Last Weeks Top “Reading” Links #27

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

Posted in StrateSQL on 8 April 2013

Older posts