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
691 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,026 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,994 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
767 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,797 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
839 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
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers