Skip to main content

Sydney SQL Server Users Group – Mon 6th Nov 2006

SQL Server (Sydney) Users Group meeting has been moved to Monday 6th November 2006 when Richard Lees will present “OLAP, what is it good for?” Richard will show the insides (and outsides) of an OLAP cube created to assist in monitoring and managing a 6 node Oracle RAC database that sustains 600 transactions per second […]

Team Foundation Server High Availability with SQL Server 2005 Mirroring

As Team Foundation Server (TFS) becomes the source code repository for more and more teams, SQL Server DBAs are ultimately responsible for the backup and availability of these databases. Sudhir Hasbe the Program Manager for Team Foundation Server has noted that SQL Server 2005 Mirroring will provide a warm standby but TFS will not automatically […]

Table Column Info or Sample Rows with a Single Key Press

Irena Kennedy has a neat trick for SQL Server Management Studio to quickly display some rows from a table, or get the metadata on columns of a table: a keyboard shortcut that is fast and works in any database. Has anyone else created similar keyboard shortcuts like this? Leave your comment here.

Inside DBCC CHECKDB… How does it work?

Paul Randal has been writing an excellent series on how DBCC CHECKDB works within SQL Server. Explaining how SQL Server 2000 and 2005 present a consistent view of the data for checking and why that is important. Paul moves onto what CHECKDB really does and then [story:sqlserver2005-dbcc-for-vldb]. Paul Randal worked as the Lead Developer / […]

Visual Studio Team Edition for Database Professionals CTP6 Released

Today marks the release of CTP6 of Visual Studio Team Edition for Database Professionals. I’m pretty excited to see the development of this Visual Studio product. Finally database developers will be able to work like other programmers. Extreme Programming methods will be useful. Through Visual Studio projects and source control more developers will be able […]

Free SQL Scripts for Managing and Monitoring SQL Server 2005

I came across these scripts on the Microsoft TechNet Script Centre Microsoft SQL Server 2005 Buffer Cache Retrieve Buffer Counts by Object and Index CPU and Optimization Determine CPU Resources Required for Optimization Retrieve Parallel Statements With the Highest Worker Time Retrieve Statements with the Highest Plan Re-Use Counts Retrieve Statements with the Lowest Plan […]