Latest Blog Posts
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
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
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
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
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
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
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
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
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
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
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
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
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
SQL SERVER – FIX – The database ‘model’ is marked RESTORING and is in a state that does not allow recovery to be run
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…
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…
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
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
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
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.