Uncover SQL Server Missing Indexes
In this article, we look at a SQL Server Dynamic Management View (DMV) that helps find queries that trigger missing index recommendations.
AWS Services Using SQL for Big Data Analysis
AWS offers a robust suite of tools designed to manage big data effectively. This article explores focusses on how SQL is leveraged within Amazon Redshift and Amazon Athena. We will delve into the technical features, practical applications, and step-by-step examples for using these services, highlighting how they can transform raw data into actionable insights for your business.
The Modern Algorithm of Chance
Algorithms rule the world and Steve talks about the impact those have on the world.
Use Logic Apps To Save Money In Azure: Data Engineering in Fabric
This next article looks at how a Logic App in Azure can start and stop various database services and save money.
Enhancing SQL Server Searches with Elasticsearch and Python
Learn how to get started with Elasticsearch with data in your SQL Server database.
The Role of Databases in the Era of AI
Steve has a few thoughts on how AIs change the role of databases.
Azure Managed Instance Download and Restore SQL Server Backup
Create an SQL Server backup for an Azure Managed Instance that you can download and restore on another SQL Server instance.
Serverless Gets Faster
In Azure SQL Database serverless edition, we get an upgrade to our configuration.
Adding new files to a log-shipped database (SQL Spackle)
Freshly minted MCM Wayne Sheffield fills a log shipping crack that could otherwise cause you to re-initialize your log shipping.
Blogs
Disable the sa login in SQL Server (and sleep better)
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Leadership in Times of Change: Guiding Teams Through Uncertainty, Disruption, and Transformation
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
The End of Year Vacation Burn
By Steve Jones
It’s been a good year for me. With my sabbatical, I felt like I’ve...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
how to write this query?
Hi everyone I am a bit stuck on how to write this query. Below...
Powershell script to generate SQL server Inventory in CSV format
Comments posted to this topic are about the item Powershell script to generate SQL...
Question of the Day
Azure SQL Database MAXDOP
When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?
See possible answers