Copy from On-Prem to Azure SQL with Azure Data Factory

In this short video, Hiram Fleitas demonstrates how to copy data or multiple tables from an on-prem SQL Server, through a self-hosted runtime integration to Azure SQL DB Hyperscale and/or Azure SQL Data Warehouse with Azure Data Factory.
He will also show you how to automate tasks like Resuming or Pausing your Azure SQL Data Warehouse before or after your pipeline ETL runs. Bonus resources included.

Discover the On-Demand T-SQL Fundamentals Course by Itzik Ben-Gan

Itzik Ben-Gan is arguably the world’s best T-SQL expert. Get Itzik’s video lessons, demos, labs, and scripts. Study when you want, wherever you want. Powered by SolidQ.

Why Does the Transaction Log Have to be Zero-Initialized?

SQL Server knows where crash recovery has to start for a database, but not where it ends – i.e. SQL Server does not persist the ‘most recent LSN’ for a database anywhere. Paul Randal shares an explanation to this question. 

Free SQL Server Performance Tuning

Looking for the best free on-premise SQL Server performance monitoring tool out there? Look no further. Spotlight Cloud Basic isn't just free for a limited time; it's free forever.  

Pwned Passwords, Version 5

At 551M records as of V4, Pwned Passwords adds an additional 3,768,890 passwords collected over the past six months. 

Nested Window Functions in SQL

Looking for more insight from one of the best T-SQL experts? Itzik Ben-Gan discusses a feature which allows the nesting of two kinds of window functions as an argument of a window aggregate function. 

Build Your Azure Skills

Microsoft Learn is the best place to learn Azure quickly, with free, interactive, hands-on, step-by-step tutorials. Start with Azure Fundamentals or Data & AI training like Azure for the Data Engineer, AI, Bots, Cognitive Services, or Data Science.

Microsoft Acquires BlueTalon to Bolster Data Governance Offerings

Microsoft recently announced that it has acquired BlueTalon, a cross-platform data access control solutions provider headquartered in Redwood City, California, for an undisclosed amount. In a blog post, Rohan Kumar, Corporate Vice President of Azure Data said the deal will “enhance” Microsoft’s ability to “empower enterprises across industries to digitally transform” while “ensuring right use of data with centralized data governance at scale.” 

Upcoming Virtual Events

Go, Go, QueryStore! (Upgraded) – with Gail Shaw

Tuesday, August 20. 16:00 UTC.

 


We are recruiting community contributors for all PASS Insights newsletter editions:

DBA, BI, Developer, and Analyst.
We’re looking for engaging, in-depth, and technically-focused ideas to feature each month. If you are interested, submit your ideas to insights@pass.org.
You just might see yourself featured in an upcoming edition!

Looking for more than just DBA educational and technical content?
Log in to your PASS account and subscribe to the new Analyst, BI, and Developer PASS Insights newsletters.