Latest Blog Posts
In SQL, NULL means undefined value
Any SQL programmer can tell you that zero is not NULL, NULL is not zero, and NULL is not even equal to NULL either, because NULL means undefined. One undefined value cannot be equal to another undefined value.
In MDX, NULL means an empty…
Drill-down report is a common design
In SSRS, it’s a common design to allow users to drill down to more granular data in a same report.
In the following snapshot, users will see a summary line that shows the Call Handled 130. The two days, 11/4 and 11/5 will not… Read more
I’m finally completely recovered from a great week in Seattle last week for PASS Summit. Now that it’s back to the grind of regular work I thought I’d put together some thoughts and tell you about my experiences from the week.
You may have read others blogs about their experiences… Read more
It is once again time to come together as a community and talk about a common theme. This monthly gathering of the community has just reached it’s 5th anniversary. Yes, that’s right. We have been doing this for 60 months or five years at this point. That is pretty cool. Read more
This is a short blog series on using Power BI tools to support testing ETL processes. I have presented on this subject at few SQL Saturdays over the past few years and am finally succumbing to multiple request to turn it into a blog post. Realizing the amount of content… Read more
I’m just back from the PASS Summit 2014. What a great event. But this year, it was a little different. I did a lot of the usual things, presented a pre-conference seminar to about 130 people, helped out at the Red Gate booth, presented a session on execution plans on… Read more
I’m excited to announce that my Linchpin People colleague Reeves Smith and I will be delivering a full day Biml preconference seminar the day before the upcoming SQL Saturday in Washington, DC. This seminar, entitled “Getting Started with Biml”, will introduce attendees to the awesomeness of Business… Read more
So, here it is. I put the challenge out to discuss something new learned last week. I was fortunate enough to attend the PASS Summit last week in Seattle. While this post will not be my summarization of that trip (that will be another post) I did have several take-a-ways.… Read more
What have I learned recently? Well as it happens I learned something rather interesting recently and was actually trying to figure out how/when to post it. This month’s T-SQL Tuesday host Chris Yates (b/t) wants to know something we have learned recently so that seems like… Read more
Moving data from columns to rows can be a tricky task and accomplished in a variety of ways. That may be through a series of unions in T-SQL, but that’s just ugly and means lots of passes at the data potentially. You could use a T-SQL unpivot, which isn’t bad… Read more
Typically, making the output of an SSIS Package available to a client application for further processing is achieved by outputting the results to a Table in a Database or, maybe, to a file.
The application would then interrogate any of these sources and retrieve the data it needs.
However, what… Read more
What is T-SQL Tuesday?
T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party was started by Adam Machanic (blog|twitter). You can take part by posting your own participating post that fits the topic of the month and follows… Read more
It’s hard to believe it’s over. It felt like a whirlwind while I was in Seattle for my 7th PASS Summit, but now that I’m back home it feels like it was ages ago. I think time moves more quickly when you’re with friends and that’s where I was, with… Read more
This was one of those days I was waiting to happen. You might be wondering whats special? Yes, this day is very special because Rimma Nehme will be giving a keynote on Cloud Databases 101.
Just back from PASS Summit 2014 and I am feeling inspired about stepping it up a notch and starting to give back to the great community that has provided me with the knowledge to build my career over the years. Hopefully, I’ll be able to help a frustrated person out… 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
After I wrote about creating tables that contain the results I expected, I wondered if I could do the same thing with variables. I was thinking that I’d like to better self-document my tests, and I’d like to be able to do this:
declare @TimeElapsed.Expected int = 25;
It turns… Read more