[Video] Office Hours in Roatan, Honduras
My cruise ship took a detour to Honduras to avoid the hurricane. Let’s hang out on the beach and go through your top-voted questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:58 Dopinder: What is your opinion of the G …
Who’s Hiring Microsoft Data People? November 2025 Edition
Is your company hiring for a database position as of November 2025? Do you wanna work with the kinds of people who read this blog? Let’s make a love connection. I think YOU should apply. If your company is hiring, leave a comment. The rules: Your comme …
SQL Server DBaaS Vulnerability: Decrypting System Code & Exfiltrating User Data
Security in cloud environments is both challenging and fascinating, particularly for Database-as-a-Service (DBaaS) offerings like Amazon RDS, GCP CloudSQL and Alibaba ApsaraDB RDS. The cloud vendor acts as the system administrator, managing the operati …
SQL Server DBaaS Vulnerability: Decrypting System Code & Exfiltrating User Data
Security in cloud environments is both challenging and fascinating, particularly for Database-as-a-Service (DBaaS) offerings like Amazon RDS, GCP CloudSQL and Alibaba ApsaraDB RDS. The cloud vendor acts as the system administrator, managing the operati …
Power BI TMDL View: Benefits, Security Risks & Best Practices
The post Power BI TMDL View: Benefits, Security Risks & Best Practices appeared first on SQLServerCentral.
Create and Read the Analysis Services Flight Recorder
One of the most important things in database administration is monitoring. For example, you want to know if unauthenticated users are reading data, if the system is throwing errors, if there is wrong data somewhere, and the amount of time that sessions …
Next Week, Start My Mastering Classes for Free!
You’re a developer, database administrator, or DBRE who’s been working with SQL Server, Azure SQL DB, and Amazon RDS SQL Server for yeeears. You’re jaded. You’re confident. You’re pretty sure you know what you’re doing. You’ve never taken my Mastering …
Black Friday Doorbusters End Today: Get In Before the Prices Go Up
Welcome to my annual Black Friday sale, and I’m running special doorbuster deals to sweet talking you into taking the plunge quickly. On November 4, the Fundamentals bundle will go up to $295, and the Lifetime bundle will go up to $1,795 – still a deal …
Create an HTML Report on the Status of SQL Server Agent Jobs
SQL Server jobs are an integral part of any SQL Server environment. These jobs run a predefined set of tasks and commands at specified intervals, ensuring the database is up-to-date and performing optimally. As a database administrator, it is essential …
Black Friday Doorbusters Are Open Now, Closing Monday!
You’ve been telling yourself, “One of these days, I’ll finally take Brent’s classes.” Get ready, because that day is here: my Black Friday sale runs all November long, and it’s my lowest prices all year! SQL Server 2025, 2022, and 2019 all dramatically …
Static Versus Dynamic Bulk Insert Imports of Multi-File Datasets
The post Static Versus Dynamic Bulk Insert Imports of Multi-File Datasets appeared first on SQLServerCentral.
Regular Expressions in SQL Server 2025
Microsoft is introducing Regular Expression(regex) functions in its upcoming SQL Server 2025 to enable pattern-based searching and manipulation. This allows searching and manipulating data directly using T-SQL language and eliminates the need of progra …
[Video] Office Hours at Sea
This Office Hours episode comes to you from Virgin Voyages’ newest cruise ship, the Brilliant Lady, sailing through the Western Caribbean. We were originally scheduled to do the Eastern Caribbean, but Tropical Storm Melissa had other ideas, so they rew …
SQL ConstantCare® Population Report: Fall 2025
In this quarter’s update of our SQL ConstantCare® population report, showing how quickly (or slowly) folks adopt new versions of SQL Server, the data is very similar to last quarter: SQL Server 2025: exactly 1 server being monitored, heh. God bless y’a …
The Version Store Won’t Clear If ANY Database Has Open Transactions.
Short story: what the title says. This is especially problematic for folks who merge multiple databases onto the same server. All it takes is one badly-behaving application to leave its transactions open, and suddenly it causes the rest of the database …