Entries by JohnSterrett

AI in the Boardroom: Turning Data into Strategic Insights

For every company in America, there are thousands of different variables that can positively or negatively affect its finances. Today we will focus on leveraging Decomposition Trees, Anomaly Detection, Key Influencers Charts to turn your data into strategic insights. Labor costs, logistics, customer retention, partnerships and more all affect the day-to-day grind to keep a […]

Microsoft Entra Authentication: A Superior Alternative to SQL Server Authentication

Securing data access is paramount for organizations of any size. Nobody wants to be the following data security leak that goes viral. Adopting robust authentication methods that enhance security, streamline user experience, and simplify management is crucial for decision-makers. Today, I write about how you could utilize Microsoft Entra ID to improve your database security […]

Enable Multi-Factor Authentication, Please!

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 […]

Validating Your SQL Server Backups Made Easy!

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 […]

Kansas City Developers Conference 2024

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 […]

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 […]