SQL Bulk Insert has been tuned over the years to work well with the Microsoft .NET Framework. This tutorial shows you how to take advantage of its power.

An open source project gives DBAs the ability to channel PowerShell for automating and scaling complex SQL Server tasks, starting with the most basic: database backups.

Assuring optimal performance of database applications starts with coding properly formulated SQL. Poorly written SQL and application code is the cause of most performance problems. As much as 75% of ...

When you need a SQL database fast, the cloud is the best way to go. Azure provides a SQL database as a PaaS that eliminates the need to get an entire SQL Server deployment up and running.

Microsoft's premade templates allows for the deployment of SQL databases without having to use complex PowerShell commands.

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

I chose to install PHP myself and configure it for use in WebMatrix (see Brian Swan's tutorial). After doing that, I tested the new PHP Drivers for SQL Server. The August release added PDO support, ...