Entries by John Sterrett
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 call it a day, only to find out later that their “masked” data was […]
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.
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 full content. First, if you are not familiar with T-SQL Tuesday, it is a monthly blog party created […]
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 new topic is chosen and published on the first Tuesday of […]
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 near real-time access to the data as it changes in the source systems? Suppose you have […]
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.
Austin, Texas Best SQL Server Training in 2025
If you’re looking to master SQL Server, Power BI, or Microsoft Fabric, attending the SQL Saturday event in Austin, Texas, is one of the smartest moves you can make for your career. Note: Austin, Texas, is hosting their event on … Continue reading
The post Austin, Texas Best Microsoft Technical Training Oppertunity appeared first on SQL Server Consulting & Remote DBA Service.
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 advantage. To be transparent, I was skeptical because Microsoft consistently changes or rebrands […]