Honored to Present Moving Data with ADF at SQL Saturday Raleigh!

I am honored to present Moving Data with Azure Data Factory at SQL Saturday 863 – Raleigh 27 Apr!

Abstract

Azure Data Factory – ADF – is a cloud data engineering solution. ADF version 2 sports a snappy web GUI (graphical user interface) and supports the SSIS Integration Runtime (IR) – or “SSIS in the Cloud.”

Attend this session to learn:

  • How to build an ADF pipeline;
  • How to lift and shift SSIS to the Azure Data Factory integration Runtime; and
  • ADF Design Patterns to execute and monitor pipelines and packages.

Register today!
I hope to see you there.

:{>

One Way to Extract SQL Server 2017 Installation Media

In my post titled SSIS, Docker, and Windows Containers, Part 4 – Adding an SSIS Catalog, Attempt 2 I wrote about storing the SQL Server 2017 Developer Edition installation media in a directory. But I failed to explain how I do this.

This is how I store the SQL Server 2017 Developer Edition installation media in a directory.

Get the Download File

First download SQL Server 2017 Developer Edition. Note: If you browse to that link you will need to scroll to see the Download Now button for Developer Edition:

I blogged about one way to install SQL Server 2017 Developer Editionif you’d like to learn a little more. But I warn you, this post doesn’t describe many configuration options and should not be used to configure a production SQL Server 2017 instance.

Execute the SQL Server 2017 Download

When the SQL Server 2017 Developer Edition screen displays, click Download Media:

Select the File Type

I choose the ISO file type because I can mount ISO files as a drive in Windows 10:

Open the Download Folder

Once the download completes, click Open Folder:

Mount the ISO File

Windows 10 allows users to mount ISO files as a drive:

Copy the SQL Server 2017 Developer Edition Installation Media

Once the ISO file is mounted as a drive, users can select the contents of the ISO media and copy:

Copy the SQL Server 2017 Developer Edition Installation Media

Next, paste the media files into a directory for installation purposes:

Install SQL Server 2017 Developer Edition

Start setup.exe to begin the SQL Server 2017 Developer Edition installation:

Eject the ISO Drive

Anytime after copying the SQL Server 2017 Developer Edition installation media, you may “eject” the ISO media – which dismounts the ISO file – by right-clicking the assigned drive and clicking Eject:

Conclusion

You may use this method of copying any media from ISO files.

The Next Developing SSIS Data Flows with Labs Course Delivery is 17-18 Jun 2019

I’m excited to announce the next delivery of Developing SSIS Data Flows with Labs will be 17-18 Jun 2019! This two-day course takes a hands-on approach to introduce SSIS Data Flows with a combination of lecture and labs.

About Developing SSIS Data Flows with Labs

Data integration is the foundation of data science, machine learning, artificial intelligence, business intelligence, and enterprise data warehousing. This instructor-led training class is specifically designed for SQL Server Integration Services (SSIS) professionals responsible for developing data integration solutions for enterprise-scale Extract, Transform, and Load (ETL) who want to learn more about developing SSIS Data Flows.

You will learn to build data integration with SSIS Data Flows by:

– Learning SSIS Design Patterns.
– Working through hands-on lab exercises.
– Building efficient SSIS Data Flows.

Agenda

1. Introduction to the SSIS Data Flow Task.
2. Designing re-executable loaders with SSIS.
3. Building an Incremental Load design pattern.
4. Data type fundamentals in a real-world scenario.
5. Managing schemata changes to data sources.
6. Intermediate data staging.
7. Deriving to cleanse.
8. Repetition: Iterating file sources.

Space is limited.
Register today!

I hope to see you there.

:{>

The Next Mastering the SSIS Catalog Course Delivery is 11 Jun 2019

I’m excited to announce the next delivery of Mastering the SSIS Catalog will be the morning of 11 Jun 2019! This half-day course brings you up to speed on the SSIS Catalog quickly and efficiently, and we have great fun along the way.


About Mastering the SSIS Catalog

Data integration is the foundation of data science, machine learning, artificial intelligence, business intelligence, and enterprise data warehousing. This instructor-led training class is specifically designed for SQL Server Integration Services (SSIS) professionals and DBAs responsible for deploying, configuring, and managing data integration at enterprise-scale who want to learn more about the SSIS Catalog.

You will learn:
– Creating an SSIS Catalog
– Deploying SSIS projects to the SSIS Catalog
– SSIS Catalog Execution options
– Configuring connection strings and parameter values.

Agenda

1. Introducing the SSIS Catalog
2. Deploying SSIS projects.
3. SSIS execution options.
4. Configuring parameters and connection managers.

Register today!

I hope to see you there.

:{>

Honored to Present Moving Data with Azure Data Factory at SQL Saturday Atlanta 18 May!

I am honored to present Moving Data with Azure Data Factory at SQL Saturday 845 – Atlanta 18 May 2019!

Abstract

Azure Data Factory – ADF – is a cloud data engineering solution. ADF version 2 sports a snappy web GUI (graphical user interface) and supports the SSIS Integration Runtime (IR) – or “SSIS in the Cloud.”

Attend this session to learn:

  • How to build a “native ADF” pipeline;
  • How to lift and shift SSIS to the Azure Data Factory integration Runtime; and
  • ADF Design Patterns to execute and monitor pipelines and packages.

Register today. SQL Saturday – Atlanta is free but there are a limited number of seats available. The event historically sells out sooner rather than later and begins placing folks on the Wait List.

I hope to see you there!

:{>

Free Webinar: Loading Medical Data with SSIS

Enterprise Data & Analytics

Join Kent Bradshaw – Database Administrator, Developer, and Data Scientist – and me, Andy Leonard – Microsoft Data platform MVP, author, blogger, and Chief Data Engineer at Enterprise Data & Analytics as we present Loading Medical Data with SSIS at 12:00 PM EDT 17 Apr 2019.

Join this webinar and learn:

  • An SSIS design pattern for loading medical data
  • A pattern for scraping a website, downloading a zipped file, decompressing the file, and loading data contained therein

Register today.
I hope to see you there!

:{>

In the Beginning…

As I stated in the post titled Writing a Technical Book, “I am often asked for more information about writing a technical book.” In a follow-up post titled, One Way to Write a Technical Book, I state, [here] “I share details of my approach to writing a technical book.”

People reading these posts have asked questions about my process – how I go about doing the writing that will eventually become a book. I answered this question in part during an interview for Malathi Mahadevan’s (@sqlmal | Curious About Data blog) book titled Data Professionals at Work (which is a book that explores the habits of a handful of folks in the SQL Server Community). In this post I share the beginnings of writing, for me…

…Begin

In the beginning of the writing process, I begin.

A tautology? Maybe. It may be circular as well, but there are differences between the tautological and circular. Climbing back up the rabbit hole:

(click to enlarge)

This is the beginning of a book.

Will you see this chapter in print? Maybe. Will it read as it now reads? No. It will most likely be rewritten – more than once. Sometimes the edits are themselves circular in that it is edited to read one way and then edited to read as originally written.

Writing is funny like that.

Does that bother you? Does repetitious doing and then undoing – digging a hole and then filling it in – get under your skin? Does the inefficiency of it all drive you up the wall? If yes, writing may not be for you.

If writing is not for you, are you less of a technologist? Professional? Person? Goodness no! It’s just one thing that’s not your thing.

Know Why You’re Writing

In One Way to Write a Technical Book, I state, “I write because I love to write.” For me, that’s a powerful and pregnant statement. It means I cannot be plied with money or promises of fame (or clicks or page views). It means I write for me.

I find writing for me freeing. I believe being free results in me writing better; I know it results in me writing more. More is not always better except when it is better and writing more is better than writing less. One may will always edit.

I think why you write is the most important aspect of writing.

One Last Thing

If you find yourself thinking, “Someone should write more about / document this topic in plainer language / with better / more complete / real-world examples,” maybe that someone is you.

Conclusion

If you want to write, begin writing.

Don’t worry about the rest, not now. Just start. Start a blog. Start a manuscript. Start a channel. Put something out there.

In the beginning, begin.