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.
Archives de l’année : 2025
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. […]
[Video] Office Hours at Sea
This Office Hours episode comes to you from Virgin Voyages’ newest cruise ship, the Brilliant Lady, sailing through […]
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 […]
The Version Store Won’t Clear If ANY Database Has Open ...
Short story: what the title says. This is especially problematic for folks who merge multiple databases onto the […]
Docker Advice for SQL Server in Production
Introduction Nowadays, with the widespread adoption of microservices across major companies, using Windows Server to host SQL Server […]
Managing Underused Indexes in SQL Server Availability Groups – Part ...
The post Managing Underused Indexes in SQL Server Availability Groups – Part 2 appeared first on SQLServerCentral.
How Implicit Transactions Hurt SQL Server Performance Without You Knowing
Introduction In the world of SQL Server performance troubleshooting, developers and DBAs often chase the usual suspects: bad […]
Query Plan Pop Quiz Answers 2 and 3: I’ve Got ...
In the Query Plan Pop Quiz, questions 2 and 3 asked you about what the sizes of arrows […]
How to Build an AI-Powered T-SQL Assistant with Python & ...
If you’re a SQL Server DBA or developer looking to harness AI for your everyday scripting workflows, […]
SQL EXISTS Use Cases and Examples
The post SQL EXISTS Use Cases and Examples appeared first on SQLServerCentral.
TempDB Filling Up? Try Resource Governor.
TempDB is one of the banes of my existence. Anybody, anybody who can query your server can run a […]
Innovation spotlight: How 3 customers are driving change with migration ...
Organizations are under constant pressure to modernize their estate. Legacy infrastructure, manual processes, and increasing data volumes in […]
Database Ledger in SQL Server 2022
Protecting data from unauthorized access is a major challenge for organizations today. SQL Server 2022 introduces Database Ledger, […]
Fonction de conversion spatiale OGC vers GeoJSON pour SQL Server
Avec l’arrivée de SQL Server 2025 et son type JSON — ce n’est plus un simple « texte », mais bien […]
T‑SQL BULK INSERT vs OPENROWSET: CSV Imports, File Access Gotchas, ...
The post T‑SQL BULK INSERT vs OPENROWSET: CSV Imports, File Access Gotchas, and A PowerShell Script appeared first […]
Query Plans Pop Quiz Answer #1: Costs are Garbage.
In last week’s Query Plans Pop Quiz, the first question was, someone hands you these two queries and […]
Announcing the 2025 Black Friday and Doorbusters Deals!
You’ve been telling yourself, “One of these days, I’ll finally take Brent’s classes.” Get ready, because that day […]
Announcing Free MASTERING Week 2025!
You’ve been working with SQL Server, Azure SQL DB, or Amazon RDS SQL Server for years. You’re jaded. […]
Schema Design Basics for Power BI
The post Schema Design Basics for Power BI appeared first on SQLServerCentral.
Migrate SSRS Reports to a New Server in Just a ...
Managing SSRS report migrations can be a time-consuming and error-prone process, especially when dealing with large enterprise report […]
Secure PostgreSQL in Docker: SSL, Certificates & Config Best Practices
The post Secure PostgreSQL in Docker: SSL, Certificates & Config Best Practices appeared first on SQLServerCentral.
Distributed Availability Group Health: T-SQL and Zabbix
After creating a distributed availability group using the steps described in my article, SQL Server 2022 Clusterless Distributed […]
Updated First Responder Kit and Consultant Toolkit for October 2025
This quarter’s release includes new checks for SQL Server 2025’s new memory pressure warnings, Azure SQL DB’s operations […]
Use SQL to Find a String in Database Tables, Stored ...
The post Use SQL to Find a String in Database Tables, Stored Procedures, and User Defined Functions appeared […]
Query Plans Pop Quiz: Three Simple Questions
Question 1: Pick the Problematic Plan: someone hands you a pair of queries, and you get the estimated […]
Free Fundamentals Classes Are Coming Next Week! Register Now.
You’re a developer, analyst, database administrator, or anybody else working with SQL Server, Azure SQL DB, or Amazon […]
Find Invalid Objects in SQL Server
One of the most important responsibilities of any database administrator is to maintain the integrity of the database, […]
Natural Language Query for SQL Server
The post Natural Language Query for SQL Server appeared first on SQLServerCentral.
Oracle Performance Tuning: Practical Techniques Every DBA Should Master
As database professionals, we’ve all been there – that dreaded moment when users start complaining about slow queries, […]
Who’s Hiring Microsoft Data People? October 2025 Edition
Is your company hiring for a database position as of October 2025? Do you wanna work with the […]
Which Should You Use: VARCHAR or NVARCHAR?
You’re building a new table or adding a column, and you wanna know which datatype to use: VARCHAR […]
Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY
Introduction High-concurrency systems always look impressive on paper. You throw in dozens of CPU cores, crank up memory, […]
Unlocking the Power of FULL OUTER JOIN in SQL: Performance, ...
The post Unlocking the Power of FULL OUTER JOIN in SQL: Performance, Use Cases & Examples appeared first […]
Set MAXDOP in Azure SQL DB or You’ll Get This ...
Max Degrees of Parallelism (MAXDOP) tells the database engine, “If you decide to parallelize a query, go parallel […]
Memories of Andrew Clarke, by Simon Galbraith
Simon Galbraith is the co-founder of Redgate and one of the creators of Simple Talk. Here, he […]
Here Are the YouTube Channels We Both Loved.
Last week, I announced that we’ve hit 50,000 YouTube subscribers, and I celebrated by letting y’all submit your […]
Building a Dynamic Countdown Timer in Power BI
The post Building a Dynamic Countdown Timer in Power BI appeared first on SQLServerCentral.
How to Use SQL Server Features to Cut Web App ...
A customer taps “Buy Now” on your web app. Half a second passes. The screen hesitates before the […]
Power BI TMDL View: Benefits, Security Risks & Best Practices
The post Power BI TMDL View: Benefits, Security Risks & Best Practices appeared first on SQLServerCentral.
Building a Simple SQL/AI Environment
Al is everywhere….almost. In my day-to-day role as a DBA, I don’t really have the opportunity or need […]
We Hit 50,000 YouTube Subscribers! Let’s Run a Contest.
This is kinda amazing to me: our YouTube channel has broken the 50,000 subscriber mark! That’s wild to […]
Microsoft Now Recommends You Set Max Memory to 75% and ...
Somehow I missed this a few years ago, and I bet a lot of y’all did too. Note […]
Side by Side Upgrade to SQL Server 2022
The post Side by Side Upgrade to SQL Server 2022 appeared first on SQLServerCentral.
Announcing Free Fundamentals Week 2025!
You’re a developer, analyst, database administrator, or anybody else working with SQL Server, Azure SQL DB, or Amazon […]
How Well Does the MSSQL Extension in VSCode Work?
With the retirement of ADS, I decided to take a look at the MSSQL extension for VSCode. This […]
Getting Started with Bayesian Modeling
The post Getting Started with Bayesian Modeling appeared first on SQLServerCentral.
Build a Test Lab of SQL Server 2025 on Windows ...
Problem Now that public preview of SQL Server 2025 CTP 2.1 is out (Community Technical Preview), you have […]
[Video] Office Hours: Database Questions & Answers
In between clients, I hopped onto my Twitch channel to take your top-voted questions from https://pollgab.com/room/brento. If you’d […]
Your Developers Need Cheap SQL Training.
Your developers haven’t ever been to formal Microsoft database training on SQL Server or Azure SQL DB. They’re […]