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,816 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,343 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
17,363 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
Our SQL Server 2019 Administration Inside Out Fun Author Survey
By Will Assaf
SQL Server 2019 Administration Inside Out Honored again to be leading the talented SQL Server...
What's New in SQL 2019? at the Data Architecture Virtual User Group and Q&A followup
By Will Assaf
Thanks to all 180+ of you who joined the Data Architecture Virtual User Group...
My home office setup
That aging hippie (he likes Apple products and has a goatee) known as Brent...
Forums
Switching Database context in transaction
Comments posted to this topic are about the item Switching Database context in transaction
Stable Marriages Using SQL Server
Comments posted to this topic are about the item Stable Marriages Using SQL Server
Cranky Curmudgeons
Comments posted to this topic are about the item Cranky Curmudgeons
Ask SSC