Browse by Tags

All Tags » Katmai (RSS)

SQL 2008 RTM download now available from MSDN

As you may have already seen elsewhere, SQL 2008 was released to manufacturing yesterday. View the official press release here . The good news is that all the editions except Express are available for download right now if you have an MSDN subscription...
Posted by sqldbatips | 1 comment(s)
Filed under: ,

SQL Server 2008 RTM August Feature Pack available

A new feature pack (August) is now available for the RTM release of SQL 2008. This allows you to download redistributable components of SQL 2008, add-on providers and backwards compatability components. No Report Builder 2.0 yet though Microsoft SQL Server...
Posted by sqldbatips | 1 comment(s)
Filed under: , ,

SQL Server 2008 Express installs SQL Agent (but don't bother trying to start it)

If you have installed either of the Express Editions available in the SQL Server 2008 RC0 download you may have noticed that as well as the SQL Server service for the Express instance, setup also installs the SQL Agent service. Great news you might think...
Posted by sqldbatips | 5 comment(s)
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: , ,

Microsoft SQL Server 2008 Feature Pack RC0 (June 2008)

The June feature pack for SQL Server 2008 RC0 allows you to download individual componets of the RC0 release (e.g. SMO, command line utilities, SQL Native Client) as well as some additional tools. Most notably, you can download Report Builder 2.0 and...
Posted by sqldbatips | with no comments
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: , ,
More Posts Next page »