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

The Murder Train is pulling into Iowa City

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. And if there are a lot of questions, you may… Read more

0 comments, 81 reads

Posted in A Discussion of SQL Server-Related Topics on 11 May 2015

T-SQL Tuesday #61 – The Wrap-Up

Earlier this month, I hosted the 61st occurrence of the monthly TSQL-Tuesday blogging party. With a topic of “Giving Back”, it had a great turnout (27 party-goers). As I read through all of their posts, I noticed that many are planning to give back in pretty predictable ways… Read more

0 comments, 399 reads

Posted in A Discussion of SQL Server-Related Topics on 31 December 2014

TSQL Tuesday #61: How I plan on Giving Back

A little over 5 years ago, Adam Machanic (B|T) had this great idea of getting everyone in the SQL Community to all blog about a specific topic on the second Tuesday of the month. This monthly “blogging party” has a host, aka party organizer, that decides… Read more

0 comments, 158 reads

Posted in A Discussion of SQL Server-Related Topics on 9 December 2014

T-SQL Tuesday #61 – Giving Back

The Season of Giving

The annual PASS Summit (otherwise known as the #SQLFamily reunion) is over. Here in the United States, we have just finished celebrating Thanksgiving, where the average person consumes more calories in two hours than what they need for a week. And we are entering the season… Read more

23 comments, 5,397 reads

Posted in A Discussion of SQL Server-Related Topics on 2 December 2014

The Murder Train is making a stop in Salt Lake City

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

Posted in A Discussion of SQL Server-Related Topics on 16 October 2014

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, 168 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, 197 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, 183 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

1 comments, 246 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,755 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, 1,112 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, 281 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, 214 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

4 comments, 1,390 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,819 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, 267 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, 270 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,299 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,571 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, 264 reads

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

Older posts