Help for DBAs Who Support SSIS…
SSIS Catalog Compare helps DBAs work with their SSIS project configurations and catalogs, deploying changes from environment to environment.
2017-06-19
1,162 reads
Andy Leonard
- Interests: SQL Server, Integration Services, Managing Technical Teams, Faith, Family, Farming.
Training: Zero to BIML
A four-day course aimed at BI developers who want to use Business Intelligence Markup Language (BIML) to generate SQL Server Integration Services packages.
2017-05-25
3,411 reads
Migrating SSIS Projects and Parameters, Part 1
In this first part to looking at deploying SSIS packages to new environments, Andy Leonard looks at a few options for migrating your work to a new instance.
2016-06-21
4,747 reads
Data Warehouse Development: Version 0
What do you do first when developing a data warehouse? MVP Andy Leonard brings us a look at the foundation he uses, which might surprise you.
2011-04-07
9,085 reads
An Example of Test-Driven Development, Part 5
The fifth installment of this fantastic series by MVP Andy Leonard looks at database versioning. Be sure to read this one to continue learning more about TDD.
2010-11-26 (first published: 2009-08-20)
10,343 reads
An Example of Test-Driven Development, Part 4
Continuing on with his testing series for T-SQL code, MVP Andy Leonard looks at deployment here.
2010-11-19 (first published: 2009-07-15)
8,913 reads
An Example of Test-Driven Development, Part 3
Andy Leonard continues on with his series on TDD. This time he performs some refactoring on his solution.
2010-11-12 (first published: 2009-07-13)
10,636 reads
An Example of Test-Driven Development, Part 2
In this next installment of his series on TDD, MVP Andy Leonard continues the development of his database.
2010-11-05 (first published: 2009-06-16)
16,639 reads
An Example of Test-Driven Development
Developing a database can be an trying experience, and it's ways good to see how someone else builds a design. In this new article, MVP Andy Leonard shows us how to build a database using test-driven development for a weather database.
2010-10-29 (first published: 2009-04-30)
28,347 reads
SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers
SQL Server MVP and SSIS guru, Andy Leonard, discusses Integration Services and some of the tasks and containers that he uses quite often.
2010-02-05 (first published: 2008-08-21)
95,988 reads
Blogs
Using Prompt AI for a Travel Data Analysis
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
Forums
The North Star for the Year
Comments posted to this topic are about the item The North Star for the...
Multiple Escape Characters
Comments posted to this topic are about the item Multiple Escape Characters
reaching ftp thru winscp but erroring in ssis ftp task connection
Hi, below i show various results trying to reach our ftp site (a globalscape...
Question of the Day
Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers