This video shows how to insert data into a SQL Server 2008 table using the Row Value Constructor.
This demo shows how to:
- Insert data into a SQL Server 2008 table
- Four different methods are used to insert bulk data, including the new Data Row Constructor
This video shows how to use the Service Audit Object to record events within SQL Server 2008 Enterprise Edition.
This demo shows how to:
- Create a Server Audit Object
- Create a Server Audit Specification
- Create a Database Audit Specification
- Examine the audit logs for Login Failed events
Many organizations have both Oracle and SQL Server databases. In this video Scott Golightly shows how easy it is to use the import data wizard and SQL Server Integration Services to import data from a table in an Oracle database into SQL Server.