Archives: October 2008
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
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.
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 :|
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
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
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
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
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
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 :|
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
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:
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
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