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...

What’s the Mashup Engine?

I was testing something the other day and ran sp_who2 on a test instance. I saw this in the program listing: I had never seen the Mashup Engine listed...

Join me for a PASS Summit Pre-Con

I am very excited to announce I will be delivering a pre-conference session on SQL Server Performance Tuning on November 5th at PASS Summit 2019. If you have ever...

Yes, pulling just the data you need is really important.

I was asked the other day why a customer was having performance issues on a table. A simple SELECT that ... Continue reading

Interview with Andre Melancia

This is my second interview! This time with Andre who is a cat lover and great speaker! Here you can find the interview!

Should release cadence be slowed if you don’t have database load testing?

I got a question recently about a panel discussion on Database Development Disasters at SQL in the City Streamed. I had framed a question as, “how fast should development...

CISA Accredited Trainer!

My certification came in! I’m now accredited to provide training for the Certified Information Systems Auditor (CISA) certification. It’s not the Microsoft Certified Trainer (MCT) accreditation I once had...