Registrant Job Title Data from SQLSaturday Baton Rouge events 2014-2016

In a blog post on the Sparkhound website, I laid out the strong case for a sponsor's Return on Investment...

SQL SERVER DATABASE FILES WISE I/O LATENCY PART#2

Since the DMF sys.dm_io_virtual_file_stats shows cumulative I/O statistics value for the database files, you can’t just use the DMF to...

Trying to Solve the Wrong Problem

Some time back, while pulling into a local coffee shop, I spotted a stranded motorist in the parking lot. Per...

dbfs – command line access to SQL Server DMVs

With SQL Server on Linux, Microsoft has recognized that they’re opening up their products to a new set of users....

How the Initial VLF sequence number gets decided of the default transaction log file

In last three years, I presented two times on the topic Transaction Log File Architecture. During the sessions, when I discussed...

Where To From Fundamentals?

The Database Fundamentals series is now done. We started with understanding what a database is, and then spent a little...

How to Put SQL Column Names Onto Multiple Lines in SSMS

SQL in 60 Seconds is a series where I share SQL tips and tricks that you can learn and start using in less than a minute.

Watch this week's video...

Level Up Your SQL Server Cross Platform Skills With mssql-scripter

The ability to export a script of database objects has for a long time been a feature of SQL Server...

Microsoft Data Insights Summit Day 2 Recap: Timeline Storyteller, Future of Power BI Desktop, and Freakonomics

The theme of day 2 of the Microsoft Data Insights Summit was sessions, sessions, sessions! There were a ton of...

Microsoft Professional Program in Data Science – Continued

A couple of weeks back I blogged about my progress in the “Microsoft Professional Program in Data Science” curriculum. I’ve...