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