Latest Blog Posts
It’s time for a monthly reminder to review you SQL Server environment. As with anything, just because it appears to be running well, doesn’t mean that there isn’t an unknown element causing issues today or in the near future.
A good way to review your environment is to… Read more
Business Intelligence Strategy
A business intelligence strategy is used to determine where an organization is and where they are going with their BI implementation. To start building an effective business intelligence strategy requires taking an objective look at your organizations BI capabilities including data, technology and people.
When you… Read more
This is the third post in the “Parameterization” series. In the previous post I mentioned parameter sniffing. This is a very important concept in SQL Server, and it certainly deserves a dedicated post. It’s time to dive into all the juicy details about parameter sniffing…
But first, let’s begin with… Read more
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need to solve a problem or answer a question. It’s that whole “cha-ching” – buried treasure! feeling. That’s kind of the aim of this… 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
- Don’t Get Slimed By Bad Parameter Sniffing
- Cheating DBCC To Fix Index Corruption
- Automated Source Control: A Librarian…
I Don’t Have to Do It Alone
I’ve always worked hard in my IT career to be knowledgeable in my field. I don’t like not… Read more
I gave what is officially my second presentation this week. I presented at the Triad SQL BI (Twitter | PASS) user group meeting and I didn’t hyperventilate! That’s a huge deal for someone like me, who is petrified of public speaking.
It started out a little rough though. Read more
Let’s raise some money, people.
TL;DR Donate to Doctors Without Borders, the Argenis Without Borders campaign.
What started out as a joke has grown, and we’re really looking to raise some money for this charity. I did my part
I started shopping, and I’ll be rainbow decked for the… Read more
Performance tuning often gets called an art as people feel that a certain knack or innate talent comes into play. And whilst I don’t disagree that a certain level of knowledge is involved, I completely disagree that only certain people can performance tune.
Given the correct approach, anyone should be… Read more
I think back to 15 years ago, when I was working retail and… Read more
Last month, I had the pleasure of presenting two of my favorite sessions at the SQLBits conference in Telford, UK.
A few days ago, all of the session recordings were uploaded to the SQLBits site.
Thursday night (8/28) I'll be presenting Inspector Insert And The Case Of The Mistaken IDENTITY for the Orlando SQL User Group (OPASS). Identity values seem like a straightforward topic but as SQL Server has evolved different methods for working with them have been introduced and each has caveats to… Read more
I’ve been told over the years that I’m pretty good at finding jobs. I mean in the last 25 years and 15 jobs or so (some contract positions) I’ve never been out of work for more than a month and a half at a time. I’ve always thought the methods… Read more
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…