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
8,089 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
9,545 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
34,136 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
3,005 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...