-->
Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Tim Mitchell

Tim Mitchell is a business intelligence consultant, author, trainer, and Microsoft Data Platform MVP with over thirteen years of data management experience. He is the founder and principal of Tyleris Data Solutions.

Tim has spoken at international and local events including the SQL PASS Summit, SQLBits, SQL Connections, along with dozens of tech fests, code camps, and SQL Saturday events. He is coauthor of the book SSIS Design Patterns, and is a contributing author on MVP Deep Dives 2.

You can visit his website and blog at TimMitchell.net or follow him on Twitter at @Tim_Mitchell.

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 apps were the clear standard for database apps. However, with the numerous advantages of building in or migrating to managed services, the cloud isn’t just a niche anymore. Managed services… Read more

1 comments, 179 reads

Posted in Tim Mitchell on 24 February 2017

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 depend on where you live, where you are traveling from and to, and whether or not you’ve been suspected of a crime. The rules governing personal digital access are evolving… Read more

2 comments, 694 reads

Posted in Tim Mitchell on 23 February 2017

Managing Bad Data

In the last post in my ongoing series about ETL best practices, I discussed the importance of error handling in ETL processes, reviewing best practices for application flow to prevent or gracefully recover from a systematic error or data anomaly. In this post, I’ll dig a bit further into that… Read more

2 comments, 1,564 reads

Posted in Tim Mitchell on 16 February 2017

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” way to transfer data, FTP is still relied upon in most every data movement architecture. Sadly, the functionality around FTP is very limited in SQL Server Integration Services. A… Read more

2 comments, 1,133 reads

Posted in Tim Mitchell on 20 January 2017

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 is being delivered in conjunction with SQL Saturday Pensacola. Registration is open to the public, and early-bird pricing is in effect until early May. Let me know if you have… Read more

0 comments, 112 reads

Posted in Tim Mitchell on 17 January 2017

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 the most likely to fail. At one time, Gartner reported that more than 50% of data warehouses would fail to make it to user acceptance. Because of the size of… Read more

4 comments, 530 reads

Posted in Tim Mitchell on 10 January 2017

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 to be highly effective. In the interest of comprehensive coverage on the topic, I am adding to the list an introductory prequel to address the fundamental question: What is ETL?… Read more

0 comments, 2,048 reads

Posted in Tim Mitchell on 6 January 2017

The Side Project

When I first started working as a technologist some 17 years ago, I was doing fairly low-level stuff: moving and reimaging computers, network cabling, and basic desktop support were the extent of my responsibilities. I decided early on that I wanted to move into a more advanced role, but faced… Read more

0 comments, 1,071 reads

Posted in Tim Mitchell on 4 January 2017

ETL Error Handling

In designing a proper ETL architecture, there are two key questions that must be answered. The first is, “What should this process do?” Defining the data start and end points, transformations, filtering, and other steps must be done before any other work can proceed. The second question that must be… Read more

3 comments, 185 reads

Posted in Tim Mitchell on 28 December 2016

Survey Results: Skipping the Holidays

Last week I posted a brief survey about working the holiday. To those who normally are not required to work the holidays, I asked if they would be willing to do so if the price was right, and if so, what that price would be (relative to what they normally… Read more

0 comments, 168 reads

Posted in Tim Mitchell on 27 December 2016

Survey: Skipping the Holidays?

For a little pre-holiday fun, I’ve got a simple scenario to present to you, and I am interested in your response. Your holiday plans are made. All of your family and friends expect to see you at the annual holiday gathering. Your kids are expecting you there on Christmas morning… Read more

3 comments, 160 reads

Posted in Tim Mitchell on 23 December 2016

SSIS Custom Logging Levels

In my ongoing series on ETL best practices, I recently wrote about the importance of logging in extract-transform-load processes. For users of later versions (2012 and beyond) of SQL Server Integration Services, adding logging to those ETL processes is very simple. Since logging is managed by the catalog, adding logging… Read more

3 comments, 183 reads

Posted in Tim Mitchell on 22 December 2016

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 a glimpse into one aspect of a measurable business activity. KPIs are present in various implementations in most every reporting tool, including SQL Server Reporting Services. Until recently, KPIs in… Read more

0 comments, 1,465 reads

Posted in Tim Mitchell on 22 December 2016

Report Portal in SSRS 2016

SQL Server Reporting Services benefits from a major update in SQL Server 2016, which is obvious from the first interaction with the product. The old and bland Report Manager interface has been replaced with a more modern portal that more effectively displays at-a-glance business answers. In this post, I’ll describe… Read more

3 comments, 184 reads

Posted in Tim Mitchell on 20 December 2016

The Trails We Leave

Over the weekend I got an email from have i been pwned, a website that tracks data breaches and notifies users whose information may have been compromised. The notification I received reported that my email may have been among some 4.9 million accounts whose information was compromised sometime in December… Read more

1 comments, 156 reads

Posted in Tim Mitchell on 19 December 2016

SSRS 2016: Great and Getting Better

Although I’ve been a regular user of SQL Server Reporting Services since it was released in the mid-2000s, I’ve done very little blogging about it. In fact, a quick search on my blog reveals that it has been almost five years since I wrote an SSRS-specific blog post. But let’s… Read more

1 comments, 178 reads

Posted in Tim Mitchell on 18 December 2016

SSIS Execution Status Lookup

The SSIS catalog comes packaged with a rich set of built-in reports that give those monitoring Integration Services a window into what has been happening inside the catalog. However, if you work with SSIS long enough, you’ll eventually need to write your own queries against the underlying tables. Of the… Read more

2 comments, 168 reads

Posted in Tim Mitchell on 17 December 2016

Unzip Files with SSIS

In my last post I shared how to build a package in SSIS to perform simple file archive (zip) operations. In this post, I’ll show you how to go the other direction and unzip files with SSIS. Unzip Files with SSIS Similar to the file zip operation, this solution uses… Read more

1 comments, 175 reads

Posted in Tim Mitchell on 16 December 2016

Zip Files in SSIS

Of the very many things SQL Server Integration Services does well, one of its shortcomings is that it does not have a built-in way to create compressed archive (ZIP) files. Generating such files is a common need in ETL processes, so it’s surprising that the fifth generation of SSIS still… Read more

5 comments, 175 reads

Posted in Tim Mitchell on 15 December 2016

SSIS Package Validation in the Catalog

Built into the SQL Server Integration Services catalog is the ability to run a validation without actually executing the package. Running a package validation in the SSIS catalog performs a high-level check against the underlying metadata to check for common points of failure (especially those related to data flows). SSIS… Read more

1 comments, 160 reads

Posted in Tim Mitchell on 14 December 2016

Older posts