SQL Solution center round-up – May 15th, 2014 – SQL Server bulk copy and bulk import and SQL Server event notifications

In the latest SQL Solution center articles, we wrote about SQL Server bulk copy and bulk import and export techniques and showed how to be notified about a SQL Server instance event.

In SQL Server bulk copy and bulk import and export techniques, we wrote about techniques to export or import large amounts of data into or out of a database using bulk export and import operations. We showed how to use the Import and Export Wizard in SQL Server Management Studio and bcp utility. We gave examples for the T-SQL BULK INSERT and SELECT INTO statements, and the OPENROWSET(BULK) function. We also gave steps to export and import data by using ApexSQL Script and to copy data by using ApexSQL Data Diff.

In SQL Server auditing – how to get notified about an event, we showed how to use SQL Server native features – SQL Server Audit, SQL Server Change Data Capture and Change Tracking, and SQL Server triggers to audit SQL Server events. We also showed how to raise an alert when a specific event occurs using SQL Server triggers and ApexSQL Audit.

May 15, 2014