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

Latest Blog Posts

Giving Back T-SQL Tuesday #61

First off I wanted to thank Wayne Sheffield (Twitter | Blog) for hosting this month’s T-SQL Tuesday party and Adam Machanic (Twitter | Blog) for starting this party five years ago. I can’t believe it’s been five years.

This month’s theme is Giving Back to the… Read more

1 comments, 3,465 reads

Posted in SQL Swimmer on 9 December 2014

T-SQL Tuesday no.61 - Giving Back!

 Tis the Season to Be Jolly, as well as giving, and T-SQL Tuesday’s timely topic on giving back to the SQL Community is brought to us by Mr. Wayne Sheffield (blog|twitter), who asks us, “In “The Spirit of Giving”, I want to know how you…

Read more

0 comments, 345 reads

Posted in Pearl Knows on 9 December 2014

SQL Server Configuration Manager giving Error : The remote procedure call failed. 0x800706be

Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server Configuration Manager.

Steps I perform to resolve the issue, Seems to be a WMI error :-

1) If using Window Server 2008 & above, Run command from command prompt… Read more

0 comments, 90 reads

Posted in MSSQLFUN on 9 December 2014

T-SQL Tuesday 61: A Season of Giving

Tis the season for TSQL Tuesday.  Not only is it that season again, but it is also the Holiday season.

During this season, many people start to think about all of the things for which they are thankful.  Many may start to think about their families and friends.  And many… Read more

0 comments, 83 reads

Posted in SQL RNNR on 9 December 2014

T-SQL Tuesday #61 – Giving Back

It just seems to me that these block parties of T-SQL Tuesday come quicker each month. I’m always thrilled when I have the opportunity to host or participate.

This month Wayne Sheffield (B|T) is our host. Wayne is good people, first time I got to meet… Read more

0 comments, 3,607 reads

Posted in The SQL Professor on 9 December 2014

Making a Change Log Easier With PowerShell

Having a Change Log is a good thing. A quick and simple place to find out what has changed on a server and when. This can be invaluable when troubleshooting, matching a change to a symptom especially when assessed alongside your performance counter collection. Here is a simple way to… Read more

0 comments, 3,420 reads

Posted in SQL DBA With A Beard on 8 December 2014

SQLSat in DC – it’s a wrap

This past weekend I had the opportunity to go visit Washington DC.  It was just the second time I got to stay in the Nation’s capitol for more than just a few hours.  The previous opportunity came with last years event which I talked about here.  Sadly, my time… Read more

2 comments, 72 reads

Posted in SQL RNNR on 8 December 2014

SQL Server Disk Space Emergencies

One of the things I’ll see happen often with SQL Server instances is that the system will run out of space on a drive. This could be for a variety of reasons, some of which can be prevented, and some cannot. You might have:

  • Don’t delete old backup files
  • Data…

Read more

0 comments, 5,333 reads

Posted in The Voice of the DBA on 8 December 2014

Starbucks Clover

I recently read  Onward: How Starbucks Fought for Its Life without Losing Its Soul  by  Howard Schultz. Not bad reading all in all. Part of it talked about the new Clover machine, the first time I had heard about it, though it’s been around quite a while. I… Read more

0 comments, 233 reads

Posted in SQLAndy on 8 December 2014

Murder in Charleston

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

0 comments, 105 reads

Posted in SQL RNNR on 8 December 2014

Dec HA & DR Virtual Chapter presentation – Multi-Subnet SQL Server Clustering

This month’s PASS High Availability and Disaster Recovery virtual chapter presentation is by Edwin Sarmiento ( b | t | l ) entitled “A Lap Around Multi-Subnet Clustering for SQL Server DBAs“. The presentation is Tuesday, December 9th at 12pm Central time. Come learn more about this advanced… Read more

0 comments, 89 reads

Posted in Technobabble by Klee from @kleegeek on 8 December 2014

Speaker of the Month: December 2014

For the month of November I was at the PASS Summit and Live360, so I didn’t get to find new speakers to see (heck, I didn’t get to see any sessions at Summit this year). But, that didn’t mean I didn’t get to see great speakers. I did (Rimma!… Read more

3 comments, 124 reads

Posted in The Scary DBA on 8 December 2014

sp_BackupDatabases v1.3

New version of sp_BackupDatabases released this morning, first update that I’ve made available in a while. I’ve been running this version myself for months, so it’s well-tested, I just forgot to post the update here.

Changes in this version:

– Include brackets around database name in all commands, in case… Read more

0 comments, 93 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 8 December 2014

DBTA – Cloud Computing Enhancements in SQL Server 2014


There’s no doubt that cloud computing is growing due to the strong cost benefits, simplified management, and reduced hosting complexities.  So it’s only fitting that we cap this series on the new features of Microsoft’s upcoming SQL Server 2014 (SQL2014) release of their flagship database by going over the… Read more

1 comments, 79 reads

Posted in Kevin E. Kline on 8 December 2014

SQL SERVER – FIX – The database ‘model’ is marked RESTORING and is in a state that does not allow recovery to be run

Originally posted on Journey to SQL Authority with Pinal Dave:
The best way one can learn SQL Server is by trying out things on their own and I am no different. I constantly am trying to explore the various options one can use when working with SQL Server. In…

Read more

0 comments, 217 reads

Posted in Coffee and SQL on 7 December 2014

SQL Azure Point-in-Time Restore

SQL Azure Point-in-Time Restore
OCTOBER 26, 2014

As a strategic direction, many companies have decided to start moving their SQL Server databases into the cloud using SQL Azure. This change in direction allows companies to outsource their hardware while moving to a “Database as a Service” model. One lesser known…

Read more

0 comments, 1 read

Posted in Pie in the Sky on 6 December 2014

Why Do People Leave a Good Company?


When people join a company, it’s usually with a sense of anticipation, of excitement, and of enthusiasm. They are ready to get started and to make a difference. Whether they are an individual contributor or a mid-level manager, the first day at a new company brings with it a… Read more

3 comments, 164 reads

Posted in Kevin E. Kline on 5 December 2014

Reblog: November 28 to December 4

Photo credit – Mike Lynch

A good cure to a creepy doll is a good old post that is still useful. In this post, I’m going back over some of the posts that came out in this week in previous years. Having looked over these from time to time, I’m… Read more

0 comments, 151 reads

Posted in StrateSQL on 5 December 2014

Speaker of the Month: November 2014

I have been very remiss in my blogging of late. Apologies.

One thing I haven’t blogged about is Speaker of the Month. I’m behind. So, I’ll be posting two of them over the next few days in order to catch up.

First up, Speaker of the Month for November.

I… Read more

1 comments, 119 reads

Posted in The Scary DBA on 5 December 2014

Friday Followup For December 5, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

  • Don’t Get Slimed By Bad Parameter Sniffing
  • Do You Need A Log Recovery Tool?
  • Building (for FREE) a…

Read more

0 comments, 122 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 5 December 2014

Newer posts

Older posts