Browse by Tags

• 64 Bit
• Best Practices
• Catalog Objects
• Concurrency
• Database Design
• Design
• Development
• Documentation
• Dynamic Management
• Dynamic Management Objects
• Normalization
• PASS
• Pillars
• Search
• Security
• Speaking
• SQL Saturday
• SQL Techniques
• SQL Tools
• SQLPASS
• SSAS
• SSIS
• SSMS
• System Functions
• Terminology
• Third Party Tools
• T-SQL
• Why We Write
• Writing

• Why We Write #1 - An Interview With Thomas LaRock

  I 've been a writer of trade level technical materials for over 13 years now, writing books, articles, blogs, and even tweets for a variety of outlets, almost exclusively about Microsoft SQL Server. While I won't claim to be the best writer in the world, Read More... Posted Thursday, March 21, 2013 8:03 PM by drsql | 2 Comments Filed under: SQL Server, SQLPASS, Why We Write, Writing

• Chapter 7–Enforced Data Protection

  As the book progresses, I find myself veering from the original stated outline quite a bit, because as I teach about this more (and I am teaching a daylong db design class in August at http://www.sqlsolstice.com/ … shameless plug, but it is on topic :) Read More... Posted Tuesday, June 21, 2011 12:36 AM by drsql | 0 Comments Filed under: Database Design, SQL Server, Writing

• See you in Columbus Saturday?

  Assuming all goes as planned, I will be in Columbus, OH this Friday night and Saturday for SQL Saturday 75 . I really love SQL Saturday events the best of all of the events because they are very intimate in nature. As a fairly antisocial person, I sometimes Read More... Posted Monday, June 06, 2011 12:32 AM by drsql | 2 Comments Filed under: Database Design, PASS, Speaking, SQL Saturday, SQL Server

• Normalization and How to Know When You Are Done… The short version…

  A while back, I was working on a short article about Normalization for a book that never got published (admittedly I wasn’t getting paid for the article, and it wasn’t for charity, so I wasn’t that broken up over it.)  The task at hand was to, in Read More... Posted Sunday, May 29, 2011 4:54 PM by drsql | 1 Comments Filed under: Database Design, Design, Development, Normalization, SQL Server, Terminology, Writing

• Quest DMV Breakfast Code – Disk IO

  For any of you who attended the Quest breakfast at PASS (and anyone else really) I wanted to go ahead and post the code and give a little wrap up/explanation. (I will post the stuff on perf counters later. They are cool, but this is really what I wanted Read More... Posted Wednesday, November 04, 2009 12:52 PM by drsql | 1 Comments Filed under: Dynamic Management, PASS, Speaking, SQL Server, SQL Techniques, SQL Tools

• 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

• Headed..South..To Atlanta for SQL Saturday

  Heading down to SQL Saturday ( www.sqlsaturday.com ) in Atlanta to give a 9:15 AM session on Database Design, with a greater than normal dose of normal thrown in. I hope there are more than 7 people to show up, because I would hate if everyone got some Read More... Posted Thursday, April 23, 2009 10:55 PM by drsql | 3 Comments Filed under: Speaking, SQL Server

• Commenting your code

  As I am easing back into real life from writing the book, I am in search of easy targets for blogging.  My boss mentioned this blog over on Jeff Atwood's Coding Horror Blog and it got me thinking about commenting.  His advice is to only comment Read More... Posted Wednesday, July 30, 2008 10:19 PM by drsql | 8 Comments Filed under: Best Practices, Database Design, SQL Server, SQL Techniques

• 2008: Error List in 2008

  Ok, so I was looking around for a blurb about plan guides for my anti ad hoc SQL section of my book (ok, maybe not completely anti- but that isn't the point,) when I found this blog: http://geekswithblogs.net/Sreeblog/articles/117576.aspx that basically Read More... Posted Wednesday, March 05, 2008 10:40 PM by drsql | 4 Comments Filed under: SQL Server, SQL Tools, SSMS

• 2008: Declaring and instantiating a value

  Ok, I admit it. Sometimes the least important things are the most fun. As I try to get my blog back up and kicking again after a few months of holiday fun coupled with some dreary personal life things (a death in the family and lots of sickness/busyness, Read More... Posted Saturday, March 01, 2008 7:40 PM by drsql | 16 Comments Filed under: SQL Server, T-SQL

• 2008: Rebuilding a Heap

  In 2005, rebuilding a table that was a heap (no clustered index) wasn't easy. You could copy it to a different table, or you could add a clustered index and then drop it. In 2008, this is a far easier thing to do. They have added to the ALTER TABLE command Read More... Posted Tuesday, February 26, 2008 11:10 PM by drsql | 7 Comments Filed under: Dynamic Management Objects, SQL Server, T-SQL

• Changing the owner of a database

  Tonight, as I was creating my sample database for my chapter on implementing the database, I learned something new, that existed in 2005. I had always used sp_changedbowner to change the owner of a database, but I was reading in another section about Read More... Posted Wednesday, December 05, 2007 12:06 AM by drsql | 1 Comments Filed under: SQL Server, T-SQL

• PASS Followup, Technical Edition

  I have already given a rundown of most everything PASS here on my personal blog, including a series of posts with pictures too over the days of PASS ) but since this blog is all about things technical with SQL Server, I wanted to just rundown of some Read More... Posted Tuesday, September 25, 2007 1:03 AM by drsql | 2 Comments Filed under: PASS, SQL Server

• sys.dm_db_index_operational_stats

  This object provides very useful stats on how many times an index has been used, locked, waited on, etc. An index in this context can mean several things: a clustered index, heap, index, or a partition of either of these. The grain of the function is Read More... Posted Sunday, August 26, 2007 4:12 PM by drsql | 5 Comments Filed under: Dynamic Management Objects, SQL Server, T-SQL

• sys.dm_exec_query_optimizer_info

  Information about how queries have been optimized since the server has been restarted. Note that counters are only affected when there is some sort of optimization event, not on every query. (reference: http://sqlserver-qa.net/blogs/perftune/archive/2007/05/11/get-statistics-on-query-plan-optimizer-execution.aspx Read More... Posted Monday, August 06, 2007 8:40 PM by drsql | 1 Comments Filed under: Dynamic Management Objects, SQL Server, T-SQL