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 » Database Design   (RSS)
Showing page 1 of 10 (99 total posts)
  • Doing a book signing at the DataCore booth at Microsoft Ignite!

    If you are in the intersection of these two groups: Doesn't currently have a copy of my current database design book, or wants to give one to a friend who architects poor databases Will be attending the Microsoft Ignite Conference Then I have a great deal for you. The middle four days of the Microsoft's Ignite conference in Orlando, I ...
    Posted to Louis Davidson (Weblog) by drsql on September 19, 2017
  • SQL Saturday Chattanooga is THIS WEEK!

    My goodness how time does fly. It seems like just a few months ago I was going to my hometown SQL Saturday in Nashville, and now here I go again to my NEW hometown SQL Saturday in Chattanooga, TN. Much like the Nashville event, I didn't really do anything in terms of organization of the event, but I will be speaking at the event this year (last ...
    Posted to Louis Davidson (Weblog) by drsql on June 21, 2017
  • If a Tree Falls in the Forest, and No One is Around To Hear It…

    You no doubt have heard this old philosophical question that completes with, "Does it Make a Sound?" As nerds, we all know that the answer is that it certainly does make a sound. However, take the question to a more technical place, how much sound does it make, and what is the impact of that sound, is far more interesting, and far more ...
    Posted to Louis Davidson (Weblog) by drsql on January 9, 2017
  • Temporal Tables - Part 4 - Synchronizing changes across tables

    So way back in June of last year, when I started this series on Temporal Tables: Part 1 - Simple Single Table Example, Part 2 – Changing history; and even in Part 3 - Synchronizing Multiple Modifications; I only referenced one table. In this entry, I want to get down to what will actually be a common concern. I want my objects to be consistent, ...
    Posted to Louis Davidson (Weblog) by drsql on May 9, 2016
  • Row Level Security – Part 1–Simple Read operations

    This is part 1 of my Row Level Security blogs for my upcoming book project. Row Level Security is a very interesting feature. Unlike Dynamic Data Masking (link), which looks interesting on it's face, once you dig in the utilization of the feature looks to be limited by how granular you can make the security work. Row Level Security on the other ...
    Posted to Louis Davidson (Weblog) by drsql on February 15, 2016
  • Target Audience - SQL Saturday 489 Tampa - “How to Design a Relational Database” Precon

    A few days back, I blogged an  intro to my pre-con on How to Design a Relational Database. You can see that blog here and you can (must?) go see the abstract and register: here. But who exactly is the target audience? I think there are really four reasonable answers, one answer that I feel says it all: Beginner Data Architects If you want ...
    Posted to Louis Davidson (Weblog) by drsql on February 10, 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
  • Dynamic Data Masking - Part 1 - The Mechanism

    This is part 1 of my Dynamic Data Masking blogs for my upcoming book project. Part 2 is here. An interesting feature that is being added to SQL Server 2016 is Dynamic Data Masking. What it does is, allow you to show a user a column, but instead of showing them the actual data, it masks it from their view. Like if you have a table that has email ...
    Posted to Louis Davidson (Weblog) by drsql on February 1, 2016
  • Is It Ever Better to Not Name Constraints?

    This is part 1 of my Tips and Tricks blogs for my upcoming book project. For all of my professional writing career, I have been forced to be on the top of my formatting game when writing code. Uppercasing this, spacing this, aligning that, formatting code just right. In my personal life, I also try to format my code in a readable manner, though ...
    Posted to Louis Davidson (Weblog) by drsql on January 19, 2016
  • Dragged Kicking and Screaming into the Clouds

    When I first heard about the cloud I rolled my eyes. This will never take, it sounds very much like the mainframes we came to know and hate (my first database project was killing a mainframe that was costing our non-profit organization $15000 a month, which as a non-profit was simply horrible.) Even four years ago when I was writing "Pro SQL ...
    Posted to Louis Davidson (Weblog) by drsql on December 2, 2015
1 2 3 4 5 Next > ... Last »
Privacy Statement