SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

On the Fringe

Chim Kalunta is a Database Systems Developer and Independent Consultant working out of the UK. An MCITP: Database Developer and an MCITP: Database Administrator, he can be reached at chimkalunta.com.

Archives: March 2014

Index Scripting with Powershell

I’ve been actively seeking out opportunities to do more stuff with Powershell of late.

I had wanted to script out only the Indexes on Tables in a Database and remembered SQL Server Management Studio doesn’t make this as easy as it could be.

I can’t say that I’ve done my… Read more

1 comments, 2,874 reads

Posted in On the Fringe on 21 March 2014

Doing it with the EzAPI

In my last post, I attempted to write a SQL Server Integration Services (SSIS) Package programmatically.

I used the API that comes with SSIS to build a Package that sourced data from a flat file and loaded it into a Table in a SQL Server Database.

I also mentioned another… Read more

0 comments, 3,891 reads

Posted in On the Fringe on 9 March 2014