Browse by Tags

• AT TIME ZONE
• Best Practices
• Bugs
• Catalog Objects
• Concurrency
• Connect
• Constraints
• Curious
• Database Design
• Denali
• Design
• Development
• Dynamic Management Objects
• hierarchies
• In-Memory OLTP
• MVP
• PASS
• Performance
• PreCon
• Row Level Security
• rowversion
• Security
• sequence
• Speaking
• SQL Saturday
• SQL Server
• sql server 2016
• SQL Techniques
• SQL Tools
• SQLPASS
• SSMS
• System Functions
• Temporal Data
• Tips
• T-SQL Tuesday
• User's Group
• Utility
• Why We Write
• Writing

• Snapshot Isolation Level and Concurrent Modification Collisions - On Disk and In Memory OLTP

  This is part 1 of my In Memory OLTP blogs for my upcoming book project . In this blog I want to take a (reasonably) quick look at how concurrent modifications are handled using SNAPSHOT isolation level. There are two different flavors of SNAPSHOT Isolation Read More... Posted Thursday, August 13, 2015 6:28 PM by drsql | 0 Comments Filed under: SQL Server, T-SQL, Concurrency, In-Memory OLTP

• Utility to reset a sequence next value based on a table/sequence relationship

  So I was building a database the other day, and I used sequence objects for all of the defaults because it was FAR easier to load data into the table not needing to set identity_insert on and off over and over and over. Worked great. Went through all Read More... Posted Wednesday, July 22, 2015 8:42 PM by drsql | 0 Comments Filed under: T-SQL, Constraints, sequence

• Temporal Tables – Part 2 – Changing history

  After my post yesterday, I had planned to take a break for Independence Day holiday, but a commenter asked a question that piqued my interest. How might you edit history? Well, the answer is simple, but the process isn’t exactly simple. Basically, you Read More... Posted Tuesday, June 30, 2015 7:07 PM by drsql | 5 Comments Filed under: T-SQL, Database Design, Writing, Temporal Data

• Temporal Tables – Part 1 - Simple Single Table Example

  In my first entry in my series of posts on DB Design Book Topics , I want to start with a pretty interesting topic, Temporal Tables. It is a very cool new feature that takes something that used to be very painful (capturing history of changes to a table, Read More... Posted Monday, June 29, 2015 9:26 PM by drsql | 5 Comments Filed under: T-SQL, Database Design, Writing, Temporal Data

• Time to Start Plotting My 2016 Database Design Book

  Note: A new version has been talked about for years, but it is not a guarantee. This post is my way of introducing the new features of SQL Server, and follow on posts will be code filled example of how the features will work. I am making no promises at Read More... Posted Tuesday, June 16, 2015 7:54 PM by drsql | 4 Comments Filed under: T-SQL, Database Design, Writing, hierarchies

• Off to Richmond for SQL Saturday

  I got the email prodding speakers to blog about our upcoming sessions, so I got myself up and started to write this blog. It has been such a long time since I have done much side SQL work (other than doing quite a bit of tech editing, along with doing Read More... Posted Friday, March 13, 2015 6:12 PM by drsql | 0 Comments Filed under: SQL Server, T-SQL, Database Design, User's Group, Speaking, SQL Saturday

• Relational Database Design Pre-Con at PASS

  Well, here we go again. I am making my final preparations again for my "How to Design a Relational Database" pre-conference seminar coming up at PASS. If you want to know what the "official" abstract is, you can find it here and if you are already convinced Read More... Posted Monday, September 9, 2013 8:21 PM by drsql | 1 Comments Filed under: T-SQL, Database Design, Design, SQLPASS, PreCon

• Why We Write #4 - An Interview With Doug Lane

  My next guest is Doug Lane , who has been blogging for the past few years on his website: http://www.douglane.net/ . Doug is also a speaker who has spoken at SQL Saturdays as well as the SQL PASS Summit , and as I write these interview questions was on Read More... Posted Tuesday, April 23, 2013 10:56 PM by drsql | 2 Comments Filed under: T-SQL, Writing, SQLPASS, Why We Write

• One more reason to to understand query plans, not directly performance related

  One of the things that separates a good programmer from a great one is a firm understanding about what is going on inside the computer. For some programming languages, it is very obvious what is going on inside the computer because you are working at Read More... Posted Tuesday, January 22, 2013 11:28 PM by drsql | 7 Comments Filed under: T-SQL, Development, Performance

• Utility Queries–Structure of Tables with Identity Column

  Edit: At the suggestion of a much knowledgable commenter who shall remain named Aaron, I changed from using schema_name() function to using sys.tables. When writing code that is expected to have reuse, it can be safer to use the tables rather than functions Read More... Posted Sunday, September 2, 2012 4:05 PM by drsql | 6 Comments Filed under: T-SQL, Development, SQL Tools, Utility

• Speaking at PASS 2012… Exciting and Scary… As usual…

  Edit: As I reread this, I felt I should clarify.. As usual refers mostly to the "Scary" part. I have a lot of stage fright that I have to work through. And it is always exciting to be picked. I have been selected this year at the PASS Summit 2012 to do Read More... Posted Saturday, June 23, 2012 7:03 PM by drsql | 1 Comments Filed under: T-SQL, PASS, Speaking, MVP, SQLPASS

• Utility Queries–Column Metadata

  Very often, I find myself wanting to query system metadata for columns. Some of the metadata is fairly easy to deal with, like if you want to find column names, just simply querying sys.columns is very straightforward. But if you want to query data types, Read More... Posted Sunday, April 22, 2012 11:57 PM by drsql | 0 Comments Filed under: T-SQL, Catalog Objects, Constraints, Utility

• Planning my Louisville SQL Saturday Presentation

  So it is Tuesday night, just a few days until my presentation entitled What Counts For A DBA and I am still not completely sure exactly what is going to go on. In fact, I don’t exactly plan to know what is going on until the presentation is over.  Read More... Posted Tuesday, October 25, 2011 10:47 PM by drsql | 0 Comments Filed under: T-SQL, Speaking

• Denali Enhancement–Duplicate Key Error Message

  When I was editing my chapter on implementing a database, I noticed a really nice improvement in the error message I had from the previous edition of the book. Instead of just telling me that there was a value in my modification statement that duplicated Read More... Posted Thursday, July 14, 2011 1:12 AM by drsql | 6 Comments Filed under: T-SQL, Constraints, Denali

• 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 6, 2009 10:38 PM by drsql | 1 Comments Filed under: T-SQL, SQL Techniques, Best Practices, Development, Tips