Moron's Guide to SSIS : Episode 2 - Introduction to the Dataflow
Today Pragmatic Works release it’s second comedic training video featuring Dustin Ryan as “Dustin” and Brian Knight as “Gary” Dustin’s...
2009-06-19
690 reads
Devin Knight
Enabling Checkpoints in your SSIS Packages
Checkpoints are a great tool in SSIS that many developers go years without even experimenting with. I hope to enlighten...
2009-06-18
13,025 reads
Better Know A SSIS Transform – The Pivot Transform
This is part 1 of my 29 part series called Better Know A SSIS Transform. Hopefully you will find the...
2009-06-15
1,693 reads
Answers to Advanced SSIS Interview Questions
Last week I wrote a set of Advanced SSIS Interview Questions. Here are the answers I came up for these. ...
2009-06-12
52,883 reads
SQL Saturday Pensacola
I just returned from another great SQL Saturday event today. Rodney Landrum and Karla Remail put together a great event...
2009-06-06
1,153 reads
Moron's Guide to SSIS : Episode 1 - Introduction to the Environment
Today Pragmatic Works release it’s first comedic training video featuring Dustin Ryan as “Dustin” and Brian Knight as “Gary” Dustin’s boss. ...
2009-06-04
621 reads
SQL Saturday 14 Pensacola
I will be speaking this Saturday at the SQL Saturday in Pensacola. The topic will be SSIS Best Practices and Performance Tuning. ...
2009-06-04
766 reads
Advanced SSIS Interview Questions
I wrote a blog about a year ago that gave some tips on basic interview questions that you may run...
2009-06-04
3,796 reads
First Foundation Class Review
The first Pragmatic Works Foundation class concluded today and I think it was a great success! Each student did very...
2009-04-17
828 reads
Pragmatic Works Foundation Class
This week I've been extremely busy working on the new Pragmatic Works Foundation class, which is the brainchild of Brian...
2009-04-15
704 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
Forums
Having Issue deploying a report to an on prem server from PowerBI desktop
Using PowerBI Version1.25.9508.3237(January 2026). Installed Microsoft Power BI Desktop (Optimized for Power BI Report...
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers