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 ...

Learn essential IT skills for jobs in 2026, including Python, SQL, cloud computing, cybersecurity, and beginner tech skills ...

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 ...

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 ...

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 ...

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 ...

Embarcadero announced it is providing SQL Server developers and DBAs with a toolset designed to simplify many common and complex tasks associated with developing, administering and optimizing SQL ...