New Search
If you are not happy with the results below please do another search
42 search results for: performance tuning
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 Notebooks Watch Justin’s seven-minute video on loading and transforming data in Microsoft Fabric. Is Tableau Dead? Yes and No. […]
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 of Effective Data Leaders How many of these seven effective habits do you see at your job? AI Coming […]
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 gave a talk on Data Catalog: Visualizing Your Data Sprawl. John Sterrett […]
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 is your favorite one? Cloud Failures Most cloud failures are traced back to human mistakes. Have […]
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 you building complex fabric orchestrations in Python? Microsoft Spark Utilities can be your best friend. It’s like […]
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 Server 2022. Azure SQL Database Limiting Resources Like life with Azure SQL […]
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 take anything away from reading this newsletter, please make sure you don’t […]
Finding Query Anti-Patterns in Your Developer’s Queries
In the beginning of my IT career, I was a developer. I wrote a lot of bad code that didn’t perform well. As more data entered my tables my stored procedures got slower and slower. More data, more problems! I started my career in performance tuning by making my crappy code a little less crappy. […]