An ounce of design is worth a pound of rework...
Home     Design Book     DMV Book     Links     Non Database Stuff     Contact me     About     Presentations     Calendar of Events     Downloads     Code Snippets     SQL Articles/Blogs      

Welcome to my website.  Feel free to drop me a line anytime at louis@drsql.org if you have any comments, or just want to tell me that you have used the site.  You may know me as drsql@hotmail.com, but I am going to change my email address some day! I have blog on SqlBlog.com here, and I am on twitter as drsql.

 

If you want to know more about me and my experience, you can get my resume here.

 

I have written several books on database design with SQL Server, and am currently working on a book on Dynamic Management Views with Tim Ford (aka SQLAgentMan).  I also try to get around and do presentations on Database Design whenever I can. I upload all of my slides here.. If you are interested, check out my calendar of events...Or I am always available for parties if you need someone to lead naptime.

 

Coming Soon: In the near future, look for a major update to this site, including putting together all of my informational blogs for reading/use.  In the meantime, added a search box to the Frequent Linkers section that will search my sqlblog.com blog, and the following one that searches this site.

 

 
Frequent Linkers

This is my list of bookmarks that I use frequently, some of them mine, some of them from other people.  All articles that are not located on drsql.org or spaces.msn.com/drsql are noted as such in [].  For the full list of spaces.msn.com/drsql articles, refer to SQL Server Article Index.
 

 

 Query for Current Server Activity (2005)
 Query locks being held (2005)
 Monitor rollback progress (2005)
 Searching objects for text value (2005)
 Query for PK, Identity, AK
 Query filegroups and indexes (2000,2005)
 Kicking a user out of a database immediately (2000,2005)
 Ranking - ROWNUMBER() (2005)
 Ranking - RANK(), DENSE_RANK() and NTILE() (2005)
 SQL Server 2005 System View Map [Microsoft.com/downloads] (2005) 
 SQL Formatter [Wangz.net] 
 How do I concatenate strings from a column into a single row? [aspfaq]
Other Sites I Frequently Use

This is my list of bookmarks of sites that I use frequently from other people. Note that these are sites that I use for frequent tasks, not just for simple research.
 Erland Sommarskog's home page (several extremely useful articles that I often grab code from)
 Tibor Karasi's SQL Server page (incl page on date data)

 

 
Publications  

I have written a couple of books about database design, and I will post information about the book, as well as extra downloads, goodies, etc for the book here.  If you have any comments about the book, please go here and send them please.  I do covet your comments as guides for whether or not I write or speak (publicly, of course) again.
 
 

 

 

Pro SQL Server 2008 Relational Database Design and Implementation

 

Louis Davidson with Kevin Kline, Scott Klein, and Kurt Windisch

Apress, 2008
 

 Interviews
 
Less Than Dot: Interview With Louis Davidson Author of Pro SQL Server 2008 Relational Database Design and Implementation -
http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/interview-with-louis-davidson-author-of-