Blogs Louis Davidson in Blogs PASS Summit Wrap-up and 2019 PASS Resolutions Most years, by the time the PASS Summit has finished, I have at least written the basics of my wrap-up... 26 November 2018 11 min read
Blogs Phil Factor in Blogs How to validate JSON Data before you import it into a database. If you are, as you should be, checking JSON data in a whole lot of files before you import them... 16 November 2018 4 min read
Blogs Phil Factor in Blogs Getting Excel Data as JSON: Rainfall and Sheep-Counting You might think that it is easy to get JSON data from a spreadsheet, and there are plenty of utilities... 14 November 2018 9 min read
Blogs Phil Factor in Blogs Setting up a simple Rest interface with SQL Server We’re going to set up a web service for a SQL Server database using node js on a windows server.... 08 November 2018 9 min read
Blogs Louis Davidson in Blogs PASS Summit Resolutions 2017 Followup The summit is my favorite time of year, but this is literally my least favorite post of every year (and... 03 November 2018 6 min read
Blogs Louis Davidson in Blogs Calculating a Security Principal’s Complete Effective Rights In my blog Calculating a Security Principal’s Effective Rights. I built a view, named Utilty.EffectiveSecurity that you could query to... 09 October 2018 8 min read
Blogs Louis Davidson in Blogs Speaking at SQL Saturday Memphis on October 6 There are several SQL Saturday events I have attended every event that has existed. Louisville, Nashville, Chattanooga (didn’t speak one... 01 October 2018 3 min read
Blogs Louis Davidson in Blogs Calculating a Security Principal’s Effective Rights Security. Oh that most painful of topics. I discussed it a few months earlier when I discussed the need to... 26 September 2018 9 min read
Blogs Louis Davidson in Blogs Using WITH in an IF Condition I am in the middle of working on my DB Design conference that occurs in a bit over a week... 05 September 2018 7 min read
Blogs Louis Davidson in Blogs Teaching a Database Design and Implementation Class in Orlando 9-13 Thanks to Andy Warren (@sqlandy), on Thursday, September 13, I will be in Orlando, FL teaching an all-day seminar on... 15 August 2018 3 min read
Blogs Phil Factor in Blogs Spoofing Data Convincingly: Doing the Shuffle and Zip Having spent a lot of my working life trying to preserve the integrity of data, there was a certain intriguing... 13 August 2018 6 min read
Blogs Phil Factor in Blogs Spoofing Data Convincingly: Credit Cards I haven’t seen a SQL Server table with real unencrypted credit card numbers for several years, and I don’t know... 08 August 2018 8 min read
Blogs Louis Davidson in Blogs Finding duplicated data in a case insensitive column The other day, I had a problem with some data that I never dreamed I would ever see. In a... 08 August 2018 4 min read
Blogs Damon Armstrong in Blogs WPF Menu Displays to the Left of the Window I remember the first time I used WPF. It was a while ago. So long ago, if I am remembering... 08 August 2018 3 min read
Blogs Louis Davidson in Blogs Speaking on Database Design at SQL Saturday Indianapolis on 8/11 This weekend, I will be taking the short 7.5 hour drive up to Indianapolis, IN for my second SQL Saturday... 07 August 2018 2 min read
Blogs Louis Davidson in Blogs A performance issue with self-referencing tables I have a great interest in hierarchy solutions, as I plan to write a book on implementing hierarchies in SQL... 27 July 2018 4 min read
Blogs Phil Factor in Blogs Spoofing Data Convincingly: Masking Continuous Variables. In any real numeric data from a database , you are only rarely going to see any sort of normal... 18 July 2018 8 min read
Blogs Phil Factor in Blogs Spoofing Data Convincingly: Altering Table Data When you are developing an existing database, or demonstrating it, you nowadays need pseudonymised data, or even better, completely anonymized... 17 July 2018 9 min read
Blogs Louis Davidson in Blogs Speaking on Row Level Security at SQL Saturday Louisville 7/21 Coming up this weekend, I will be at my 10th SQL Saturday 729 in Louisville, KY. My topic will be... 16 July 2018 2 min read
Blogs Kathi Kellenberger in Blogs The Top Five Things That DBAs Need to Monitor Being a database administrator is much more than knowing how to install SQL Server and set up a database. One... 14 July 2018 3 min read
