Slow Running Query? Where do I Begin?

Maybe you’re new to SQL Server or maybe you’re just expanding into performance tuning a little more. Query tuning can...

Happy Holidays

It’s the time of the year again: the obligatory “how was the past year” blog post, combined with “what do...

Using a Variable to Populate the Query in a Lookup in SSIS

I encountered a situation on my last SSIS project in which I needed to be able to populate the query in lookup...

Tabular Models, Multiple Data Sources and Unknown Members

Self-service data modeling tools like Power BI Desktop, Power Pivot and SSAS Tabular promote the advantage of using data from...

What is an execution plan? When would you use it? How would you view the execution plan?

An execution plan is basically a road map that graphically or textually shows the data retrieval methods chosen by the...

What does that N in nvarchar really mean?

In any study of Data Types in SQL Server you are going to have to look at the various string...

Thank You for More Than You Realize

Blogging and presenting have changed me for the better, and in ways I didn’t see coming.  However, I know I wouldn’t have had them if it wasn’t for three things.  Getting...

Thank You for More Than You Realize

Blogging and presenting have changed me for the better, and in ways I didn’t see coming.  However, I know I wouldn’t...

Presentations & Blogging of 2015 in Review

Another year is coming to an end and I am doing a review of which goals I have managed to...

Top 10 Enhancements to Azure SQL Database in 2015

Top 10 Enhancements to Azure SQL Database in 2015
DECEMBER 27, 2015

Introduction2015 has been a massive year for Azure SQL Database. This year has seen the product mature from "an...