THE SQL Server Blog Spot on the Web

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

Search

You searched for the word(s):
Showing page 1 of 35 (344 total posts) < 1 second(s)
  • 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
  • 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.&#160; You have this abstract written and may have even ...
    Posted to Louis Davidson (Weblog) by drsql on February 16, 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
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement