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

Archives: January 2014

SQL Prompt – new features in version 6.x

I’ve been using SQL Prompt for years. In September 2013, version 6 was released (quickly followed by 6.1 in late September and 6.2 in December ), so I thought I would highlight some of the new features available in it.

So lets start off with a table to show the… Read more

0 comments, 1,422 reads

Posted in A Discussion of SQL Server-Related Topics on 27 January 2014

Assumptions and clusters – the double whammy

I was recently investigating an issue that stemmed from a database being in the recovery_pending state. A quick investigation through the SQL logs showed that the server had restarted earlier that morning, and that this instance is running on a cluster. Assuming that this is probably just a timing issue,… Read more

0 comments, 166 reads

Posted in A Discussion of SQL Server-Related Topics on 20 January 2014

TSQL Tuesday #50 – Automation – Verifying the Backup Chain

I was recently just letting my mind wander. As it’s prone to do, all sorts of things just entered into it. Things like:

  • It’s a wonderful time of the year.
  • Lot’s of places I’m going to with #sqllearning potential.
  • There’s a lot of resolutions I need to work on.
  • Considering…

Read more

0 comments, 155 reads

Posted in A Discussion of SQL Server-Related Topics on 14 January 2014

Interview Questions – what to ask the company interviewing you

Previously, I posted a list of interview questions that I ask job candidates. This post is about the questions that I ask when I am the candidate. (Remember that interviews are two way – you are interviewing the company to see if you want to work for them just as… Read more

2 comments, 3,013 reads

Posted in A Discussion of SQL Server-Related Topics on 6 January 2014