This year, several data breaches were caused by multi-factor authentication NOT being enabled. If you ever follow any of our tips, blogs, or videos, please follow this one and enable multi-factor authentication on all your applications and websites that you access. If you are procuring a new application or service, now is also a great […]
Hello, Everyone; this is John Sterrett from Procure SQL. Today, we will discuss how you can validate SQL Server Backups with a single line of PowerShell. Due to the recent global IT outage, I thought this would be an excellent time to focus on the last line of defense—your database backups. I have good news […]
Why Did You Sponsor Kansas City Developers Conference? This is a great questions which leads to a good story. Back in 2012 Jeff Strass and Michael Eaton had a half day workshop on Going Independent. It was this workshop which helped push John to start Procure SQL. Its an honor to sponsor this event and […]
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. […]
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? […]
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 […]
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 […]
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 […]
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 […]
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 not documented in the release notes. I figured I would blog about […]