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

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, 195 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

3 comments, 252 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,191 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, 271 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, 217 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

1 comments, 234 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, 213 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, 1,003 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, 288 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

7 comments, 297 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, 169 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, 206 reads

Posted in SQL RNNR on 31 December 2013

Day 6 – Lost in Space

This is the sixth 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

One of the more frequently recurring themes I see in my travel and… Read more

2 comments, 210 reads

Posted in SQL RNNR on 30 December 2013

Day 5 – Peer Identity

This is the fifth 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

In the digital age it seems we are constantly flooded with articles about identity crises.… Read more

1 comments, 217 reads

Posted in SQL RNNR on 29 December 2013

Day 4 – Broken Broker

This is the fourth 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

Brokers

 

 

 

 

On a recent opportunity to restore a database for a client, I… Read more

0 comments, 215 reads

Posted in SQL RNNR on 28 December 2013

Day 3 – Reviewing Peers

This is the third 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

Remember back in the day when Napster was really popular?  I’m sure it is still popular now – just… Read more

1 comments, 437 reads

Posted in SQL RNNR on 27 December 2013

12 Days of Christmas 2013 Day 2

This is the second 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

Recently I was able to observe an interesting exchange between a couple of key people at a client.  That exchange gave… Read more

3 comments, 222 reads

Posted in SQL RNNR on 26 December 2013

12 Days of Christmas 2013 Day 1

Last year I did a mini-series themed around the 12 Days of Christmas.  I am going to do a similar series this year.  Over the next 12 days, I will share short tidbits on an array of topics.  The tidbit may be a tip to help with SQL Server,… Read more

10 comments, 235 reads

Posted in SQL RNNR on 25 December 2013

DC SQLSat

This past weekend I had the opportunity to go visit Washington DC.  It was the first time I got to stay in the Nation’s capitol for more than just a few hours.  It is also the first time that I was able to see any of the monuments in the… Read more

1 comments, 238 reads

Posted in SQL RNNR on 11 December 2013

To DBA or Not to DBA (DBA Jumpstart)

This post is part of the SQL Community Project started by John Sansom called #DBAJumpStart.
“If you could give a DBA just one piece of advice, what would it be?”
John asked 20 successful and experienced SQL Server professionals this exact question. I share my own thoughts with you below…

Read more

3 comments, 262 reads

Posted in SQL RNNR on 10 December 2013

Newer posts

Older posts