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