Browse by Tags

• Best Practices
• Development
• Misc
• Nashville
• Security
• Speaking
• SQL Rally
• SQL Techniques
• SQLPASS
• T-SQL
• Utility
• Why We Write

• Why We Write #6-An Interview with Kevin Kline

  Wow, so far in this series, I have interviewed some very good friends, and some truly excellent writers (and usually both), but today, following on the heels of Jason Strate , we are going to hit someone whose name is synonymous with community, a person Read More... Posted Wednesday, June 05, 2013 9:00 PM by drsql | 0 Comments Filed under: Nashville, Speaking, Tips, Why We Write

• Utility Objects Series Introduction (but mostly a bit of an update)

  So, I have been away from blogging about technical stuff for a  long time,  (I haven’t blogged at all since my resolutions blog , and even my Simple Talk “commentary” blog hasn’t had an entry since December!)  Most of this has been due Read More... Posted Sunday, March 11, 2012 10:52 PM by drsql | 1 Comments Filed under: SQL Rally, SQLPASS, Tips, Utility

• disallow results from triggers

  A setting that I noticed a while back when looking at sys.configurations was disallow results from triggers.   Triggers are one of my favorite subjects, and you will find a lot of good uses of them in my book (triggers are also well named, as poor Read More... Posted Saturday, June 06, 2009 10:38 PM by drsql | 1 Comments Filed under: Best Practices, Development, SQL Techniques, Tips, T-SQL

• 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

• A few Word tips and tricks for writers

  Edit: Added ideas from comments at the end of the blog Not exactly a SQL topic, but I am working on formatting a chapter from a book I am working on with a cowriter and I realized that there were a few things that I find myself doing over and over with Read More... Posted Sunday, January 18, 2009 12:51 AM by drsql | 7 Comments Filed under: Misc, Tips