Andy Leonard explains the basics of the SSIS Execute Process Task, used to start a custom application or run an operating system command from a package.
SQL SERVER – Basic Statistics Maintenance – Notes from the Field #083
Statistics help the SQL Server engine pick an optimal plan. This Notes from the Field episode covers the basics of statistics maintenance every DBA should know.
SQL SERVER – What are T-SQL Window Functions? – Notes from the Field #082
Kathi Kellenberger, one of my favorite SQL authors, explains what T-SQL window functions are and how the OVER clause works in SQL Server.
SQL SERVER – Adding Reference Data to Master Data Services – Notes from the Field #081
Reeves Smith shows how to add reference data to Master Data Services with the MDS add-in for Excel, so the business can manage it themselves.
SQL SERVER – SSIS and How to Load Binary Large Objects, or Blobs – Notes from the Field #080
In Notes from the Field #080, Andy recalls his first project loading product images with SSIS and explains how to load binary large objects, or Blobs.
SQL SERVER – Using Package Configurations in SSIS 2012 and Beyond – Notes from the Field #079
Moving to SSIS 2012 or 2014 and worried about losing the Package Configurations you built? Good news: the classic option is still there. Here is how to use it.
SQL SERVER – Recovering from Snapshots – Notes from the Field #078
Data deleted by accident? John Sterrett explains recovering from snapshots, a very useful but less used feature, without panic making things worse.