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

Top 10 Recommended Books…

So the title says it all, right?  Well, only really partially.

Recently an article was published listing the top 10 most recommended books for SQL Server.  That’s the part the title doesn’t say.  It is really important to understand that we are talking about the top 10 recommended books for… Read more

0 comments, 327 reads

Posted in SQL RNNR on 29 July 2014

SSIS: Value does not Fall Within the Expected Range

Every now and again I find myself working with SSIS for one reason or another.  Every now and again I find myself fighting with SSIS because it provides less than useful error messages.  This is one of those error messages that can be a pain until you understand what can… Read more

0 comments, 8,680 reads

Posted in SQL RNNR on 17 July 2014

Murder In Denver

I am about to set sail on a new venture with my next official whistle stop.  This year has been plenty full of whistle stops and I plan on continuing.  You can read (in full) about previous whistle stops and why they are called whistle stops here.

Suffice it… Read more

2 comments, 230 reads

Posted in SQL RNNR on 14 July 2014

The SQL Sac wrap!!

Every SQL Saturday leaves a mark of some sort.  This time around, the folks in Sacramento have really helped leave a BIG mark.
That’s right, this last weekend was SQL Saturday in Sacramento Ca.  You might have seen my announcement about it here.

This event had a lot of… Read more

3 comments, 258 reads

Posted in SQL RNNR on 14 July 2014

Is your Team Willing to Take Control?

The calendar tells us that once again we have reached the second tuesday of the month.  In the SQL Community, this means a little party as many of you may already know.  This is the TSQL Tuesday Party.

This month represents the 56th installment of this party.  This institution was… Read more

0 comments, 201 reads

Posted in SQL RNNR on 8 July 2014

Free SQL Training In Sacramento

In a few short days the newest SQL Saturday event.  This one will be on the far West coast of the United States.

This marks the first time for me to present at a SQL Saturday so far West.  From where I live, I have had to travel East for… Read more

1 comments, 179 reads

Posted in SQL RNNR on 7 July 2014

Using Synonyms to Extend SSIS

There are a million and one uses for synonyms.  There are at least that many uses for SSIS.  The reality is, not all of those uses are good for you nor for your data nor for your database.

Recently I wrote an article about some good and some bad with… Read more

0 comments, 494 reads

Posted in SQL RNNR on 3 July 2014

Auditing and Event SubClasses

A recent discussion got me to thinking about Auditing.  To be honest, it got started with a complaint about some documentation that seemed overly light about the various fields related to auditing as it stands in SQL Server.

In talking to the person who raised the valid concern about the… Read more

2 comments, 1,058 reads

Posted in SQL RNNR on 28 May 2014

Can you partition a temporary table?

Reading that title, you might sit and wonder why you would ever want to partition a temporary table.  I too would wonder the same thing.  That withstanding, it is an interesting question that I wanted to investigate.

The investigation started with a fairly innocuous venture into showing some features that… Read more

5 comments, 1,640 reads

Posted in SQL RNNR on 23 May 2014

Supported Compatibility Levels in SQL Server

It has been well documented and is well known that SQL Server supports certain older versions of SQL Server in a compatibility mode.  This setting is something that can be configured on the database properties level.  You can quickly change to an older compatibility level or revert the change to… Read more

1 comments, 4,860 reads

Posted in SQL RNNR on 21 May 2014

Missing Indexes Script v2

Frequently we hear the analogy that <insert item here> is like opinions, everybody has one and not all of them are good (some may stink).

Well, this may just be another one of those <items>.  Whether it stinks or not may depend on your mileage.

I had shared a similar… Read more

10 comments, 3,003 reads

Posted in SQL RNNR on 15 May 2014

T-SQL Tuesday #54 – Interviews and Hiring

This month’s T-SQL Tuesday is hosted by Boris Hristov (blog|twitter) and his chosen topic is “Interviews and Hiring” – specifically interviewing and hiring of SQL Server Professionals.


This is a pretty interesting topic from a few different angles.  Boris proposed a few topics such as… Read more

1 comments, 1,221 reads

Posted in SQL RNNR on 14 May 2014

Omaha BI/SQL User Group – What?

I recently received an email from this guy named John Morehouse (blog | twitter) about the Omaha SQL/BI User Group Meeting in May.

Imagine my surprise when reading the email and discovering that I was presenting.

Here are the guts of that email.

Can you believe that it’s…

Read more

1 comments, 297 reads

Posted in SQL RNNR on 7 May 2014

T-SQL Tuesday #53 – Work Hard, Play Hard, Joke Hard

It is April and April Fools has only just begun.  Well, or so Matt Velic (blog | twitter) would have us believe.

Matt decided that this month for TSQL Tuesday, he would pull out all stops to help us break out the inner prankster in ourselves.

You can… Read more

2 comments, 382 reads

Posted in SQL RNNR on 8 April 2014

SQLSaturday Vegas Style

We are mere moments from the inaugural SQL Saturday (announced a few short months ago) event in fabulous Las Vegas, Nevada.  Can you feel the excitement building?

The SQLSat 295 team has been working hard to bring together what we think will be a great event.  From the… Read more

0 comments, 224 reads

Posted in SQL RNNR on 3 April 2014

New Backup Behavior in SQL 2014

As has been well publicized, today is the official Release To Manufacturing date for SQL Server 2014.  You can read more about all of that here.

Something that hasn’t received much word is a new feature that is a game changer.  I’m not referring to the advancements with the… Read more

1 comments, 429 reads

Posted in SQL RNNR on 1 April 2014

Table Space updated again

Today we have another update for an age old script on this site.  You can find the last update to the script here.

This time we have a bit of a bug update.  The details of that bug are in the notes for the script.

Read more

2 comments, 281 reads

Posted in SQL RNNR on 28 March 2014

T-SQL Tuesday #051: Bets and Results

The line for this months TSQL Tuesday required wagers be made concerning the risks and bets that have either been made or not made.

At close, we saw 17 people step up and place remarkable markers.  Today, we will recap the game and let you know who the overall winner… Read more

2 comments, 832 reads

Posted in SQL RNNR on 19 February 2014

Locks, Blocks, and Deadlocks Oh My!


Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this demo heavy session we will clear up the confusion.


Randy Knight, MCM, is an IT professional who has worked with… Read more

0 comments, 301 reads

Posted in SQL RNNR on 12 February 2014

Risking Health, Life and Family

Since announcing the topic last week for T-SQL Tuesday, I have thought about many different possibilities for my post.  All of them would have been really good examples.  The problem has not been the quality but in the end just settling on my wager for this hand.

You see, this… Read more

2 comments, 255 reads

Posted in SQL RNNR on 11 February 2014

Newer posts

Older posts