The cost of a properly planned SQL Server maintenance window is measurable and manageable. The cost of a database compromise or database-service outage is much harder to contain. Microsoft released SQL Server security updates on September 8, 2026, for SQL Server 2017, SQL Server 2019, SQL Server 2022, and SQL Server 2025. The release addresses […]
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.