March 2009 - Posts

• Heading to SQL Connections!

  You know how when you go to a session and there is always this person who is heckling the presenter?  Well, it isn’t that often that this person is authorized to be annoying people/answering questions at the request of the main presenter.  Well, Read More... Posted Friday, March 20, 2009 12:45 AM by drsql | 2 Comments Filed under: Database Design, Speaking

• Granting rights to all objects in a database

  File this under the “I can’t believe there is still stuff that I keep learning about SQL Server 2005!” though thankfully most things I find I learn are things I wouldn’t be all that likely to use. I was asked today how I felt about using the syntax: GRANT Read More... Posted Friday, March 13, 2009 12:38 AM by drsql | 8 Comments Filed under: Security, Tips, T-SQL

• The second pillar - Normal

  The first pillar was easy, since no reasonable person is going to argue that having a design that is not coherent is desirable. No matter what the type of system, any design that isn’t easy to understand is likely to be a bad design (obvious caveats are Read More... Posted Sunday, March 01, 2009 3:14 PM by drsql | 2 Comments Filed under: Best Practices, Database Design, Normalization, Pillars