This post is inspired by Kenneth Fisher’s [blog | @sqlstudent144] post, An interview with me. Ken suggested, “Now if any other bloggers read this and feel like answering questions too I’d love to read them so make sure you put a link to your blog down in the comments below.” I’m in! 1. What are …
Continue reading An Interview With Me
Category:Uncategorized
DLM (Database Lifecycle Management)
As I type, SQL in the City Streamed is running on another monitor, and Alex Yates [DLM Consultants | @_AlexYates_] is screaming (almost), “Don’t do that!” I know a lot of data professionals. I know some of you read this blog. And I know some of you who read this blog are concerned about Database …
Continue reading DLM (Database Lifecycle Management)
SSIS Catalog Browser Update
SSIS Catalog Browser has been updated! Catalog Browser is part of the DILM Suite of utilities designed to assist enterprises with Data Integration Lifecycle Management (DILM). And it’s free. Catalog Browser provides a rich view of SSIS Catalog contents, configuration, and metadata. The utility surfaces properties, environment variables, environment variable values, references, reference mappings, and …
Continue reading SSIS Catalog Browser Update
SQL Server Management Studio (SSMS) v16.5.1 Now Available
An updated version of SQL Server Management Studio (SSMS) for SQL Server 2016 (v16.5.1) is now available. :{>
Learn More About the SSIS Catalog
Update: The Recordings for SSIS Academy: Using the SSIS Catalog are Available Join Kent Bradshaw and me for three free webinars about the SSIS Catalog! SSIS Academy: Using the SSIS Catalog is Tuesday – Thursday, 27-29 Dec 2016. Attend and learn how to: Deploy an SSIS Project Execute one or more SSIS packages Monitor execution results …
Continue reading Learn More About the SSIS Catalog
Broken References in the SSIS Catalog
It’s possible to create a broken reference in the SSIS Catalog. What’s a “broken reference?” Let’s begin by explaining SSIS Catalog References. I wrote a lengthy explanation of SSIS Catalog References and Environments in SSIS Catalog Environments – Step 20 of the Stairway to Integration Services at SQL Server Central. Microsoft has a good article …
Continue reading Broken References in the SSIS Catalog
A Tale of Software Development, Testing, and Demos
Public Failure and Humiliation I delivered an SSIS Academy presentation yesterday, the first of many (I hope). You can view the recording here (free, but registration required). If you watch around the 57:30 mark, you will notice I encounter a bug in SSIS Catalog Compare around 59:15. My subsequent demo of CatCompare – the command-line …
Continue reading A Tale of Software Development, Testing, and Demos
Deploying SSIS Projects to a Restored SSIS Catalog (SSISDB)
You’re coding away with SSIS, happy as a clam, and it’s now time to deploy your hard work to an instance of the SSIS Catalog. If you’re in Visual Studio, you right-click the project name in Solution Explorer and click Deploy. If you’ve been given an ISPAC file, you double-click it in Windows Explorer. Either …
Continue reading Deploying SSIS Projects to a Restored SSIS Catalog (SSISDB)
New Versions of SSMS and SSDT Available
It’s Release Day! 🙂 New versions of SQL Server Data Tools (SSDT) are available here. SSDT 16.5 and 17.0 (RC1) are available. Also available are Data-Tier Application Framework (DacFx) versions 16.5 and 17.0 (RC1). New versions of SQL Server Management Studio (SSMS) are available here. SSMS 16.5 and 17.0 (RC1) versions are available for SSMS. …
Continue reading New Versions of SSMS and SSDT Available
SQL Server vNext Evaluation Edition Now Available
You can download SQL Server vNext Evaluation Edition here. Today! :{>