What’s Coming in SQL Server 2025, DMV Edition
As we approach the first public releases of SQL Server 2025, it’s fun to start spelunking through things Azure SQL DB has today – announced and unannounced – that aren’t yet present in the boxed product version of SQL Server. Mi …
Announcing Fundamentals Week 2025!
You’ve attended some of my free online streams, read my blog posts, and you use the First Responder Kit. You enjoy my laid-back, humorous approach to sharing what I’ve learned over the years. You love live classes. You’ve tried watchi …
How I Achieved Scalability in a. Amazon RDS Shared DB Connection Environment
Overview Amazon RDS allows users to create multiple databases within a single database instance. And connections to each of these databases are shared across the DB instance. This setup can become a bottleneck when the number of connections per DB inst …
Free Webcast Tomorrow: Fundamentals of Index Tuning
It’s time for SQL Server Spring Training! I’m teaching 60-90 minutes of my most popular classes for free over the next few months. Tomorrow I’m doing Fundamentals of Index Tuning. It’s targeted at folks who don’t know how …
Deploy DACPAC to Azure SQL Database using Visual Studio
Deploying a DACPAC to an Azure SQL Database is a critical step in ensuring your database changes are effectively moved from development to production. This guide will walk you through the process of deploy DACPAC to Azure SQL database directly from Vis …
INFO.VIEW DAX Functions Usage and Examples
The post INFO.VIEW DAX Functions Usage and Examples appeared first on SQLServerCentral.
The State of the Database Landscape in 2025: Insights and trends
The post The State of the Database Landscape in 2025: Insights and trends appeared first on SQLServerCentral.
Scales & Measurements
if you’re going to work with databases, you probably ought to know something about data. In particular, we don’t put data directly into a database; we have to encode it and represent it in a format which a machine can handle. Encoding data existed long …
How to Download and Restore AdventureWorks 2019 Database
Introduction AdventureWorks is a sample database from Microsoft that simulates a company called Adventure Works Cycles. It is designed to showcase SQL Server’s features, making it an excellent tool for learning, testing, and demonstrating SQL. In this …
[Video] Office Hours: Philosophical Questions at the Waterfall of the Gods
I’m in Iceland this week, land of fire and ice, a place I keep coming back to over the years. It’s one of my favorite places on earth with stunning scenery, nice folks, and great restaurants. I paused at Godafoss to take your top-voted ques …
Simple Talk on the Road In March
The holidays truly are over, and it is time to hit the road again here at Simple Talk. In March I have 3 events, all of which are basically back to back (and finishing off with a bit of vacation.) Familiar Territory – SQL Saturday Atlanta BI On M …
How Shortcuts affect Lakehouse’s Maintenance
I wrote about lakehouse maintenance before, about multiple lakehouse maintenances, published videos about this subject and provided sample code about it. However, there is one problem: All the maintenance execution should be avoided over shortcuts. The …
Free SQL Server Spring Training Live Webcasts Start Next Week.
Starting next Tuesday, I’m doing absolutely free 90-minute live training webcasts to help y’all get your learn on: March 11: Fundamentals of Index Tuning March 18: Fundamentals of Query Tuning April 1: Fundamentals of TempDB April 8: Fundam …
Importing and exporting data in MongoDB Compass
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. When working with MongoDB, you’ll likely need to import or export document data from time-to-time. You can use MongoDB Compass fo …
Understanding the Logical Functions IIF and Choose in SQL Server 2022
Introduction In SQL Server 2022, developers often need to implement conditional logic within their queries. Whether it’s selecting specific values or performing complex checks, SQL Server offers several functions that simplify these tasks. Among them, …