Browse by Tags

All Tags » Security (RSS)

Important Security Update for SQL Server MS08-040

Microsoft have released a set of security updates for SQL 7, 2000 and 2005 to resolve four privately disclosed vulnerabilities. For details of the affected systems and vulnerabilities see Microsoft Security Bulletin MS08-040 . Note that if you have already...
Posted by sqldbatips | with no comments
Filed under: ,

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...
Posted by sqldbatips | with no comments
Filed under: , ,

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...
Posted by sqldbatips | 1 comment(s)
Filed under: , ,

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...
Posted by sqldbatips | with no comments
Filed under: , ,

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...
Posted by sqldbatips | 3 comment(s)
Filed under: , ,

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...
Posted by sqldbatips | 1 comment(s)
Filed under: , ,

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...
Posted by sqldbatips | 4 comment(s)
Filed under: , ,

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...
Posted by sqldbatips | 5 comment(s)
Filed under: , ,

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...
Posted by sqldbatips | with no comments
Filed under: , ,

SQL Server 2005 Best Practices Analyzer (February 2007 CTP)

It has been a while in coming but you can now download the CTP of the SQL Server 2005 Best Practice Analyzer tool. The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a...
Posted by sqldbatips | with no comments