Author Archives: Clay Lenhart
SQL Server Security with EXECUTE AS OWNER
EXECUTE AS OWNER is a great way to limit the permissions of a SQL Server Login. The general idea is to create your stored procedure with the EXECUTE AS OWNER modifier. Any user who has the permissions to execute the … Continue reading
Version Control – Part 4: Distributed Version Control
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
Version Control – Part 3: Branching/Merging
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
Version Control – Part 2: Update/Commit
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
Version Control – Part 1: Checkin/Checkout
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
Moving SSAS databases
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
Natural Keys vs Surrogate Keys
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
SSRS filter values missing from a SSAS datasource
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
SAN RAID Performance
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
SQL Server 2008 Nov CTP Released
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