Education and Experience: Completed Grade 12 and relevant tertiary (NQF 6 or higher) 2+ years solid development experience using C#, MVC, ASP.Net, MS-SQL (stored procedures, functions, views, T-SQL ...

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

Flat File Import into SQL Server Now that you’ve automated the fetching of your flat file via FTP, the next step is to automatically import that file into SQL Server.

Code Focused Deleting All Data from a SQL Server Database There are times as a developer that you will want to be able to delete all the data from a database as efficiently as possible. Unfortunately, ...

As promised in part one, I developed a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database (See Code Download for full source code and executable). The ...