Skip to Content

Uncategorized Posts

The SQL Hall of Shame

Posted June 14, 2017

By

SQL Server is a big product, with lots of features. Many of the features—hopefully the vast majority of them—are solid and allow us to build trustworthy,... more »
96

Learn DAX, data modeling, and data visualization after MS Data Insight Summit #dax #powerbi #dataviz

Posted June 14, 2017

By

I spent three days in Seattle at Microsoft Data Insight Summit, delivering a preconference day about data modeling for business users, and two workshops about... more »
0

DevOps and your database

Posted June 12, 2017

By

I’m a consultant. That means I have to deal with whatever I come across at customer sites. I can recommend change, but when I’m called in to fix something,... more »
0

Signal Processing and Near-Real-Time Data Integration

Posted June 12, 2017

By

Years ago I worked in manufacturing automation. I wrote ladder logic (and machine code and even a little C) mostly for Allen-Bradley and GE Fanuc PLCs... more »
0

SQL Server 2016 Import and Export Wizard and Excel

Posted June 11, 2017

By

SQL Server 2016 is a 64-bit application and it comes with two versions of the Import and Export Wizard. If you launch the Import/Export Wizard from the SSMS,... more »
1

Logging wait stats over time

Posted June 08, 2017

By

We all know how valuable wait statistics can be when doing performance analysis. One thing I feel is missing in SQL Server is a trail of various... more »
0

“Yes, I Personally Deliver Consulting Services”

Posted June 08, 2017

By

I’m consulting and coaching a client in Washington state this week and they told me the same thing I hear regularly from other clients, “We didn’t know... more »
0

Introducing Data Driven Data Points

Posted June 07, 2017

By

Frank came up with a great name for mini-shows at Data Driven: Data Points. These are shows we usually stream live to the Data Driven Facebook page and then... more »
0

User group meetings and #dax training in Minneapolis and Chicago

Posted June 07, 2017

By

In the next three weeks I will deliver many speeches and training in United States. Here is the list: June 11, 2017: Precon Data Modeling with Power BI at... more »
0

BI Beginner: Using R Visualizations

Posted June 04, 2017

By

Last week I showed a simple line plot of a hypothetical college student’s GPA. The plot could have been done using R. Before showing you a visualization that... more »
0