|
|
|
|
Browse by Tags
All Tags » Writing (RSS)
-
The pain of parting is nothing to the joy of meeting again - Charles Dickens It amazes me, but I have blogged here for over 11 years. My first post was about some new functionality in SQL Server 2005, Service pack 2. It was cross posted to drsql.spaces.live.com, Read More...
|
-
Finally, I can say I am done with a couple of books I had been working on, pretty much simultanously at times the past few months: Exam Ref 70-762 Developing SQL Databases ( https://www.micro softpressstore.com/store/exam-ref-70-762-developing-sql-databases-9781509304943 Read More...
|
-
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 Read More...
|
-
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, Read More...
|
-
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 Read More...
|
-
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 Read More...
|
-
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 Read More...
|
-
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, Read More...
|
-
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, Read More...
|
-
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 Read More...
|
-
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. Read More...
|
-
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 Read More...
|
-
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 Read More...
|
-
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 Read More...
|
-
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 Read More...
|
|
|
|
|
|