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
696 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,029 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,698 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
53,324 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,154 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
625 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
769 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,800 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
845 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
708 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers