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 7 (66 total posts)
  • Post PASS Summit Resolutions 2016

    So, I am finally back and lightly rested from the two big weeks of SQL learning this year (PASS Summit and MVP Summit) and like pretty much every year I am physically exhausted, feeling my age. So many sessions, so many miles put on my feet. But my brain recovers from the ordeal faster than my feet, and is like: "wow, I am going to need more ...
    Posted to Louis Davidson (Weblog) by drsql on November 17, 2016
  • After PASS Summit 2016 Recap (As seen by me!)

    In my last blog entry, I promised to blog about the PASS Summit each night when I got back to the room. This was a failure for two reasons. 1. I was always out at night and then exhausted. 2. I forgot the keyboard to my Surface Pro. I tweeted about it, and was picked on by the @surface twitter account: But I did tweet about the event rather ...
    Posted to Louis Davidson (Weblog) by drsql on November 2, 2016
  • Post PASS Summit 2016 Resolutions - Followup

    Last year I started a new tradition for myself that will last until I specifically retire from the SQL Server community, something that I practically promise isn't coming in next year's resolutions. As this is the end of the PASS year, with the Summit coming up next week, it is time to see how I did with regards to what I said I would do. I didn't ...
    Posted to Louis Davidson (Weblog) by drsql on October 20, 2016
  • Where have I been? Where will I be?

    SQL Saturday Orlando has been postponed. I won't be able to make it for the make up day, so that part of this blog has changed. Not the part about me loving the folks down there. They are still awesome!  I again have not blogged so much that I don't show up in the list on SQLBlog.com, but it is about time to start blogging again. Where ...
    Posted to Louis Davidson (Weblog) by drsql on October 3, 2016
  • Temporal Tables - Part 5 - Start and End Type Precision

    In this fifth (and maybe final until at least getting to the concurrency chapter prep) blog about temporal I wanted to briefly cover the precision of the ROW START and END times. You can use any of the datetime2 types for these values. The precision will let you choose how many changes would be seen by the user. Even with 6 digits of precision ...
    Posted to Louis Davidson (Weblog) by drsql on May 21, 2016
  • 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
  • Temporal Tables - Part 3 - Syncing Multiple Modifications

    Back last June, I started this series on temporal tables, and in my head, I had enough information to make an educated set of examples on how to use them. In the back of my mind though, I knew that I hadn't quite thought enough about the whole process, particularly when you have several rows (or as I will note in the next blog entry, tables) that ...
    Posted to Louis Davidson (Weblog) by drsql on May 2, 2016
  • Row Level Security-Part 3-A few more advanced scenarios

    In this final entry (for now!) in my series on Row Level Security (Part 1, Part 2) I am going to show a couple of slightly more complex scenarios. I will only scratch the surface of what you could do, but keep in mind that performance is really important to how you make use of Row Level Security. In a future blog, I will build a couple of ...
    Posted to Louis Davidson (Weblog) by drsql on April 6, 2016
  • Row Level Security–Part 2-Write Operations

    In the first entry in this series (to view, follow this link), I took a look at the how row level security worked with read operations. Now in this entry, I want to expand that to how you use it to limit what a user might write to, or delete from a table. To recap our current situation, we have three users: CREATE USER BigHat WITHOUT ...
    Posted to Louis Davidson (Weblog) by drsql on March 4, 2016
  • How Sure Are You of Your PASS Summit Abstract?

    You know who you are. You have a presentation idea that has been percolating since last October. You have asked friends and coworkers if it is a good idea. You may have presented it at 10 SQL Saturdays to thunderous appreciation. You may have even tried to submit last year but was turned down.  You have this abstract written and may have even ...
    Posted to Louis Davidson (Weblog) by drsql on February 16, 2016
1 2 3 4 5 Next > ... Last »
Privacy Statement