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.

Related posts:

  1. SQL Solution center round-up – July 5th, 2013
  2. SQL Solution center round-up – October 17th, 2014 – Monitor SQL Server queries – find poor performers, and Italian and French translations of SQL Solution center articles
  3. SQL Solution center round-up – February 15th, 2014 – SQL formatting, recovery of deleted images, SQL Server auditing, security, and compliance
  4. SQL Solution center round-up – December 15th, 2013 – compliance guidelines for SQL DBAs, SQL Server performance monitoring, rules of SQL formatting
  5. SQL Solution center round-up – April 15th, 2014 – SQL Server database refactoring techniques
May 15, 2014