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 11 (109 total posts)
  • 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
  • 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 have to turn off system versioning, update history, and reapply system versioning. Not difficult, ...
    Posted to Louis Davidson (Weblog) by drsql on June 30, 2015
  • 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, allowing the user to see the data at a point in time), and makes it very easy. So if you have ...
    Posted to Louis Davidson (Weblog) by drsql on June 29, 2015
  • 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 this time, but when I can, I will. With the recent release of a CTP version of what is called ...
    Posted to Louis Davidson (Weblog) by drsql on June 16, 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
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement