Category:Uncategorized

I commend PASS, the PASS Board, and PASS leadership for all their hard work putting together this year’s PASS Summit. From the looks of the lineup of presenters and presentations the PASS Summit 2016 is going to be another awesome event! Allen White (@SQLRunr) serves as PASS Programs Director. Although Allen has been actively engaged …
Continue reading PASS Summit 2016 Speakers

Have you ever moved an SSIS project from one SSIS Catalog to another? With Catalog Environments and References? If you haven’t, you may be in for a surprise when you try. First, why should you try? “SSIS is software development.” – Andy, circa 2008 Best practices for software development apply to SSIS. One of those …
Continue reading Migrating SSIS Projects and Parameters, Part 1 is Live at SQL Server Central!

All software is tested. Some, intentionally. – Andy, circa 2010 I test software a lot. Why? Because all software is tested. Some software is tested intentionally. Some is tested by your soon-to-be-former-largest-customer. In this post I will show you how to build and deploy a very simple SSIS 2016 project and deploy it. Cool? Let’s …
Continue reading SSIS 2016: Building and Deploying a Simple Test Project

Creating an instance of the SSIS 2016 Catalog is identical to creating an SSIS Catalog in SQL Server 2012 or SQL Server 2014. Follow these steps to create an instance of the SSIS Catalog on SQL Server 2016. Open SQL Server Management Studio (SSMS) and connect to an instance of SQL Server. Once connected, open …
Continue reading SSIS 2016 Administration: Create the SSIS Catalog

The PASS Board has provided an updated Speaker Contract prior to announcing Summit speakers at the end of this month. In his post on the PASS Blog titled Improving the Speaker Contract, PASS president Adam Jorgensen provides a link to a PDF of the new contract and invites comments. Adam notes clauses 14, 15, and …
Continue reading PASS Provides an Updated Speaker Contract

Microsoft SQL Server Data Tools (SSDT) supports “deployment targets.” This means you can use the same Integrated Development Environment (IDE) to build SSIS packages targeted for deployment to the SSIS Catalog on a SQL Server 2012, 2014, or 2016 instance of SQL Server. When I open an SSIS solution built in SSDT-BI for SQL Server …
Continue reading Converting an SSIS 2014 Solution to SSIS 2016

There are lots of options when installing SQL Server 2016 Developer Edition. I am not going to exhaust them. I will, however, share how I set up SQL Server 2016 to begin learning about the relational engine, SSIS, and SSRS. First, you need SQL Server 2016 Developer Edition. I blogged about one way to obtain …
Continue reading Installing SQL Server 2016 Developer Edition, One Example

You can now download SQL Server 2016 Developer Edition – which is Enterprise Edition functionality with a license that forbids using the platform for Production purposes – for free. How? Join Visual Studio Dev Essentials. Once you join (for free!) you get access to lots of benefits – not just free SQL Server 2016 Developer: …
Continue reading SQL Server 2016 Developer Edition is Free

Biml is growing in popularity and it’s so cool to be a part of this awesome and growing community! This is not an exhaustive list, but here are some places you can go to learn and read more about Biml: Resources BimlScript.com Varigence Biml Forum at Varigence SQLServerCentral.com Stairway to Biml Biml User Group at …
Continue reading So You Want to Learn More About Biml?

This has come up a couple times (as in twice) over the past couple years, so I thought I’d put the question to my loyal readers (both of you, Hi Mom!) and see what you think. [sql] What’s the proper way to use social media? [/sql] I don’t want to limit the conversation to technical …
Continue reading Proper Use of Social Media