Azure Data Factory v2 with Mike Flasko

One of the sessions I was most looking forward to at Microsoft Ignite 2017 was New capabilities for data integration in the cloud with Mike Flasko. In that session, he talks about Azure Data Factory (ADF) v2 and its new first-class SSIS support.

After the session, I convinced Mike Flasko and Sanjay Krishnamurthi to have a chat with me :) We talked about what’s new in Azure Data Factory v2, including the updated pipeline application model with a new visual design canvas, new Software Development Kits (SDKs) for working with Azure Data Factory, the new Integration Runtime, and the ability to run SSIS packages inside Azure Data Factory v2.

Azure Data Factory v2 with Mike Flasko

Follow Mike Flasko on Twitter @mflasko, and keep an eye out for more news about ADF and SSIS! I may or may not have convinced him to do another interview with me in a couple of months :)

Thank you Mike and Sanjay for sitting down with me on a busy day! If you were unable to attend Microsoft Ignite 2017, you can now watch Mike’s session New capabilities for data integration in the cloud on-demand:

Other interviews from Microsoft Ignite 2017

Data Science with Buck Woody
SQL Server 2017 with Bob Ward
High Performance Analytics with Sunil Agarwal

SQL Server 2017 with Bob Ward

During Microsoft Ignite 2017, I got to interview one of the nicest guys in Microsoft, Bob Ward! :)

In this interview, we chat about SQL Server 2017, SQL Server on Linux, Adaptive Query Processing, Auto Plan Correction and Columnstore Indexes.

SQL Server 2017 with Bob Ward – Microsoft Ignite 2017

You can read all of Bob Ward’s articles on his blog SQL Server According to Bob. Most of his slide decks and demos are published on aka.ms/bobwardms, and you can follow him on Twitter @bobwardms.

I know Bob had a very busy schedule at Microsoft Ignite, so I’m very thankful he was able to spend a few minutes with me! I hope you find this as interesting as I did :) If you want to learn even more, you can watch his session Experience Microsoft SQL Server 2017: The fast and the furious from Microsoft Ignite 2017:

Other interviews from Microsoft Ignite 2017

Data Science with Buck Woody
High Performance Analytics with Sunil Agarwal
Azure Data Factory v2 with Mike Flasko

Data Science with Buck Woody

I got to interview Buck Woody about Data Science at Microsoft Ignite 2017! :)

In this interview, we chat about Microsoft Business Analytics and AI (formerly known as Cortana Intelligence Suite), Artificial Intelligence in Excel, intent-based programming, Predictive Analytics, DevOps for Data Scientists and life-long learning.

Data Science with Buck Woody – Microsoft Ignite 2017

Read all of Buck Woody’s great posts on his blog Backyard Data Science and follow him on Twitter @BuckWoodyMSFT. For more career advice, read his article Your Career is Your Fault on LinkedIn.

Oh, and we did get more coffee after we recorded this :)

I’m so thankful that Buck took some time out of his busy schedule to chat with me, and I hope all of you enjoy this interview. If you want to learn more, watch his full session DevOps for data science from Microsoft Ignite 2017:

Other interviews from Microsoft Ignite 2017

SQL Server 2017 with Bob Ward
High Performance Analytics with Sunil Agarwal
Azure Data Factory v2 with Mike Flasko

Batch update properties in SSIS packages (T-SQL Tuesday #68)

T-SQL TuesdayT-SQL Tuesday #68 is hosted by Andy Yun (@SQLBek). Many SQL Server defaults are not ideal, and most of us have a list of defaults we always change. Andy wants us to Just Say No to Defaults and blog about what, why or how we change defaults.

If you are an SSIS developer like me, there is a big chance that the ProtectionLevel in SSIS Packages is on top of your list of defaults to change. The default ProtectionLevel is EncryptSensitiveWithUserKey (ugh), but most of the time it is not the best option. Raise your hand if you have ever asked your favorite search engine for advice on issues like “SSIS package fails in SQL Server Agent job” or if you have ever heard someone exclaim “but it works on my machine!?” :)

There are many great blog posts about the different ProtectionLevels, why you probably want to change to DontSaveSensitive as your default, and how to use configurations and parameters instead of encrypted SSIS packages. I will not go into details about any of that in this post, but I will use ProtectionLevel as an example default property you want to change in many SSIS packages at the same time.

How do you batch update properties in existing SSIS packages? You probably don’t want to open up every single package and change them manually?

Continue reading →

Preparing for and taking exam 70-462 (Administering Microsoft SQL Server 2012 Databases)

Microsoft Certified Solutions Associate (MCSA): SQL ServerOne of my goals is to become a Microsoft Certified Solutions Expert: Business Intelligence. I decided to start from scratch and take the three exams required for Microsoft Certified Solutions Associate (MCSA): SQL Server 2012 to learn as much as possible. I passed exam 70-461 (Querying Microsoft SQL Server 2012) in January and I passed exam 70-463 (Implementing a Data Warehouse with Microsoft SQL Server 2012) in April. I decided to take exam 70-462 (Administering Microsoft SQL Server 2012 Databases) last. I passed in May :)

Preparing for the exam
Studying for the 70-461 (Querying) and 70-463 (Data Warehouse) exams was mainly about learning new 2012/2014 features and learning features I had not used as much in real projects. Studying for the 70-462 (Administering) exam was a completely different experience because I had to learn most of it from scratch.

Continue reading →

Page 1 of 4 1 2 3 4