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
413 reads
Those who follow my blog know that I write a lot about data quality. Measuring and improving the quality of...
2017-03-09
413 reads
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,204 reads
In my introduction to the topic of using SSIS in the cloud, I noted that SSIS is not currently available...
2017-03-02
422 reads
J.C. Penney is one of the oldest and most storied retailers still in existence in the United States. For years,...
2017-03-02
376 reads
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,496 reads
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,204 reads
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,505 reads
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
363 reads
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,504 reads
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,357 reads
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item DBCC CHECKIDENT
What is returned as a result set when I run this command without a new seed value?
See possible answers