Recent Posts

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.

Check Power BI Bookmarks with Semantic Link Labs

, ,

Have you ever added a visual to a Power BI report page and published the updated report only to realize you forgot to adjust a related bookmark? It’s very easy to do. The Power BI user interface doesn’t allow you to determine which visuals are included in a bookmark that includes only selected visuals. And […]

The post Check Power BI Bookmarks with Semantic Link Labs first appeared on Data Savvy.

Check Power BI report interactions with Semantic Link Labs

, ,

It can be tedious to check what visual interactions have been configured in a Power BI report. If you have a lot of bookmarks, this becomes even more important. If you do this manually, you have to turn on Edit Interactions and select each visual to see what interactions it is emitting to the other […]

The post Check Power BI report interactions with Semantic Link Labs first appeared on Data Savvy.

Meagan Longoria

Semantic Link Labs: A Key-player in Power BI Automation

, ,

Setting page visibility and the active page are often overlooked last steps when publishing a Power BI report. It’s easy to forget the active page since it’s just set to whatever page was open when you last saved the report. But we don’t have to settle for manually checking these things before we deploy to […]

The post Modify Power BI page visibility and active status with Semantic Link Labs first appeared on Data Savvy.

PreviousNext

Data Architecture

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…

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.

Standard Developer Edition is added to SQL Server 2025

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.

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…

Pain free way to identify if SQL Server is the root cause or symptom

In this six-minute video, Allen Kinsel shares multiple ways to quickly determine whether SQL Server is the root cause or a symptom of your performance problem.   Demo Code /* See all requests */ select * from sys.dm_exec_requests…
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 Full Backup High Availability Houston Marketing Database Administrator Microsoft Microsoft Fabric Microsoft SQL Server mirroring MVP 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