Latest Blog Posts
As I mentioned earlier, we use Perforce as our source control package, so all of the scripts presented here are written for Perforce. I’ll try to clearly explain, in terms of source control, the functional parts of the script, so that you can easily transfer this to your own… Read more
This is part of a series of tips for speakers to make your presentations better.
I wanted to give some specific SQL Server presentation items that have bothered me recently. These aren’t big things, but they do cause problems for attendees, and that might mean the difference between someone learning… Read more
Registration is 332 as of 8 am on August 26. We added a whopping 40 registrations last week – a very good week! Our standard Tuesday email will go out about 10 am this morning with topics on MVP’s in attendance and lunch. On Friday we’ll have our first “special”… Read more
I was having a discussion the other day and was quite surprised to hear that there still appears to be a slight misconception regarding being able to use indexed views on web or standard editions of SQL server. As it stands the documentation clearly states that you can create and… Read more
The 3rdcumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 3 contains all the hotfixes released since the initial release of SQL Server 2014 RTM.
Those who are facing severe issues with their environment, they can plan to test… Read more
If one instance in a multiserver query presents an error, no resultsets from any of the other instances are displayed, even if n "row(s) affected)" is displayed in the Messages tab.
This is particularly painful when querying dynamic management objects across server…
Anything we can do to automate our builds and deployment should be considered. After all, the point isn’t just to write code, but to deploy working code. So what if we did the automated builds and deployed them to development or QA? No errors, so I’m good, right?
Not so… Read more
Today, I face issue during one database restore. I am not able to restore because “Database is in use, Not able to take exclusive lock”. I have killed all the user sessions & stop the application but still we are facing this issue.
Further going into details, I found that… Read more
This is a quick demo of a little “trick” with heaps I’ve known about for a couple of years. However until recently I could never duplicate it on purpose. (You can read that as I’ve had a production problem bite me in the …. repeatedly.) At least I couldn’t duplicated… Read more
I assume that by now you’ve tried the script from Part 1, and have seen how easy it is to script out your database objects using Powershell. The resulting scripts are the standard DDL scripts that you can generate from Management Studio, and for most of us, are just… Read more
This is the second post in my series on parameterization. In the first post I wrote about plan caching and about the phases that each batch goes through before execution. I ended the previous post with a query example that demonstrates the importance of parameterization. For this post I’m going… Read more
I received some great news this week, my session about wait statistics is selected for SQLSaturday #336 in Utrecht, Holland!
This will be my first SQLSaturday as a speaker and I am really looking forward to it!
There are more than 160 sessions submitted by great SQL Server experts around… Read more
On August 12th, 2014, another infamous ‘patch-Tuesday,’ Microsoft released a series of Security Updates for multiple versions of SQL Server, to deal with potential Denial of Service attacks and an exploit in Master Data Services. After attempting to make my way through hundreds of instances already, and all… 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 just checked in again on our LinkedIn campaign, had a couple days with good impression counts. We can still only tie 1 registration to all of the LinkedIn effort so far. Keep going, or ? I think I’m going to see if I can change the URL to a… Read more
A few friends challenged me yesterday, including Grant Fritchey and Aaron Bertrand. Last night, when I got to the Denver SQL Server User Group meeting, Todd Kleinhans was ready to take the challenge and asked if I’d participate.
I was speaking, but happy to do it afterwards. Here we… Read more
Got this in morning email from Khan Academy. Not sure if I agree that we all can learn anything, but I love the video anyway because the best lesson to learn is that learning takes time, effort, and stumbles. I watch my own kids struggle with this, and think how… 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.
Posts That Were Popular This Week
I don’t mind saying that amyotrophic lateral sclerosis (ALS), also known as Lou Gehrig’s disease, scares me. A degenerative disease that takes away the minds ability to control the body, leaving the mind intact… words fail me. Add to that the fact that there is no known cure, and that… Read more
Here's the link to a .zip file to download the slide deck and all sample files: http://1drv.ms/VH3mda