Browse by Tags

All Tags » SQL 2008 (RSS)
15 September 2008 20:37

SQL 2008 Unleashed

In the UK we had a Technet event at Microsoft Reading last Wednesday to celebrate the RTM of SQL Server 2008 (see more here ). It was a great day with lots of interesting and fun sessions highlighting some of the benefits and new features of SQL Server...
Posted by sqldbatips | with no comments
Filed under: ,
10 September 2008 20:43

First thing to do after installing SQL Server Management Studio 2008

One of the strangest UI design decisions in Management Studio for SQL 2008 is that by default the Start Debugging button is right next to the Execute button as shown below I myself have hit it by accident more times than I'd like to admit and I have...
Posted by sqldbatips | with no comments
Filed under: , ,
02 September 2008 14:23

Enabling My Reports feature in Reporting Services 2008

Although most of the functionality that used to be available for managing Reporting Services from Management Studio has now been removed in SQL 2008 (I assume because research showed the majority of customers use the Report Manager web interface), enabling...
Posted by sqldbatips | 1 comment(s)
Filed under: , ,
19 August 2008 15:36

Using Expressmaint on SQL Server 2008

With the release of SQL 2008 Express I thought it would be helpful to add a note that it you try to use the ExpressMaint utility to perform database maintenance operations against SQL Server 2008 on a computer which has never had SQL Server 2005 installed...
Posted by sqldbatips | with no comments
Filed under: ,
15 August 2008 16:43

Updated Releases of SQL 2005 Service Manager now available

A new build of SQL 2005 Service Manager is now available for XP, Windows 2003 and Windows 2008 (1.0.0.14) and Vista (2.0.0.6). This release adds a fix for duplicate SSIS services when both SQL 2005 and SQL 2008 are installed. Note that it is fully compatible...
Posted by sqldbatips | 1 comment(s)
Filed under: ,
14 August 2008 19:47

SQL 2008 Install Blocked on Express Tools but actually due to SQL Prompt

Having successfully installed SQL 2008 on my laptop I was looking forward to a smooth install on my main PC however it was not to be. Having gotten pretty much to the end of setup it failed on the SQL 2005 Express Tools rule. Now I know I've never...
Posted by sqldbatips | 4 comment(s)
Filed under: ,
14 August 2008 08:37

SQL 2008 Express Edition available for download

The basic version of SQL 2008 Express is not available for download, the other editions (SQL 2008 Express with Tools and SQL 2008 Express with Advanced Services) are coming soon. Don't forget you will need to have installed .NET 3.5 SP1 and Windows...
Posted by sqldbatips | with no comments
Filed under: , ,
11 August 2008 21:05

Visual Studio 2008 Service Pack 1 RTM download now available

As mentioned in a previous post , parts of SQL 2008 require you to have Visual Studio 2008 SP1 RTM installed if you had previously installed Visual Studio 2008 prior to installing SQL 2008. Today, Visual Studio 2008 Service Pack 1 RTM is available for...
Posted by sqldbatips | with no comments
Filed under: , ,
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: , ,
02 July 2008 15:00

Updated Release of SQL 2005 Service Manager for Vista now available

A new build of SQL 2005 Service Manager is now available for Windows Vista (2.0.0.5). This releases adds compatability for SQL 2008 RC0 and filters the SQL Agent service from being managed for SQL 2008 Express Edition (see why here ) Download SQL 2005...
Posted by sqldbatips | 1 comment(s)
Filed under: ,
30 June 2008 09:48

Updated Release of SQL 2005 Service Manager now available

A new build of SQL 2005 Service Manager is now available for XP, Windows 2003 and Windows 2008 (1.0.0.13). This releases adds compatability for SQL 2008 RC0 and filters the SQL Agent service from being managed for SQL 2008 Express Edition (see why here...
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: , ,
More Posts Next page »