drsql.org

Whoever dies with the most tables wins
Home
Design Book
DMV Book
Links
Non Database Stuff
Contact me
About
Presentations
Calendar of Events
Downloads
Code Snippets

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 a slowly forming blog on SqlBlog.com here, and it will become more of a going concern once I finish my 2008 book.

 

If you want to search my sites, I have implemented a Search function using Windows Live macros. You can see use the link in the footer of the page right now and hopefully later embedded on this site (I still can'tcan't get the  HTML support to support the advanced search, but for free I am elated to have the link ability!)

 

 
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