SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: October 2008

SQL Server 2008 Data Compression Example

I was experimenting with the effects of row and page compression in SQL Server 2008 Enterprise Edition.

First, I identified a row in a production database called so_hdr_tbl that I wanted to compress. Before compressing it, I checked the size of the table, and it had 54,840 rows and took… Read more

5 comments, 4,021 reads

Posted in SQL Aloha on 31 October 2008

New Books on SQL Server 2008

Since the release of SQL Server 2008, a slew of new books have been released, or are about to be released on it. Below are some of the titles I recommend you check out. By the way, I know all of these authors, and I highly recommend them.



Read more

0 comments, 1,523 reads

Posted in SQL Aloha on 30 October 2008

Free SQL Server Health & History (SQLH2) Tool Updated for SQL Server 2008

Microsoft's free SQL Server Health & History tool (SQLH2) has had a minor update and can now be used with SQL Server 2008.

You can now download it at: http://www.codeplex.com/sqlh2



Share this post :

Read more

6 comments, 2,151 reads

Posted in SQL Aloha on 21 October 2008

What's Your Job Title?

As I travel and visit DBAs from around the United States, I am always surprised at the job titles DBA have. Rarely is their official job title "DBA." Some are Data Analysts, Data Architects, System Administrators, IT Specialists, Developers, and on the rare occasion, Database Administrator.

So, for fun, I… Read more

1 comments, 577 reads

Posted in SQL Aloha on 16 October 2008

Looking for Free Educational Events to Attend?

Every week, there are dozen of free educational events to attend throughout the United States. The sad part is that many people don't attend because they don't know about them. Unfortunately, there is still no single source listing all of the available free technical events you can attend, but there… Read more

1 comments, 549 reads

Posted in SQL Aloha on 15 October 2008

SQL Saturday in Olympia , WA Pulls in Crowd of over 130 DBAs and Developers

A SQL Saturday event was held Saturday, October 11, 2008 in Olympia, WA. Sponsored by the Olympia Area SQL Server Users Group, and coordinated in large part by Greg Larson (who runs www.SQLServerExamples.com), this was the first such event held in Olympia.

Over 130 from the surrounding areas… Read more

1 comments, 504 reads

Posted in SQL Aloha on 11 October 2008

Tulsa TechFest Draws a Crowd of Over 500

The annual Tulsa TechFest (Tulsa, OK) had over 500 attendees today (Thursday), and is expecting another 500+ attendees on Friday. This major regional event includes 17 different tracks, has over 70 speakers and offers over 100 sessions. The event is coordinated by David Walker, MVP, who is also the president… Read more

0 comments, 405 reads

Posted in SQL Aloha on 9 October 2008

Can't Attend SQL Server Training in Person, Consider Virtual Training

I am one of the biggest advocates there is of self-education. Whether you are a novice, intermediate, or expert-level DBA, there is always something new to learn. Some of us learn best by reading, others by doing, and others by attending classes, user groups, or conferences in person. If you… Read more

0 comments, 912 reads

Posted in SQL Aloha on 7 October 2008

The Call for Nominations to the SQL PASS Board of Directors is Now Open Until October 24, 2008

If you have ever considered taking a leadership role in PASS, you should seriously consider becoming a SQL PASS board member. Information on the required qualifications and the nomination process are available at:




Share this post :

Read more

0 comments, 378 reads

Posted in SQL Aloha on 7 October 2008

SQL Server 2008 Books Online Have Been Updated

The version of SQL Server 2008 Books Online that was included with the RTM version has now been updated to the August 2008 version, which is available at the following link:




If you are using SQL Server 2008, I highly suggest you download it and update the… Read more

0 comments, 455 reads

Posted in SQL Aloha on 6 October 2008

IndyTechFest A Great Success

Just got back from attending IndyTechFest in Indianapolis, IN, which was held on Saturday, October 4, 2008, and had nearly 500 attendees. This event is the product of a collaboration between IndyNDA (Indianapolis .NET Users Group) and IndyPASS (SQL Server User’s Group). The main people behind this event include:

  • John…

Read more

0 comments, 618 reads

Posted in SQL Aloha on 6 October 2008

A Focus on Novice DBAs: My Upcoming PASS Presentations

The PASS Community Summit 2008 is coming up fast (November 18-21, 2008), and if you are attending and you are a novice- to intermediate-level DBA, I want to recommend the two sessions I will be presenting.

The first session is called "DBA 101: Best Practices for All DBAs to Follow."… Read more

0 comments, 562 reads

Posted in SQL Aloha on 1 October 2008

When Will You Begin Implementing SQL Server 2008?

As I have been talking to DBAs around the country, I have noticed a trend that many, if not most, organizations are waiting to implement SQL Server 2008 to any significant degree. I was wondering what your opinion on this topic is?

If you have time, let me know your… Read more

2 comments, 326 reads

Posted in SQL Aloha on 1 October 2008