Database Cattle
Steve Jones says you should treat your database servers like cattle. It makes life easier.
Exploring Azure Storage for SQL Server DBAs
If you need to run SQL Server in an Azure Virtual Machine, your choice of Azure storage will have a great effect on its performance. If performance is important, you are likely to discover complications and barriers in the storage options when you come to provision the server. If you get it wrong, you could end up with an expensive service. Joshua explains the value of using a lab environment to allow you to make well-informed VM storage decisions when the time comes to provision your production system.
Redgate Data Tools in Visual Studio 2017 Enterprise
Today during the Visual Studio launch event, we announced that we’ve partnered with Redgate to include Redgate Data Tools in Visual Studio 2017. Redgate Data Tools includes three components that extend DevOps practices to SQL Server and Azure SQL databases and increase your productivity while doing database development.
TempDB Database On a Local Disk for an FCI
The article is about Configuring TempDB Database on Local Disk in SQL Server 2012/2014 Failover Cluster to improve performance.
The Migration Checklist
Today Steve Jones talks about the checklist you would want if you needed to move a SQL Server instance to new hardware.
Move Azure SQL Databases using the Export and Import PowerShell cmdlets
John Miner shows how to move databases between a cloud development environment and an on-premise production environment using PowerShell cmdlets.
Detective Stories - Tracking Down the Database's Dependents Part 2
No worries about dropping databases. Now we can search for its dependencies before the database dies. Part 2 of a 2-part article.
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Secure Communications
Comments posted to this topic are about the item Secure Communications
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers