Browse by Tags

• Database Design
• Pillars
• SQL Server
• Tips
• T-SQL

• Fifth pillar - Secure

  As I have mentioned in all of the previous posts, basic functionality is the foundation of any system. So it goes without saying that if you have just implemented a payroll system, everyone is getting paid.  To meet the basic bar that EVERYONE agrees Read More... Posted Tuesday, October 06, 2009 7:52 PM by drsql | 1 Comments Filed under: Database Design, Pillars, Security, SQL Server

• 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