Have you ever found yourself with the need to copy SQL Server logins from one server to another? It'll come in handy if you're setting up a failover site, building a replacement server, setting up a ...

I've inherited a large, convoluted project which is suffering from very bad performance problems. I've taken a look at the TSQL and I won't have any problems finding areas to speed up, but it's ...

Here is a feature that I have been waiting for since I started working with SQL Server 6.5: the ability to script the data from a table. When you deploy a SQL Server database, you often need to ...

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database. In part one of this article, I described a ...

A monthly overview of things you need to know as an architect or aspiring architect.

As you might guess from the name, this product is a builder for SQL statements. But it's a whole lot more than that. It's also a bit different from other products in the field, so let's start by ...

Knowing how to automate tasks in the cloud will make you a more productive DBA. Here are the key concepts to understand about cloud scripting and a rundown of the best tools for automating code in ...