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

The Murder Train chugs into Denver!

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. Recognizing this, last year my friend Jason Brimhall and I… Read more

0 comments, 91 reads

Posted in A Discussion of SQL Server-Related Topics on 13 August 2014

T-SQL Tuesday #57: SQL Family and Community

Well, here it is again. The second Tuesday of the month, which means that it’s T-SQL Tuesday. T-SQL Tuesday… that wonderful monthly blogging party started by Adam Machanic (Blog | @AdamMachanic). The intent is to get the entire SQL Community together on a monthly basis to blog about…

Read more

0 comments, 132 reads

Posted in A Discussion of SQL Server-Related Topics on 13 August 2014

The Murder train chugs into Raleigh

You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get going and bang! The times up. There’s only so much material that can be presented in just one hour. Recognizing this, last year my friend Jason Brimhall and I… Read more

0 comments, 100 reads

Posted in A Discussion of SQL Server-Related Topics on 11 August 2014

T-SQL Tuesday #56: Assumptions

Well, here it is again. The second Tuesday of the month, which means that it’s T-SQL Tuesday. This month, Dev Nambi (blog | twitter) is hosting the party, and he has decided that the topic is to be on Assumptions. Specifically, he wants us to write about:

A…

Read more

0 comments, 147 reads

Posted in A Discussion of SQL Server-Related Topics on 8 July 2014

Avoiding a split brain in database mirroring

You’re utilizing the database mirroring high-availability feature, configured to be in the High Safety mode with automatic failover, which means that the mirroring configuration includes having a witness server to ensure that the system can automatically switch over to the partner in the event of a failure of the principal. Read more

1 comments, 1,210 reads

Posted in A Discussion of SQL Server-Related Topics on 22 May 2014

Cannot start SSAS after install in tabular mode

After installing SSAS, using the tabular model, you receive the error “The service cannot be started: The following system error occurred:  A required privilege is not held by the client.” when trying to start the service.

Examining http://msdn.microsoft.com/en-us/library/ms175371.aspx shows that the only security privilege needed for the SSAS service account… Read more

4 comments, 835 reads

Posted in A Discussion of SQL Server-Related Topics on 13 May 2014

SQL Saturday RVA recap

Wow, what a month. On March 22, 2014, the SQL Saturday train came into Richmond VA (RVA). I was one of the organizers of the event, and what a ride we had.

The rough part of the ride started off earlier in the week. A freak spring snowstorm rolled through… Read more

0 comments, 154 reads

Posted in A Discussion of SQL Server-Related Topics on 28 March 2014

Presenting at the kickoff Lynchburg Va SQL User Group meeting

There’s a new SQL Server user group starting up over in Lynchburg, VA. It’s first meeting is February 27, 2014 (6pm-8pm), and I’m honored to be presenting there for their kickoff meeting. I’ll be presenting “Table Vars & Temp Tables – What you NEED to Know!” Visit http://lynchburg.sqlpass.org/ for more… Read more

0 comments, 95 reads

Posted in A Discussion of SQL Server-Related Topics on 17 February 2014

T-SQL Tuesday #51: Is this a bet worth making?

On the second Tuesday of each month, the SQL Server universe all comes together to blog about a topic. Known as T-SQL Tuesday and started by Adam Machanic (Blog | @AdamMachanic), this month’s T-SQL Tuesday topic is hosted by friend and fellow MCM Jason Brimhall (@sqlrnnr)… Read more

2 comments, 1,261 reads

Posted in A Discussion of SQL Server-Related Topics on 11 February 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,511 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, 190 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

1 comments, 180 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,068 reads

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

Are CHECKSUMs being performed with a Compressed Backup?

Now, why in the world would I be asking a question like this?
Well, in BOL (BACKUP) is this little blurb:

CHECKSUM
Specifies that the backup operation will verify each page for checksum and torn page, if enabled and available, and generate a checksum for the entire backup.…

Read more

3 comments, 1,354 reads

Posted in A Discussion of SQL Server-Related Topics on 30 December 2013

T-SQL Tuesday #48 – My take on the cloud

So here it is, the second Tuesday of the month. This means that it is time for our favorite Tuesday activity – the SQL world-wide blogging party know as T-SQL Tuesday. The brainchild of Adam Machanic, this is an event where for 24 hours, SQL bloggers will blog about a… Read more

1 comments, 185 reads

Posted in A Discussion of SQL Server-Related Topics on 13 November 2013

The Failed Job

I was looking into a failed job on a SQL Server 2008R2 instance. My first step was to check the history of the job, to see why it failed:

Okay, this is interesting. The job did fail, but the only step to run succeeded. Hmm, let me look at what… Read more

2 comments, 1,052 reads

Posted in A Discussion of SQL Server-Related Topics on 7 November 2013

Murder They Wrote

For those of you that know me, you know that I enjoy learning, and passing on what I have learned to others. As it turns out, this whole presenting thing has been an interesting path for me. (You can read more about the early disastrous presentations in my life here Read more

0 comments, 222 reads

Posted in A Discussion of SQL Server-Related Topics on 6 November 2013

Retiring of the MCM Certifications, Part II

Image acquired from Twitter

In my recent blog post on “Retiring of the MCM Certifications”, there is a link to a Microsoft Connect item that Jen Stirrup started (https://connect.microsoft.com/SQLServer/feedback/details/799431/please-dont-get-rid-of-the-mcm-and-mca-programs) to keep the MCM/MCSM/MCA program alive. A few hours after my post, Tim Sneath from Microsoft responded…

Read more

10 comments, 457 reads

Posted in A Discussion of SQL Server-Related Topics on 3 September 2013

Retiring of the MCM Certifications

The MCM is dead. Long live the MCM.

The small, exclusive club of SQL Server Microsoft Certified Masters is going to remain small and exclusive. This club, with less than 200 members world-wide, includes some of the biggest and brightest names in the SQL Server community. And Microsoft has decided… Read more

1 comments, 1,162 reads

Posted in A Discussion of SQL Server-Related Topics on 31 August 2013

It’s the small things that count

Sometimes it’s the small things that count.

I just noticed two small enhancements to SQL Server 2014′s BOL, and I can tell they are going to make my life easier.

How many times have you been developing a script, and you’re trying to make it work with multiple versions of… Read more

0 comments, 327 reads

Posted in A Discussion of SQL Server-Related Topics on 14 August 2013

Older posts