Latest Blog Posts
With all of the work on a deployment pipeline and Continuous Integration (CI) and Continuous Delivery (CD) I’ve worked on, I thought it would be instructive to go see how the software developers build their product better. A few months ago I noticed that FlowCon 2014 was coming to San… Read more
No, this is not about politics. It’s about your WHERE clause… and your JOIN criteria… and your HAVING clause. It’s about a canard that still makes the rounds occasionally. Please, help me put this statement to sleep for once and all:
A function on the left side of the equals…
Imagine you have a requirement to capture the user accounts that log into your cube and based on their username they will only be permitted to see specific data. This can be accomplished by creating dynamic or table based security in Analysis Services which is much less difficult to setup… Read more
In case you do not receive the PASS connector, here are some announcements for this year’s summit on Nov 3rd – 7th.
Day 2 Keynote - Dr. Rimma Nehme from Jim Gray’s System Lab
Apparently, Dr. Mehme is a Polybase and query optimization expert from Microsoft and she will be… Read more
Here's how, including a picture…
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 Monday time for this week’s weekly link round-up. If you want to catch these links “live” (
so exciting), follow me on twitter (@StrateSQL). And see these throughout the day as I tweet out links of things I find interesting. While these links aren’t the answer… 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