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 34 (340 total posts) < 1 second(s)
  • 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 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
  • Target Audience - SQL Saturday 489 Tampa - “How to Design a Relational Database” Precon

    A few days back, I blogged an&#160; 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
  • 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
  • SQL Saturday 489 Tampa-“How to Design a Relational Database” Precon

    On February 26, I will be doing my &quot;How to Design a Relational Database&quot; pre-conference session in Tampa, FL.&#160; 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
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement