Metadata Hygiene
Those who follow my blog know that I write a lot about data quality. Measuring and improving the quality of...
2017-03-09
417 reads
Tim Mitchell
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
426 reads
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
379 reads
Is Your Database App Ready for the Cloud?
The cloud has evolved. Just a few years ago, cloud-based applications were the exception rather than the rule, and on-premises...
2017-03-03 (first published: 2017-02-24)
2,206 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,498 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,206 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,507 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
368 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,099 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,507 reads
Blogs
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers