Saurabh Dhoble

Saurabh Dhoble works as a senior database developer in the financial industry. Having spent his early programming years working as an ASP.NET programmer, he now specializes in SQL Server and the Microsoft BI suite. In his free time, he explores features on various development platforms, including SQL Server, front-end technologies, and cloud technologies.

30 June 2014
30 June 2014

Developing a Custom SSIS Source Component

9
59
SSIS was designed to be extensible. Although you can create tasks that will take data from a wide variety of sources, transform the data is a number of ways and write the results a wide choice of destinations, using the components provided, there will always be occasions when you need to customise your own SSIS component. Yes, it is time to hone up your C# skills and cut some code, as Saurabh explains.… Read more
9
59
28 May 2014
28 May 2014

Setting Up Your SQL Server Agent Correctly

It is important to set up SQL Server Agent Security on the principles of 'executing with minimum privileges', and ensure that errors are properly logged and alerts are set up for a comprehensive range of errors. SQL Server Agent allows fine-grained control of every job step that should allow tasks to be run entirely safely even if they occasionally need special privileges.… Read more