AI analytics today allow us to break down and analyze all parts of a business. Today, we will quickly talk about using a data lake and data pipelines to help streamline data analytics. Every internal and external interaction can be scrutinized and perfected to create a well-oiled, efficient machine. Consumer data, inventory management, market trends, […]
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 […]
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 […]
Are you tired of people complaining about your database’s slow performance? Maybe you are tired of looking at the black box and hoping to find what is slowing your applications down. Hopefully, you are not just turning your server off and back on when people say performance is terrible. Regardless, I want to share a […]
Why Adopting a Modern Data Warehouse Makes Business Sense Most traditional data warehouses are ready for retirement. When they were built a decade or more ago, they were helpful as a mechanism to consolidate data, analyze it, and make business decisions. However, technology moves on, as do businesses, and in modern times, many data warehouses […]
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? AI Coming […]