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

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, 213 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, 231 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, 210 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, 987 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, 278 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

5 comments, 287 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, 163 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, 188 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, 194 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, 208 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, 200 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, 426 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, 214 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, 229 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, 226 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, 257 reads

Posted in SQL RNNR on 10 December 2013

SQL Claus and BI at S3OLV

Tis the season once again.  We have SQL gifts a plenty for any and all who wish to partake.

This month, we have Stacia Misner (twitter) that will be playing SQL Clause for the Las Vegas chapter of PASS.  In this season of giving, it is nice to… Read more

0 comments, 188 reads

Posted in SQL RNNR on 10 December 2013

Cloud Nirvana

T-SQL Tuesday is a recurring blog party, that is started by Adam Machanic (Blog | @AdamMachanic). Each month a blog will host the party, and everyone that want’s to can write a blog about a specific subject.

This month the subject is “Cloud Atlas”. If you want to… Read more

1 comments, 161 reads

Posted in SQL RNNR on 12 November 2013

Murder They Wrote

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

4 comments, 226 reads

Posted in SQL RNNR on 5 November 2013

Scaring a Database Near you

Something I have a hard time by-passing is a good R2 unit.  I have R2 units in so many different forms, including a standing R2 cake one year for my birthday.  So when I cam across this R2 unit, I just had to share it.

That is a pumpkin carved… Read more

0 comments, 285 reads

Posted in SQL RNNR on 31 October 2013

Newer posts

Older posts