I wrote a book about practicing Data Integration Lifecycle Management with SSIS. In the book I explore tools I built to support DevOps with SSIS. Collectively, I call them the Data Integration Lifecycle Management Suite (DILM Suite). Many utilities at DILM Suite are free and some are open-source: SSIS Framework Community Edition – free, open-source, and …
Continue reading DevOps and SSIS and Azure Data Factory
Category:SQL Server
Website Ch-ch-changes…
Inspired by Frank La Vigne’s (blog | @Tableteer) snappy update to the Data Driven home page, I decided to spruce up a couple / three of my websites including this one, andyleonard.blog. I added the sidebar shown on the right of the site. It contains a more-readily-available search box and links to other websites I maintain – …
Continue reading Website Ch-ch-changes…
One Way to Connect PSDrive to a SQL Server Instance
“Everyone Stand Back! I’m Learning PowerShell!” I keep telling folks, “Learn new stuff” and “then blog about it!” I figured it’s time I take my own advice. I’m reading Learn Windows PowerShell in a Month of Lunches by Don Jones (@concentrateddon). I’m actually reading the first edition. I bought the book a while back and I’m …
Continue reading One Way to Connect PSDrive to a SQL Server Instance
OLE DB is *NOT* Deprecated
I cannot count how many times I’ve been asked about the deprecation of Microsoft OLE DB for SQL Server. My best guess? Hundreds of times over the years. My reply to questions has been: “I do not believe Microsoft will deprecate the OLE DB Driver for SQL Server.” In data integration circles, the announcement in …
Continue reading OLE DB is *NOT* Deprecated
SQL Server Management Studio v17.3
SQL Server Management Studio v17.3 has been released! You may want to save the URL because Microsoft seems to dropping the latest and greatest versions of SSMS there each and every time here lately. :{>
One Way to Install SQL Server 2017 Developer Edition
My intention in sharing this post it to help you install an instance of SQL Server 2017 Developer Edition. I accept most of the defaults in this installation, changing a few things that I only change in non-Production environments (like Mixed Mode Authentication for security). Please follow the advice of Microsoft and SQL Server professionals …
Continue reading One Way to Install SQL Server 2017 Developer Edition