Sites anglophones


[Video] Office Hours in Roatan, Honduras

Publié le 6 novembre 2025 sur brentozar.com
 

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

Publié le 5 novembre 2025 sur brentozar.com
 

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

Publié le 5 novembre 2025 sur simple-talk.com
 

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

Publié le 5 novembre 2025 sur simple-talk.com
 

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

Publié le 5 novembre 2025 sur sqlservercentral.com
 

The post Power BI TMDL View: Benefits, Security Risks & Best Practices appeared first on SQLServerCentral.

Create and Read the Analysis Services Flight Recorder

Publié le 5 novembre 2025 sur sqlservercentral.com
 

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!

Publié le 4 novembre 2025 sur brentozar.com
 

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

Publié le 3 novembre 2025 sur brentozar.com
 

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

Publié le 3 novembre 2025 sur sqlservercentral.com
 

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!

Publié le 31 octobre 2025 sur brentozar.com
 

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

Publié le 31 octobre 2025 sur sqlservercentral.com
 

The post Static Versus Dynamic Bulk Insert Imports of Multi-File Datasets appeared first on SQLServerCentral.

Regular Expressions in SQL Server 2025

Publié le 31 octobre 2025 sur sqlservercentral.com
 

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

Publié le 30 octobre 2025 sur brentozar.com
 

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

Publié le 29 octobre 2025 sur brentozar.com
 

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.

Publié le 28 octobre 2025 sur brentozar.com
 

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 …


Pages :