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,796 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,217 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
15,270 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,982 reads
Blogs
What does the Machine Learning process look like?
By damianwidera
This is the second article in the Machine Learning area. I have explained a...
Azure Cosmos DB: real-time data movement using Change Feed and Azure Functions
In this article, we will focus on creating a data pipeline to ETL (Extract,...
Quick 6 month check – how are those learning goals going…?
By HamishWatson
So in January I wrote a blog post on some goals I had this...
Forums
Select n records in table X from a field on table Y
Hi, hope someone can help with this. I've the table gifts_to_give: Id_give number_of_gifts name ...
Select n records in table X from a field on table Y table
Hi, hope someone can help with this. I've the table gifts_to_give: Id_give number_of_gifts name ...
Error: 17892 Severity: 20 State: 1
Hi, I've been struggling for 5 days to solved this issue. We have a...
Ask SSC