Latest Blog Posts
I was recently called out by Tim Costello on a blog series started by Mike Walsh. http://www.interworks.com/blogs/tcostello/2014/08/27/4-things-i-wish-i-knew-sooner-bi-consultant
The series calls for each blogger to list 4 things they wish they had known sooner in their career as a data geek.
1) Knowing how to query data != DBA. You will… Read more
Last week we were at 332, this morning at about the same time we’re at 356. Not bad for a week that included Labor Day. Chart makes it look a little worse than it is, it shows the actual against the goal for the next report period.
Here’s… Read more
My summer event hiatus is coming to a close, and we’re now back into the conference and event season! I’ve spent the summer making some wild plans for new posts and research articles (and more) that I’ll be releasing on here this fall. Stay tuned for some exciting announcements!
I… Read more
I wrote about a basic PIVOT query recently. It’s an interesting way to write a query and turn row data into columns. That’s handy, and lots of people have a need for it. However I’d never used PIVOT in production code. I’ve always written a crosstab query instead.
If I… Read more
The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are the best information about what a query is doing and so how to improve it. However there are a couple of little commands that can be a big help too.… Read more
We use databases to store a lot of information. This can also include sensitive information we don’t want to give everyone access to. While we can use permission or views to ‘hide’ our sensitive information it will still be stored as plain text in our table. We can use column… Read more
A mid-tier SQL Server professional who may carry the title…
Our company, Heraflux Technologies, celebrated its first birthday today on September 1st. A very sincere thank you goes to all our clients, partners, family, #sqlfamily, and friends for your support! We look forward to another exciting year in business! Stay tuned to this blog and the Heraflux announcements,… Read more
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.