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'm not much of a BATCH scripter (More of a BASH scripter) but I have an issue I need to work out and would like some help (Though I've probably already hexed myself by admitting I work in Linux). I'm ...

I'm building an automated build procedure, one of the steps is to create a database and it's structure/procedures/functions etc. Clearly I can script the entire db creation job in sql and use sqlCmd ...

Use custom-built .NET Framework 4.0 classes to connect an ASP.NET Web application to a SQL Server 2012 database. In my recent article, I showed how to connect .NET 4.0 C# and Visual Basic applications ...

SQL Server is primarily built around a row-based table structure that connects related data elements in different tables to one another, avoiding the need to redundantly store data in multiple places ...

A small program run on the server that automates or controls certain functions or links one program to another. On the Web, a CGI script is an example of a server-side script. Contrast with ...