Need to export table data fast? A step by step, simple example of the BCP Command Line Utility, from finding bcp.exe to running the export.
Zip Files in SSIS With a Script Task and ZipFile
To zip files in SSIS you don’t need a third-party tool. This guest post by Kevin Hazzard shows how a Script Task and the .NET ZipFile class zip a whole folder in a few lines of C#, and which errors to expect.
SQL SERVER – View Dependencies on SQL Server: Hard & Soft Way
Most databases I meet as a consultant have no up-to-date documentation. Here is the hard way and the soft way to check SQL SERVER – View Dependencies yourself.
SQL SERVER 2016: Creating Simple Temporal Table
Want to see what your data looked like on a past date? Here is how to create a simple Temporal Table in SQL Server 2016, with its history table made for you.
SQL SERVER – Antivirus Exclusions Best Practices With SQL Server
If antivirus locks a SQL Server file, you can face startup issues or even corruption. Here are the antivirus exclusions best practices every DBA should follow.
SQL SERVER – How to Get SQL Server Restart Notification?
Want a restart notification when SQL Server starts, without buying a tool? Here are the steps to run a stored procedure at startup.
Keeping Admin Scripts One Click Away in SSMS Template Explorer
Organize SSMS Template Explorer scripts, fill reusable parameters, review a copy-only backup, and preserve custom templates on disk.