THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |


You searched for the word(s):
Showing page 1 of 35 (346 total posts) < 1 second(s)
  • 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!&nbsp; I again have not blogged so much that I don't show up in the list on, 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
  • Just over a week until SQL Saturday Atlanta

    I am looking forward to being both a speaker and an attendee at this year's SQL Saturday in Atlanta (it is number 521 wow). Don't know what SQL Saturday is? (I doubt that if you are reading this blog, but if so, click here quickly my friend). My topic this year is concurrency: Let Me Finish... Isolating Write Operations OLTP databases can be ...
    Posted to Louis Davidson (Weblog) by drsql on May 11, 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
  • re: sys.dm_db_index_usage_stats

    Sorry Vinith, was on a trip when your question came through... You can't really, other than capturing the values every so often (daily, hourly), and subtracting values from one capture to the next
    Posted to Louis Davidson (Weblog) by drsql on April 23, 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&nbsp;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
  • Presenting on Concurrency Three Times This Month…Though Not Concurrently

    Tomorrow night, March 15, I will be at the Hampton Roads SQL Server User Groups March meeting, then at SQL Saturday Richmond on Saturday the 19th, then finally back at home on the 25th for my home user group in Nashville (which I havent seen much of this year) to present a presentation that I am pretty fond of after having done it once before in ...
    Posted to Louis Davidson (Weblog) by drsql on March 15, 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
1 2 3 4 5 Next > ... Last »
Privacy Statement