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

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,073 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, 163 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, 221 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, 146 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, 255 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

0 comments, 179 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, 602 reads

Posted in SQL RNNR on 19 February 2014

Locks, Blocks, and Deadlocks Oh My!

Abstract

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.

BIO

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

0 comments, 199 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, 163 reads

Posted in SQL RNNR on 11 February 2014

Murder in Richmond

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

Posted in SQL RNNR on 6 February 2014

T-SQL Tuesday #051: Place Your Bets

Place Your Bets

All bets on the table please.  This is the last call for bets, no new bets will be allowed.

This marks the 51st invitation for TSQL Tuesday.  This also marks what should have been the month of the first SQL Saturday event in Las Vegas.  But the… Read more

10 comments, 1,084 reads

Posted in SQL RNNR on 4 February 2014

Table Hierarchy updated

Recently a need resurfaced to explore the foreign key tree (hierarchy/genealogy) as it related to a specific table within a database.  As I pulled out the script from the repository, I realized there was some unfinished work to be done.  But there was also some polish that needed to be… Read more

0 comments, 242 reads

Posted in SQL RNNR on 21 January 2014

T-SQL Tuesday #050: Automating Database Restores

Here it is time for the party of the month for the SQL Server acolytes and I was running a bit behind.  Why?  Well, that was due in part to me rushing around trying to do some of what this months topic is.  Some would call that pretty could timing. Read more

1 comments, 200 reads

Posted in SQL RNNR on 14 January 2014

January 2014 S3OLV and Tabular Models

This is really late notice.  We had some extenuating circumstances this month and then a last minute cancellation.  Now that everything is squared away, we have some great news.

If you are in the Las Vegas area, you are welcome to attend our monthly meeting which is now being held… Read more

0 comments, 201 reads

Posted in SQL RNNR on 9 January 2014

Day 12 – High CPU and Bloat in Distribution

This is the final installment in the 12 day series for SQL tidbits during this holiday season.

Previous articles in this mini-series on quick tidbits:

  1. SQL Sat LV announcement
  2. Burning Time
  3. Reviewing Peers
  4. Broken Broker
  5. Peer Identity
  6. Lost in Space
  7. Command ‘n Conquer
  8. Ring in The New
  9. Queries Going Boom

Read more

0 comments, 190 reads

Posted in SQL RNNR on 6 January 2014

Day 11 – Purging syspolicy

This is the eleventh installment in the 12 day series for SQL tidbits during this holiday season.

Previous articles in this mini-series on quick tidbits:

  1. SQL Sat LV announcement
  2. Burning Time
  3. Reviewing Peers
  4. Broken Broker
  5. Peer Identity
  6. Lost in Space
  7. Command ‘n Conquer
  8. Ring in The New
  9. Queries Going Boom

Read more

2 comments, 941 reads

Posted in SQL RNNR on 4 January 2014

Day 10 – Retention of XE Session Data in a Table

This is the tenth installment in the 12 day series for SQL tidbits during this holiday season.

Previous articles in this mini-series on quick tidbits:

  1. SQL Sat LV announcement
  2. Burning Time
  3. Reviewing Peers
  4. Broken Broker
  5. Peer Identity
  6. Lost in Space
  7. Command ‘n Conquer
  8. Ring in The New
  9. Queries Going Boom

Read more

0 comments, 241 reads

Posted in SQL RNNR on 3 January 2014

Day 9 – Queries Going Boom

This is the ninth installment in the 12 day series for SQL tidbits during this holiday season.

Previous articles in this mini-series on quick tidbits:

  1. SQL Sat LV announcement
  2. Burning Time
  3. Reviewing Peers
  4. Broken Broker
  5. Peer Identity
  6. Lost in Space
  7. Command ‘n Conquer
  8. Ring in The New

Ever see an… Read more

4 comments, 246 reads

Posted in SQL RNNR on 2 January 2014

Day 8 – Ring in The New

This is the eighth installment in the 12 day series for SQL tidbits during this holiday season.

Previous articles in this mini-series on quick tidbits:

  1. SQL Sat LV announcement
  2. Burning Time
  3. Reviewing Peers
  4. Broken Broker
  5. Peer Identity
  6. Lost in Space
  7. Command ‘n Conquer

As tradition would have it, this is… Read more

0 comments, 150 reads

Posted in SQL RNNR on 1 January 2014

Day 7 – Command ‘n Conquer

This is the seventh installment in the 12 day series for SQL tidbits during this holiday season.

Previous articles in this mini-series on quick tidbits:

  1. SQL Sat LV announcement
  2. Burning Time
  3. Reviewing Peers
  4. Broken Broker
  5. Peer Identity
  6. Lost in Space

As a DBA, we sometimes like to shortcut things.  Not… Read more

5 comments, 164 reads

Posted in SQL RNNR on 31 December 2013

Newer posts

Older posts