Browse by Tags

All Tags » Katmai (RSS)
07 August 2008 08:49

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: ,
07 August 2008 00:11

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 | with no comments
Filed under: , ,
28 June 2008 10:00

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 | 3 comment(s)
Filed under: ,
27 June 2008 18:30

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: , ,
27 June 2008 18:15

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: , ,
27 June 2008 18:10

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: , ,
27 June 2008 18:05

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 | 2 comment(s)
Filed under: , ,
27 June 2008 18:00

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: , ,
25 June 2008 09:00

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: , ,
24 June 2008 21:11

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: , ,
24 June 2008 15:38

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 | 4 comment(s)
Filed under: , ,
21 June 2008 15:35

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: , ,
20 February 2008 14:54

SQL 2008 February CTP now available

The February CTP of SQL 2008 is now publicly available and can be downloaded from the link below. If you've been holding off trying out SQL 2008 this is a great release to give a try as it is practically feature complete and will let you try out all the...
Posted by sqldbatips | with no comments
Filed under:
30 November 2007 19:00

New builds of SQL 2005 Service Manager available adding SQL 2008 compatability

New versions of SQL 2005 Service Manager are now available for WinXP/Win2003/Win2008 and Vista. The only changes in these new releases are the addition of SQL 2008 support and Windows 2008 support for the non Vista version. As it turned out, adding SQL...
Posted by sqldbatips | with no comments
Filed under: ,
19 November 2007 18:43

SQL 2008 November CTP now available

The November CTP of SQL Server 2008 is now available for download at the link below Download SQL 2008 November CTP There's a lot of new functionality and features in this latest CTP including (but not limited to) Backup Compression Resource Governor TSQL...
Posted by sqldbatips | with no comments
Filed under: ,
More Posts Next page »