Procure SQL’s Weekly Digest – February 28, 2024!

Here are some news, videos, tips, and links the Procure SQL team would like to share! Scan vs. Seek The most straightforward example explains the difference between a scan and a seek in execution plans. Data Engineering with…

Data Engineering with Notebooks in Seven Minutes

Checkout this quick video to see how you can start to load and transform your data with notebooks. Data Engineering with Microsoft Fabric becomes easier once you understand how to leverage notebooks to your advantage. If you are in Austin…

Procure SQL’s Weekly Digest – February 21, 2024!

Here are some news, videos, tips, and links the Procure SQL team would like to share! Near Zero Downtime Migrations Near zero downtime migrations are why Azure SQL Databases can be a subscriber for transactional replication. Habits…

Procure SQL’s Weekly Digest – February 14, 2024!

Here is some news, videos, tips, and links the Procure SQL team would like to share! Procure SQL made it out to their first trade show of 2024! Justin, Kon and John were at SQL Saturday Atlanta BI on February 10th. Justin Cunningham…

Procure SQL’s Weekly Digest – February 7, 2024!

Here are some videos, tips, and exciting links the Procure SQL team would like to share! MLB's Databases Have you ever wondered about what MLB teams name their databases? We like "the fish bag," "ground control," and "MITT." What…

Microsoft Fabric Overview in Five Minutes

In five minutes, Justin gives you a Microsoft Fabric overview to help you ingest, process, store, monitor, and govern your data with Microsoft's new analytics tool. He will discuss user personas like Data Engineering and Data Science within…

Procure SQL’s Weekly Digest – January 31, 2024!

Here are some videos, tips, and exciting links the Procure SQL team would like to share! Xbox and SQL Server Learn how Xbox reduced patching downtime significantly in their SQL Server environment. Fabric Common Tasks with Python Are…

Procure SQL’s Weekly Digest – January 24, 2024!

Here are some videos, tips, and interesting links we have viewed at Procure SQL. Comparing NULLS Struggling to compare many columns that contain null values? Here is a great way to do so before SQL 2022; here is a newer way with SQL…

Is external governance coming to SQL Server 2022?!?!

Every so often, when a new cumulative update (CU) comes out for SQL Server, I like to see what system objects are new and which ones have changed. With the cumulative SQL Server 2022 update eleven this month, I noticed some exciting views…

Procure SQL’s Weekly Digest – January 17, 2024!

Hopefully, everyone is back into the swing of things as we are in the middle of week three of 2024! Here are some videos, tips, and interesting links we have viewed at Procure SQL. The Feature That Should Have Been Scrapped If you…