Other Dennes Torres in Other Graph Edge Constraints and a Crystal Ball When I read the list of new features in SQL Server 2019 I became very proud of my crystal ball... 08 December 2018 2 min read
Other Louis Davidson in Other I Have an Exclusive Lock, My Row Is Safe, Right? Note: This is an update of a blog I posted in 2006 with a lot of additional information (I was... 06 December 2018 7 min read
Other Phil Factor in Other Producing Data and Schemas in JSON array-of-array format. JSON was initially designed for the informal transfer of data that has no schema. It has no concept of a... 05 December 2018 24 min read
Other Kathi Kellenberger in Other Three Books That Have Influenced My Career I’m a lifelong learner. One of the ways I love to learn is by reading books. While I was making... 03 December 2018 3 min read
Other Dennes Torres in Other New Technologies to Study One great result from PASS Summit, especially when we are close to a new SQL Server release, is to identify... 28 November 2018 7 min read
Other Louis Davidson in Other 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
Other Phil Factor in Other 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
Other Phil Factor in Other Excel to SQL Server via JSON: PowerShell Conversion and OPENJSON Import Walkthrough Import Excel spreadsheet data into SQL Server without ETL tooling - convert Excel to JSON using PowerShell (ImportExcel module), then... 14 November 2018 10 min read
Other Phil Factor in Other 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
Other Louis Davidson in Other 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
Other Louis Davidson in Other 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
Other Louis Davidson in Other 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
Other Louis Davidson in Other 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
Other Louis Davidson in Other 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
Other Louis Davidson in Other 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
Other Phil Factor in Other 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
Other Phil Factor in Other Generating Fake Credit Card Numbers in SQL Server with the Luhn Algorithm (for Test Data) Generate fake credit card numbers in SQL Server that pass Luhn checksum validation - useful for populating development and test... 08 August 2018 9 min read
Other Louis Davidson in Other 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
Other Damon Armstrong in Other 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
Other Louis Davidson in Other 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
