Louis Davidson

Louis has been in the IT industry for over 20 years as a corporate database developer and data architect. Currently he is the Data Architect for CBN in Virginia Beach. Louis has been a Microsoft MVP since 2004, and is an active volunteer for the PASS locally and globally. He is the author of a series of SQL Server Database Design books, most recently Pro SQL Server Relational Database Design and Implementation.

Follow Louis on

16 February 2009
16 February 2009

Business Rule Enforcement

0
I know this is a topic that could cause a few heads to spin around uncontrollably if taken the wrong way, but I preserve.  Today I was having a conversation with an end user, an influential one at that, about a business rule that was needed for the time entry system we are putting together … Read more
0
08 January 2009
08 January 2009

The first pillar – A Coherent Design

0
One of the definitions on wiktionary.org for coherence is “a logical arrangements of parts”. In my initial post, I defined “coherent” for database designs in the following manner: cohesive, comprehendible, standards based, names/datatypes all make sense, needs little documentation.  Both definitions share one specific common theme: “logical”.  To me, the crux of this statement is … Read more
0
08 January 2009
08 January 2009

Book Reviews…

0
When I wrote the 2005 book, I promised that I would take the time to respond to reviews as much as possible. From the good ones if I didn’t really believe that the person read the book (there were a few I have seen, but not too many people tend to write good reviews that … Read more
0
04 January 2009
04 January 2009

2009 SQL Resolutions

0
Every year I put out resolutions, but this year is a little different.  I will post my SQL only blog resolutions here, and my personal ones here. Every year I find my ability to put out stuff is limited by my desire for sleep and fun, and this year is no different. So I am … Read more
0
16 December 2008
16 December 2008

The phases of database design

0
Before I get started with the pillars of a well built database, I want to reply (in long form) to a comment on the last post. I see the phases of the project to have five distinct phases (again trying to make memorable lists that an stick in your mind): Requirements – The process of … Read more
0
15 October 2008
15 October 2008

Inheritance in Database Design

0
As I have been walking around Disney World this week, my mind starts to wander to matters of database design. Sad, perhaps, but I will guess that most people who read this blog do the same much the same thing with whatever technology they are good at when they are relaxing also.  It also may … Read more
0
30 July 2008
30 July 2008

Commenting your code

0
As I am easing back into real life from writing the book, I am in search of easy targets for blogging.  My boss mentioned this blog over on Jeff Atwood’s Coding Horror Blog and it got me thinking about commenting.  His advice is to only comment “why” the code works.  I can’t quite agree, because … Read more
0
13 July 2008
13 July 2008

Triggers…Evil?

0
Say it isn’t so. “It isn’t so.”  Glenn Berry thinks so in his post here. When I read his post I thought I was going to really get into it with Conor’s post here, called the Trouble with Triggers (a title which I had to post because I like Star Trek too,) but frankly I … Read more
0
30 May 2008
30 May 2008

See you at Tech Ed? Or other places?

0
Next week is Tech Ed Developers, and I will be there working at the OLTP demo station from: Tuesday 11:45 – 2:45 Wednesday 2:30 – 6:00 Thursday 11:45 – 2:45 Friday 11:45 – 2:45 All times Eastern Daylight Saving Time and a little bit approximate at this point.  Please stop by and say howdy!  I … Read more
0
23 March 2008
23 March 2008

Sequence Table Tricks

0
Ok, so I am writing about the kinds of things you can do with a sequence table, and I have built the table, I have the typical kinds of things planned (like splitting a string, and for the next section, loading a calendar table) but I wanted to do something interesting.  And frankly, sometimes the … Read more
0
05 March 2008
05 March 2008

2008: Error List in 2008

0
Ok, so I was looking around for a blurb about plan guides for my anti ad hoc SQL section of my book (ok, maybe not completely anti- but that isn’t the point,) when I found this blog: http://geekswithblogs.net/Sreeblog/articles/117576.aspx that basically just lists some new features in 2008.  One that I hadn’t seen I feel the … Read more
0
26 February 2008
26 February 2008

2008: Rebuilding a Heap

0
In 2005, rebuilding a table that was a heap (no clustered index) wasn’t easy.  You could copy it to a different table, or you could add a clustered index and then drop it. In 2008, this is a far easier thing to do.  They have added to the ALTER TABLE command a method to rebuild … Read more
0
05 December 2007
05 December 2007

Changing the owner of a database

0
Tonight, as I was creating my sample database for my chapter on implementing the database, I learned something new, that existed in 2005.  I had always used sp_changedbowner to change the owner of a database, but I was reading in another section about ALTER AUTHORIZATION earlier to change the owner of an object in a … Read more
0
04 November 2007
04 November 2007

sys.dm_exec_xml_handles

0
d Gives you information about any sessions that are using xml documents, including stats about the XML document and usage.  You can also get the statements that were used to create the XML handle using sys.dm_exec_sql_text to get the sql. Type: FunctionParameter: session_idData: Snapshot, values based on current realityColumns: session_id – the session_id of the … Read more
0