I probably did something dumb to cause this, but on the off chance it’s not (just) me I thought I would blog about it. I’ve been tinkering with SSIS 2016 in SQL Server 2016 CTP3. I set up a VM running Windows Server 2012 and installed the CTP along with SQL Server Data Tools for …
Continue reading VSTA Script Editor Not Displaying in VS2015 / SSIS 2016
Author:Andy Leonard
#sqlcares
After a couple long naps Saturday and Sunday, I’m almost caught up on sleep from last week. Ok, not really. But we were out really late most nights last week. As I told some people, “It has been dark for a couple hours already!” The PASS Summit is always a time for #SQLFamily to come …
Continue reading #sqlcares
#Biml at the PASS Summit 2015
I’m excited that PASS included Biml in the Summit 2015 this year. It’s the first year for this topic, at least officially. Unofficially, Biml topics have been presented the past couple years. The technology is maturing and receiving the exposure it so richly deserves. I’m honored be presenting Use Biml to Automate SSIS Design Patterns …
Continue reading #Biml at the PASS Summit 2015
Browsing the Catalog with SSIS Catalog Compare
One neat feature of SSIS Catalog Compare is the Catalog Browser. It’s a TreeView control that connects to the SSIS Catalog and displays handy information for Data Integration Administrators and Release Configurations people working in a DevOps enterprise. The Integration Services Catalogs node in SQL Server Management Studio’s (SSMS) Object Explorer provides this view of …
Continue reading Browsing the Catalog with SSIS Catalog Compare
SSIS Catalog Compare
It’s time to deploy that SSIS project from Development to Test, or from User Acceptance Testing to Production. Maybe it’s the very first time you’re deploying this project, maybe it’s the deployment of an upgrade or bug fix. Maybe you’re part of a team of data integration developers and you’re not sure if another team …
Continue reading SSIS Catalog Compare
BimlScript.com Relaunch!
The BimlScript.com website has been redesigned and relaunched by the good people at Varigence! The new site includes learning paths and tests. It’s almost as awesome as Biml. Go check it out today! :{> Bonus – check out the new BimlScript commercial!
Seeing Sharply
My technology career began as a curiosity in 1975. I was 11 years old and living next door to an elderly couple. Their son returned from an engineering career in the Air Force and began tinkering with a microprocessor kit. I was curious and he taught me Motorola 6800 machine language. After that, 40 years …
Continue reading Seeing Sharply
SQL Server 2016 Temporal Tables and Type II Data Warehouse Dimensions
SQL Server 2016 introduces temporal tables, an interesting and “data warehouse-y” addition to the relational database. So how do temporal tables work? They add a couple columns to a table that are used to track the date a row is inserted or last updated, based on the primary key. Suppose you have a row that …
Continue reading SQL Server 2016 Temporal Tables and Type II Data Warehouse Dimensions
Presenting at SQL Saturday 431–Spartanburg 26 Sep!
I am honored to present two sessions at SQL Saturday #431 in Spartanburg, SC on 26 Sep 2015! I will be delivering: Designing an SSIS Framework in 2015 Using Biml as an SSIS Design Patterns Engine SQL Saturday #431 also features two stellar precons: Transforming and Visualizing Data with Power BI by Patrick LeBlanc and …
Continue reading Presenting at SQL Saturday 431–Spartanburg 26 Sep!
Opinions Change
Opinions change, and they should change as more and better evidence surfaces. There are words for this: “learning” and “growing” are but two of them. Communication plays a key role in changing opinions. I’ve been studying communication recently and I’ve decided it’s a miracle anyone is ever able to communicate with anyone else. There are …
Continue reading Opinions Change
