Browse by Tags

Sorry, but there are no more tags available to filter with.

Workaround for Audit issue when targetting the Security Log in SQL 2008 RC0

In RC0, the registry entry that specifies the message file for audit events that are written to the security event log is incorrect ( Connect Item 352787 ). This means that when viewing audit events written to the security log in Event Viewer you will see the following text in the description (I'm...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 06-27-2008
New in SQL 2008: Server and Database Auditing Part III

In this post I'll cover how to create Database Audit Specifications to audit database level events. This post is part of a series so if you missed Part I you can find it here and Part II here . Database Audit Specification Database Audit Specifications define the audit action groups, individual audit...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 06-27-2008
New in SQL 2008: Server and Database Auditing Part II

In this post I'll cover how to create a Server Audit Specification to audit Instance level events. This post is part of a series so if you missed Part I you can find it here Server Audit Specification Server Audit Specifications define the audit action groups that you want to audit at the Instance...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 06-27-2008
New in SQL 2008: Server and Database Auditing Part I

In this post I'll cover how to create the Server Audit Object itself and the configuration for the targets of the audit (Application Event Log, Security Event Log or File) S erver Audit Object The Server Audit object is the first object you create when enabling auditing on an instance of SQL Server...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 06-27-2008
New in SQL 2008: Server and Database Auditing Overview

Overview In SQL Server 2008 Enterprise Edition, Instance and Database level audit is now a built in function of the Database Engine with its own set of instance and database level objects, Server Audit and Server Audit Specification at the instance level and Database Audit Specification at the Database...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 06-27-2008
New in SQL 2008 : Transparent Data Encryption Part II

In Part I we created the required keys and certificate to enable Transparent Data Encryption for the TDE database. In this post I'll cover how to restore an encrypted database to another instance (e.g. to set up database mirroring or log shipping). In order to be able to restore the now encrypted...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 06-24-2008
New in SQL 2008 : Transparent Data Encryption Part I

Overview Transparent Data Encryption (TDE) provides a w ay to encrypt all the data in a database with no changes to applications that access that data. It provides protection for the data at rest by performing encryption as data is written to database files and the transaction log and decryption when...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 06-24-2008
Demo code from UK SQL 2008 Launch Event

The code for the demos from the UK SQL 2008 Launch Event are now available from the link below. Given the short amount time we had and all the great questions I'll expand on each of the demos with some blog posts over the next few days to put them in a bit more context. Note that you will need SQL...

Posted to sqldbatips.com blog (Weblog) by sqldbatips on 06-21-2008

Page 1 of 1 (8 items)