Trekking through the DAX Jungle In Search of Lost Customers

I like to think I’m proficient at writing DAX and building SSAS tabular models. I enjoy a good challenge and...

Goodbye Pragmatic Works

Normally when I write a blog, I start out will a Hello to my Dear Reader.   Not today.  This was almost a blog I didn't write because I...

Goodbye Pragmatic Works

Normally when I write a blog, I start out will a Hello to my Dear Reader.   Not today.  This was...

How is SQL Server using more than the Max Server Memory?

As usual, the pager went off...

"Server is near 100% memory utilization - what is running?"
http://www.starshipearththebigpicture.com/wp-content/uploads/2015/09/red-alert-picard-300x228.jpgI saw when I signed on that...

I/O Baseline Comparison – Idera Diagnostic Manager

What servers need the most attention when it comes to I/O?  When I increase the memory on a server what effect does it have on I/O?  What was it...

I/O Baseline Comparison – Idera Diagnostic Manager

What servers need the most attention when it comes to I/O?  When I increase the memory on a server what...

Installation of SQL Server (Part 1 - Pre-installation)

I have been wanting to write this for a long time, and finally got time to do it. Which is...

SQL Saturday Chicago Precon – SQL Server Infrastructure – This Friday

This Friday I will be holding a precon training session at the next SQL Saturday in Chicago called ‘SQL Server Infrastructure...

Article Series: Power BI Solutions for the Enterprise

I’m working on a series of articles about creating enterprise solutions with Power BI and the first article was published...

From XML to JSON – script

Last Thursday I presented my session “From XML to JSON” in the Application Development PASS Virtual Chapter. The session is...