My Ignite 2018 SQL PowerShell Scripts now available in GitHub

It appears that I forgot to post my SQL PowerShell Scripts from my talk at Ignite 2018 (video here). Big thanks to Tony Green ( t ) for bringing...

Visualizing NFL Draft History with Power BI

With the 2019 NFL Draft upon us, of course I wanted to visualize some NFL draft data in Power BI. So I put together this interesting set of visualizations...

SQLServerCentral Design–bbPress

This is part of a series of posts that look at the changes to the SQLServerCentral design, bringing us to v3 of the site. You can see the other...

A Cool Image

Maybe we can get Chris Spalton to do some of these for all our events? I really like it. Just a few days until SQL in the City Summit...

ASF 021: Guy in a Cube interview (part 1)

Introduction Guy in a Cube is all about helping you master business analytics on the Microsoft Business analytics stack to allow you to drive business growth. They are just...

Generate script to recreate indexes

For me, this particular code to generate a script to recreate indexes has more practical use in a replication environment. 

For example, the default replication setting is to exclude the...

SSIS 2019 has arrived!

It is not a joke: SSIS is available for Visual Studio 2019 as a preview. Whoa, hold on. SQL Server 2019 hasn’t been released yet? But there’s already an...

DMV - Active queries sorted by CPU usage

select
           s.session_id,

           db_name(s.database_id) DB,

           s.login_time,

           s.host_name,

           s.program_name,

           s.login_name,

           s.cpu_time,

           s.memory_usage,

           s.total_scheduled_time,

           s.total_elapsed_time,

           s.endpoint_id,

           s.last_request_start_time,

           s.last_request_end_time,

           s.reads,

           s.writes,

           s.logical_reads,

           s.is_user_process,

           s.row_count,

           s.open_transaction_count,

           t.text as [command]

from sys.dm_exec_sessions s

inner join sys.dm_exec_connections c...

Where should I clean my data?

As a follow-up to my blogs What product to use to transform my data? and Should I load structured data into my data lake?, I wanted to talk about where you...

Attending a climate protest for the first time

This is a blog devoted to databases, but for once I’m going to go off topic and talk about something I did at the weekend that I’ve never done...