This script allows you to restore backup copies of arbitrary databases of the ".bak" format to arbitrary instances of the MS SQL Server DBMS in automatic mode. Simplification of the import procedure ...

Uses Sequel gem to connect to Sql Server and Postgres database. Iterates through MS SQL table data and run sql insert statements against postgres database.

Good old FTP and flat file import will do the trick reliably and never take a day off. Here are the basic steps to automate an FTP download in Windows followed by a CSV insert into MS SQL Server.

The SQL PowerShell module that ships with SSMS has changed from SQLPS to SqlServer (there is no change to the module used by SQL Agent). This means that if you have a PowerShell script doing ...

A problem when implementing MS SQL Server is importing small pieces of data, in the form of Excel or Access files, into the database. In this article we will use a Microsoft tool called SQL Server DTS ...

I'm trying to start/stop MS SQL Service on various DB servers (locally) but we don't always know the name of the instance (Always only 1 SQL Server running on a single server).