Loading to Azure from On-Prem SSIS
In my introduction to the topic of using SSIS in the cloud, I noted that SSIS is not currently available...
2017-03-02
396 reads
Tim Mitchell
- Interests: SQL Server, Data Warehousing, ETL, .NET development
- Twitter: @tim_mitchell
- Website: https://www.TimMitchell.net
The Psychology of Value
J.C. Penney is one of the oldest and most storied retailers still in existence in the United States. For years,...
2017-03-02
373 reads
Digital Privacy is the Wild West
Who has the legal right to access your personal and private digital assets? The answer can be complex, and will...
2017-02-27 (first published: 2017-02-23)
1,495 reads
Managing Bad Data
In the last post in my ongoing series about ETL best practices, I discussed the importance of error handling in ETL...
2017-02-21 (first published: 2017-02-16)
2,191 reads
Retrieve a List of Files from FTP using SSIS
The FTP protocol is one of the oldest methods for sharing and moving files. Although frequently considered to be an “old-school”...
2017-01-27 (first published: 2017-01-20)
1,498 reads
Upcoming Class: Building Better SSIS Packages in Pensacola
I’ll be teaching my popular day-long course, Building Better SSIS Packages, on Thursday, June 1 in Pensacola, Florida. This class...
2017-01-17
359 reads
What is ETL?
In my ongoing series on ETL Best Practices, I am illustrating a collection of extract-transform-load design patterns that have proven...
2017-01-16 (first published: 2017-01-06)
2,495 reads
The Side Project
When I first started working as a technologist some 17 years ago, I was doing fairly low-level stuff: moving and...
2017-01-11 (first published: 2017-01-04)
1,350 reads
Why Data Warehouse Projects Fail
Data warehouse projects are among the most visible and expensive initiatives an organization can undertake. Sadly, they are also among...
2017-01-10
1,084 reads
KPIs in SSRS 2016
Key performance indicators, or KPIs, are at-a-glance metrics for simple insight into the business. These are each designed to provide...
2016-12-30 (first published: 2016-12-22)
1,741 reads
Blogs
Moving T-SQL Tuesday to Jekyll
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
European Microsoft Fabric Community Conference announcements
By James Serra
A TON of new features announcements at the European Microsoft Fabric Community Conference help...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers