Author Archives: Clay Lenhart

About Clay Lenhart

I am a DBA/Technical Architect for Latitude Group and love technology.

Version Control – Part 4: Distributed Version Control

Posted on January 23, 2008 by Clay Lenhart

There are many reasons to create branches in the Update/Commit model and Distributed Version Control really excels in an environment with many branches. Take the examples in the previous post: In Distributed Version Control, each of these would be “repository/working … Continue reading →

Posted in Source Control | 3 Comments

Version Control – Part 3: Branching/Merging

Posted on January 11, 2008 by Clay Lenhart

Branch and Merge Many people who implement Update/Commit typically organize the server into the Trunk and Branches folders: This allows you work on long term, scheduled features in Trunk, while making unexpected bug fixes in the latest branch: v2.0. The … Continue reading →

Posted in Source Control | 4 Comments

Version Control – Part 2: Update/Commit

Posted on January 8, 2008 by Clay Lenhart

The problem with Checkin/Checkout Generally speaking, Checkin/Checkout interrupts developers. You want to finish your task, but you can’t continue on a portion of it, which then interrupts your thought process. The more developers you have with the Checkin/Checkout model, the … Continue reading →

Posted in Source Control | 15 Comments

Version Control – Part 1: Checkin/Checkout

Posted on January 7, 2008 by Clay Lenhart

Linus Torvalds is big on distributed version control (http://lwn.net/Articles/246381/), and I’m starting to see the light. Distributed version control is something any organization should seriously consider, not just open source projects. This is a start of a series of blog … Continue reading →

Posted in Source Control | 17 Comments

Moving SSAS databases

Posted on December 10, 2007 by Clay Lenhart

Here is an article on moving SSAS databases. The only thing to add is to be sure to set the file permissions on the folder. http://www.ssas-info.com/ssas_faq/ssas_management_faq/q_how_do_i_move_analysis_services_database_to_a_different_folder.html

Posted in SSAS | 6 Comments

Natural Keys vs Surrogate Keys

Posted on December 10, 2007 by Clay Lenhart

This blog entry has a good description of the pros (and some cons) of surrogate keys: http://rapidapplicationdevelopment.blogspot.com/2007/08/in-case-youre-new-to-series-ive.html

Posted in SQL Server Development | 9 Comments

SSRS filter values missing from a SSAS datasource

Posted on December 10, 2007 by Clay Lenhart

I recently ran into a problem where the list of values in a filter were missing for a dimension. It was due to having a fact relationship from the dimension to a very small fact table. In fact, the table … Continue reading →

Posted in SSAS, SSRS | 5 Comments

SAN RAID Performance

Posted on December 9, 2007 by Clay Lenhart

It is difficult to find information on how different RAID levels perform. I did some performance testing with 14 SCSI disks in a SAN, and came up with the following conclusions (heavy dose of salt needed): More disks == faster … Continue reading →

Posted in Hardware | 22 Comments

SQL Server 2008 Nov CTP Released

Posted on November 26, 2007 by Clay Lenhart

The November CTP for SQL Server 2008 has been released: http://www.microsoft.com/downloads/details.aspx?FamilyId=3BF4C5CA-B905-4EBC-8901-1D4C1D1DA884&displaylang=en

Posted in SQL Server Administration | 9 Comments

List statistics and date updated

Posted on November 25, 2007 by Clay Lenhart

The following query will list all the statistics in the current database, and the date they were lasted updated. SELECT object_name(object_id) as tablename, name AS index_name, STATS_DATE(object_id, stats_id) AS statistics_update_date FROM sys.stats WHERE object_id > 1000 ORDER BY object_name(object_id), STATS_DATE(object_id, … Continue reading →

Posted in SQL Server Administration | 6 Comments