Ten steps to migrate databases between servers in a .Net environment
How to move databases from one server to another with limited downtime
2009-08-17
7,829 reads
Edward Elliott
Capturing I/O patterns using Process Monitor
In this article, Edward Elliot shows us how to capture the types, size and location of SQL Server I/O requests.
2009-06-23
7,402 reads
What is sysprocesses and what can it do for you?
This article presents a description of sysprocesses aimed at the newer DBAs. From new author Edward Elliot, he dives into what you can learn from this system view.
2009-05-01
18,135 reads
An Extra Defense For SQL Injection Attacks
TDSe-cure is a proxy service to SQL Server to block SQL injection attacks.
2009-01-07
2,983 reads
Blogs
Deploy BACPAC to Azure Managed Instance failing from SSMS?
By Daniel Janik
Recently I ran into an error when trying to copy a small database bacpac...
Daily Coping–3 Apr 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Data Céilí 2020 Cancelled
Yesterday we announced that Data Céilí 2020 has been cancelled due to the continuing...
Forums
Need T-SQL to list all tables in database that 'qualify' for Compression
Does anyone know of any existing script that would allow me to list all...
Delet old backup in azure
Hello, How to delete backups in blob storage from azure sql server VM to...
Ask SSC