Recent Posts

SQL Server 2025 Fabric Mirroring: Change Feed vs CDC Explained

,
SQL Server 2025 replaces CDC with a new change feed for Fabric mirroring giving you lower overhead, self-healing DDL, no sysadmin required. Here's what changed and what to plan for.

SQL Server Dynamic Data Masking Security Pitfalls: How Masked Data Gets Exposed

, ,
SQL Server Dynamic Data Masking (DDM) is one of those SQL Server features that is commonly misused as a primary security feature used in production. Since it landed in SQL Server 2016, I’ve seen teams throw it at compliance requirements and…

Operating Materialized Lake Views in Microsoft Fabric

, , ,
This is the last post in a three-part series exploring the mechanics of Materialized Lake Views (MLVs). The goal is to help you understand how they work and whether they make sense for your environment. What they are, when they help, and when they fall short.

Designing with Materialized Lake Views in Microsoft Fabric

, ,
This is the second post in a three-part series exploring the mechanics of Materialized Lake Views. The goal is to help you understand how they work and whether they make sense for your environment. What they are, when they help, and when they fall short.

We’re Speaking at FabCon/SQLCon

, ,
We are happy to announce that three ProcureSQL employees are on the FABCON/SQLCON agenda. These co-located conferences are happening in Atlanta, Georgia March 16 - 20.

SQL Server 2025 Upgrade Cost & ROI

,

The issue I’ve found is that reviews of SQL Server 2025 that showcase the business impact of the upgrade are hard to find and don’t focus solely on its technical aspects. … Continue reading →

The post SQL Server 2025: Is the Upgrade Worth the Money? appeared first on SQL Server Consulting & Remote DBA Service.

New Video: Optimizing Azure Data Factory ForEach Parallel Execution

, ,
I just published a new video to our YouTube channel explaining how Azure Data Factory ForEach activities work as far as parallel execution.

Materialized Lake Views in Microsoft Fabric

, ,
This is the first post in a three-part series exploring the mechanics of Materialized Lake Views. The goal is to help you understand how they work and whether they make sense for your environment. What they are, when they help, and when they fall short.

Data Viz in Fabric Notebooks

, , ,

Lots of people have created Power BI reports, using interactive data visualizations to explore and communicate data. When Power BI was first created, it was used in situations that weren’t ideal because that was all we had as far as cloud-based tools in the Microsoft data stack. Now, in addition to interactive reports, we have […]

The post Data Viz in Fabric Notebooks first appeared on Data Savvy.

PreviousNext

Data Architecture

John Sterrett from ProcureSQL attend the 2025 Microsoft Fabric Conference

SQL Server 2025 Fabric Mirroring: Change Feed vs CDC Explained

,
SQL Server 2025 replaces CDC with a new change feed for Fabric mirroring giving you lower overhead, self-healing DDL, no sysadmin required. Here's what changed and what to plan for.

SQL Server Dynamic Data Masking Security Pitfalls: How Masked Data Gets Exposed

, ,
SQL Server Dynamic Data Masking (DDM) is one of those SQL Server features that is commonly misused as a primary security feature used in production. Since it landed in SQL Server 2016, I’ve seen teams throw it at compliance requirements and…

Operating Materialized Lake Views in Microsoft Fabric

, , ,
This is the last post in a three-part series exploring the mechanics of Materialized Lake Views (MLVs). The goal is to help you understand how they work and whether they make sense for your environment. What they are, when they help, and when they fall short.

Designing with Materialized Lake Views in Microsoft Fabric

, ,
This is the second post in a three-part series exploring the mechanics of Materialized Lake Views. The goal is to help you understand how they work and whether they make sense for your environment. What they are, when they help, and when they fall short.

SQL Server 2025 Upgrade Cost & ROI

,

The issue I’ve found is that reviews of SQL Server 2025 that showcase the business impact of the upgrade are hard to find and don’t focus solely on its technical aspects. … Continue reading →

The post SQL Server 2025: Is the Upgrade Worth the Money? appeared first on SQL Server Consulting & Remote DBA Service.

Materialized Lake Views in Microsoft Fabric

, ,
This is the first post in a three-part series exploring the mechanics of Materialized Lake Views. The goal is to help you understand how they work and whether they make sense for your environment. What they are, when they help, and when they fall short.
Microsoft Fabric Mirroring changes the game with Data Ingestion giving you near real-time data with a no-code framework

Fabric Mirroring is Changing the Game for Data Ingestion

,
Microsoft’s Fabric Mirroring will change how you perform data ingestion. If you are using products to automate batch processes for data dumping, did you know that Fabric Mirroring might remove the need for these tools and provide you with…
John Sterrett from ProcureSQL attend the 2025 Microsoft Fabric Conference

Microsoft Power BI to Microsoft Fabric: Are You Ready for the Transition?

,
In 2023, Microsoft announced its new platform, Microsoft Fabric, an innovative product that combined Microsoft Power BI, Azure Synapse Analytics, Azure Data Factory, Fabric SQL Databases, and Real-Time Intelligence into one platform. Over…
John Sterrett from ProcureSQL attend the 2025 Microsoft Fabric Conference

SQL Server 2025 Standard Developer Edition

,

With the release candidate of SQL Server 2025, which came out last week, I want to discuss a valuable feature you won’t see in the Microsoft press release: SQL Server 2025 Developer Standard Edition. Microsoft is finally addressing a long-standing … Continue reading →

The post SQL Server 2025 Standard Developer Edition appeared first on SQL Server Consulting & Remote DBA Service.

PreviousNext

C-Level

SQL Server 2025 Upgrade Cost & ROI

,

The issue I’ve found is that reviews of SQL Server 2025 that showcase the business impact of the upgrade are hard to find and don’t focus solely on its technical aspects. … Continue reading →

The post SQL Server 2025: Is the Upgrade Worth the Money? appeared first on SQL Server Consulting & Remote DBA Service.

Microsoft Fabric Mirroring changes the game with Data Ingestion giving you near real-time data with a no-code framework

Fabric Mirroring is Changing the Game for Data Ingestion

,
Microsoft’s Fabric Mirroring will change how you perform data ingestion. If you are using products to automate batch processes for data dumping, did you know that Fabric Mirroring might remove the need for these tools and provide you with…
John Sterrett from ProcureSQL attend the 2025 Microsoft Fabric Conference

Microsoft Power BI to Microsoft Fabric: Are You Ready for the Transition?

,
In 2023, Microsoft announced its new platform, Microsoft Fabric, an innovative product that combined Microsoft Power BI, Azure Synapse Analytics, Azure Data Factory, Fabric SQL Databases, and Real-Time Intelligence into one platform. Over…

Legacy Applications: Should They Stay Or Should They Go?

Modernizing Legacy Applications Older legacy systems and legacy applications are crucial to a business's functionality. They're the backbone that holds a business together, whether they are a bank's mainframe holding customer accounts, a factory's…
John Sterrett from ProcureSQL attend the 2025 Microsoft Fabric Conference

The CIO’s Guide to Leveraging Microsoft Fabric for Competitive Advantage

,
I attended the Microsoft Fabric conference for the first time last week. I wanted to provide a guide that CIOs and CEO's could leverage to understand how they could utilize these new announcements at the 2025 Fabric Conference to obtain a competitive…
PreviousNext

Community

We’re Speaking at FabCon/SQLCon

, ,
We are happy to announce that three ProcureSQL employees are on the FABCON/SQLCON agenda. These co-located conferences are happening in Atlanta, Georgia March 16 - 20.

TSQLTuesday #188 – The Recap of Growing the Younger Data Community and Speakers

  Earlier this month, we hosted T-SQL Tuesday and chose the topic of Growing the Younger Data Community and Speakers.  Today, I bring you a summary recap of everyone who shared their thoughts on this subject with links to their…

TSQLTuesday #188 – Growing the Younger Data Community and Speakers

This month, I am hosting T-SQL Tuesday for the very first time. T-SQL Tuesday is a monthly blog party created by Adam Machanic in 2009. I want to give Steve Jones a shout-out for allowing me to host this month's edition. Each month, a…
Austin Texas SQL Saturday

Austin Texas SQL Saturday was a Success!

Austin Texas SQL Saturday was a Success! Austin Texas SQL Saturday was a success! Procure SQL would not exist if it wasn't for #SQLFamily and the SQL Community. Therefore, we always want to help connect, share and learn with our local data…
Make Your Queries Go Faster

SQL Saturday Jacksonville Sponsors

Procure SQL is proud to be speaking and sponsoring SQL Saturday Jacksonville this weekend. Join us and several other amazing community speakers as we all share our knowledge with the community. The event will be on Saturday, May 14th, 2022,…
Make Your Queries Go Faster

Getting Started with SQL Server Performance Tuning

Watch! Getting Started with Performance Tuning Have slow queries and want to get down to the basics of learning some fundamentals for performance tuning? If so, John Sterrett is giving an talk at the Nashville User Group (Online) tomorrow.…
Procure SQL September 2018 Training Opportunities

September 2018 Training Opportunities

, ,
The Procure SQL team is out and about in September, sharing their knowledge for free at SQL Saturdays as well as online webinars!  We are very proud of our team and their efforts to share knowledge and experiences.  Be sure to say hello…

SQL Saturday Houston 2018

, , ,
We are back this year!  Not only are we sponsoring SQL Saturday Houston, we are also speaking!  All three of us are presenting!  Go here to see the full schedule. What is SQL Saturday? SQL Saturday is a free training event for Microsoft…

Four Tips for Entry-Level and Experienced IT Professionals

John Sterrett shares his thoughts on successfully transitioning to an entry-level IT job. Recently, I worked with  AITP to share some tips that helped me successfully transition from a Computer Engineering student at the University of Oklahoma…
PreviousNext
Join Our Newsletter

Blog Categories

Tags

#SQLFamily Austin automatic tuning availability group azure backup Backups career Data Governance Data Loss Data Platform DBA Denver Differential Backup Disaster Recovery Fabric Fabric Architecture Full Backup High Availability Houston Marketing Database Administrator Microsoft Microsoft Fabric Microsoft SQL Server mirroring parameter sniffing PASS performance tuning Professional Development query store Recovery Recovery Model Restores SQL Saturday SQL Server SQL Server 2017 sql server 2019 SQL Server 2022 sql server 2025 SSMS System Databases Transaction Log Backup tsqltuesday Tuning Wait Stats

Archives