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 » writing   (RSS)
Showing page 1 of 6 (55 total posts)
  • 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
  • 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
  • Post PASS Summit Resolutions

    Many years I have tried early in the year to list a set of “New Year’s Resolutions” but one thing I have noted every year is it isn’t New Year’s Day that is the defining part of my year, but rather it is the PASS Summit that defines my year. Usually, by the time the end of October rolls around, I am pretty spent. The summer has ended, and all of ...
    Posted to Louis Davidson (Weblog) by drsql on November 9, 2015
  • Thank *you* for my SQL Server MVP Award…

    Today, I was awarded (at least) one more time with the Microsoft MVP Award. This makes 12 years, and with this, my 11th renewal, I have yet to feel like it is something I can take for granted (you don’t want to be around me the last week of September!). It has been a great time so far, and I have no idea how many years I will be back (admittedly, ...
    Posted to Louis Davidson (Weblog) by drsql on October 1, 2015
  • Upcoming Speaking Engagements in Indianapolis and Louisville

    Mercy, July is flying past at breakneck pace isn't it? The best part of July passing into the history books is that August has me speaking at two SQL Saturday's, one of them being a first time for me. On August 8 I will travel up to Indianapolis for SQL Saturday #402, a city I have been to a few times previously but not for a SQL Saturday. My ...
    Posted to Louis Davidson (Weblog) by drsql on July 18, 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
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement