THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Design   (RSS)
Showing page 1 of 2 (16 total posts)
  • How the rowversion datatype works when adding and deleting columns

    For years, I had thought (and was probably taught in SQL.AlongTimeAgoInAPlaceFarFarAway) that the timestamp column (well before rowversion was a thing,) was not guaranteed to be an ever increasing value. But this is not the case. In BOL (https://docs.microsoft.com/en-us/sql/t-sql/data-types/rowversion-transact-sql)  it ...
    Posted to Louis Davidson (Weblog) by drsql on September 26, 2017
  • Dynamic Data Masking - Part 2–Security and Incorporating into Code

    This is part 2 of my Dynamic Data Masking blogs for my upcoming book project. Part 1 is here: Dynamic Data Masking - Part 1 - The Mechanism. Previously, in my first blog on Dynamic Data Masking - Part 1 - The Mechanisms, we had created the following table (I include this so you can see the DDL of creating the table with the MASKED WITH clause on ...
    Posted to Louis Davidson (Weblog) by drsql on February 8, 2016
  • SQL Saturday 489 Tampa-“How to Design a Relational Database” Precon

    On February 26, I will be doing my "How to Design a Relational Database" pre-conference session in Tampa, FL.  You can see the abstract here if you are interested, and you can sign up there too, naturally. Currently priced at 158.19 it is a bargain and I totally promise it will be around 8 hours of talking about and designing ...
    Posted to Louis Davidson (Weblog) by drsql on February 4, 2016
  • Heading to Orlando for SQL Saturday again this year

    Last year, I attended SQL Saturday Orlando again after missing a few years (I did my first database design precon there a few years back). I love the way they run their event, and as speakers, we did some fun stuff like being the ones that served lunch to the attendees. This year, I wasn’t sure if I had a chance to go, because I had scheduled a ...
    Posted to Louis Davidson (Weblog) by drsql on September 26, 2015
  • Speaking this week at #sqlsatChattanooga and for the PASS Performance Virtual Chapter

    The topic for both sessions will be: How In-Memory Database Objects Affect Database Design and the following is the abstract: With SQL Server 2014, Microsoft has added a major new feature to help optimize OLTP database implementations by persisting your data primarily in RAM. Of course it isn't that simple, internally everything that uses this ...
    Posted to Louis Davidson (Weblog) by drsql on June 21, 2015
  • Classic Music, Attractions, and Presentations: Presenting on Database Design at SQL Saturday Atlanta 2015

    This next two weeks are going to be awesome. May 11, I get to see the Who for probably the last time ever. Saturday I am speaking on Database Design at SQL Saturday in Atlanta, then heading to Disney World.  It rarely gets even close to this good for a two week span, and SQL Saturday is a big part of that. I love going to SQL ...
    Posted to Louis Davidson (Weblog) by drsql on May 8, 2015
  • 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 and have credit card in hand, click here and register before the price ...
    Posted to Louis Davidson (Weblog) by drsql on September 9, 2013
  • Crazy Week Next Week–SQLRally and SQL Saturday Birmingham

    A lot of my time lately has been spent getting ready for next week and I hope to see you there.  First up SQL Rally. On Wednesday, I will be doing a pre-con session on Database Design. I have already blogged about it here, and I am definitely excited about it.  There are still seats available, and I will be giving away a few goodies ...
    Posted to Louis Davidson (Weblog) by drsql on May 1, 2012
  • Chapter 8–Patterns and Anti-Patterns

    In this last kind of “creative” chapter, I will look at some of the ways you implement common problems in your relational database, and some of the ways you probably shouldn’t. The “should” sections will deal with: Uniqueness – Beyond the simple uniqueness we have covered in the first chapters of the book, looking at some very realistic ...
    Posted to Louis Davidson (Weblog) by drsql on July 10, 2011
  • 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 2 pages or less, describe the process of normalization and help you to know when you have ...
    Posted to Louis Davidson (Weblog) by drsql on May 29, 2011
1 2 Next >
Privacy Statement