Learning Goals–January Review

In December I participated in T-SQL Tuesday #97 and wrote a post about 2018 goals. I promptly spent two weeks...

Wait Statistics on a Query

Wait statistics are a vital part of understanding what is causing your system to run slowly. Capturing them can be...

SQL Homework – February 2018 – Work with security

This month let’s create some security!
Create logins: GUI 5 pts/Script 5 pts

Create a SQL login and a Windows authenticated login....

Forensic Analysis of Log files in SQL Server

The Importance of Log Files in SQL Server
On the SQL server every day we perform many transactions and as we...

Giving back – Speaking Mentors

I’ve been incredibly lucky in my career. I’ve somehow managed to meet and become friends with highly talented people who...

PASS Summit 2017 Wrap-Up - The People!

I need a new social media profile picture.
That’s one of the most important (non-technical) conclusions I drew from my week at PASS Summit 2017. It seemed like everywhere I...

Power BI with Azure Data Lake - where the water doesn't run dry

(2018-Feb-04) I've had a case working with very large data files as a source for my heat map visualizations in...

Re-Imagining an SSIS IDE

Re-Imagining the SSIS development environment.

oooh:

ahhh:

SSIS is a powerful and versatile tool for extracting, transforming and loading data into or out...

Re-Imagining an SSIS IDE

Re-Imagining the SSIS development environment.
oooh:
ahhh:
SSIS is a powerful and versatile tool for extracting, transforming and loading data into or out of SQL Server. The development environment, BIDS...

Re-Imagining an SSIS IDE

Re-Imagining the SSIS development environment.
oooh:
ahhh:
SSIS is a powerful and versatile tool for extracting, transforming and loading data into...