What Do We Want to See in SQL Server?
Microsoft reads your feedback, but doesn't always build it. However, your votes can sway them at times. Today Steve asks what you'd like to see added to SQL Server.
[From the archives] 5 things to look for in a 3rd party database monitoring tool
Are you evaluating the effectiveness of your homegrown database monitoring tool or looking at investing in a 3rd party one? This helpful blog post suggests 5 things to look for in your evaluations.
Generate Random Dates in T-SQL
In this article we look at how to generate random dates in SQL Server to build a sample dataset along with code and examples
Digging into an AI Algorithm
One place where Artificial Intelligence systems might shine is the medical field.
Tracking Configuration Changes Against a Baseline
One of the great things about SQL Server is that the platform has grown to include a number of configuration options and switches that allow a DBA to get the most performance from their instance that is possible. One of the downsides of the platform, however, is that any sysadmin can make changes (or db_owner […]
Identify and Correct a Large SQL Server Error Log
Learn how to find and remove a large SQL Server Error Log file when it consumes a lot of space on your drive
Increasing the Visibility of Database Changes in Flyway Development
If you save a metadata 'model' for every new version of a database created by Flyway, you can compare the current model to the previous one to see what changed. In turn, you can then generate a database E-R diagram that highlights the changed objects, instantly making those changes visible to other team members
How Often Do You Update During Issues?
When a disaster occurs and your staff is working on it, what cadence of updates should your customers expect?
How to Get Data Using Python in Power BI
This article shows how you can incorporate Python scripting inside a Power BI report.
Security in MySQL: Part Two
There’s more to security in MySQL than user account privileges. In this article, Lukas Vileikis explains the other components of MySQL security
Blogs
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
DBCC CHECKDB Limits III
Comments posted to this topic are about the item DBCC CHECKDB Limits III
CROSS APPLY Fundamentals: Part 1
Comments posted to this topic are about the item CROSS APPLY Fundamentals: Part 1
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers