Other Ben Brown in Other Boost productivity with ‘Solution Summary’ cards Solution Summary cards are the name I have given to simple 1-page documents we provide to developers to get up-to-speed... 02 July 2022 3 min read
Other Louis Davidson in Other Starting My New Book – Step 1 – Prepare computer(s) The main gist of this article is that if you are starting any project where you want to both teach... 17 March 2022 5 min read
Other Dennes Torres in Other Dynamic Data Mask is now useful and no one noticed it Dynamic data mask is a very interesting security feature allowing us to mask critical fields such as e-mail, phone number,... 22 November 2021 3 min read
Other Louis Davidson in Other Using Filetable to Find Duplicate Image Files with Different Names In my article “Filetables, Great For Business, Great For Hobbyist”, I implemented the basis of a hobby database I use... 03 August 2021 5 min read
Other Louis Davidson in Other What Counts For a DBA – Patients It’s been a while since I last wrote a new blog, and it has been a very long time since... 30 July 2021 4 min read
Other Annette Allen in Other What a year for the Technical Community The last year hasn’t been easy and most of us, especially in the IT world, have learnt to exist inside... 17 March 2021 4 min read
Other Louis Davidson in Other The Issue\Purpose of Multiple Edge Constraint/Conditions Edge constraints were added in SQL Server 2019 to make the node to edge relationship stricter/enforced, and more like typical... 15 March 2021 4 min read
Other Louis Davidson in Other Ways to get and deal with invalid node identifiers in SQL Server Edge references One of the weirder things about graph tables in SQL Server is the mysterious backend implementation. The values you see... 12 March 2021 6 min read
Other Louis Davidson in Other Function (and SQL Prompt Snippet) To Get Next Date By Day Name/Offset As I have been building my Twitter management software, I have been doing a lot more ad-hoc, repetitive coding using... 18 February 2021 3 min read
Other Louis Davidson in Other Ignore the technology for a moment, let’s talk about the problem Twelve and a half years ago I wrote my largest hit count article of my writing career Ten Common Database... 26 October 2020 9 min read
Other Dennes Torres in Other Deploy Data Factory from GIT to Azure with ARM Template You may have noticed the export feature on Azure resource groups don’t like too much the Data Factory. We can’t... 12 October 2020 2 min read
Other Phil Factor in Other Converting Manually-Entered Strings to Dates Before computers, the British, US and Canadians all entered dates with the full month-name first, followed by the day number,... 17 September 2020 7 min read
Other Louis Davidson in Other Trigger Validations and Isolation Levels Writing data integrity code in TRIGGER objects is generally is pretty simple. Typically you write a query to see “is... 18 August 2020 9 min read
BI Sanil Mhatre in BI Sentiment Analysis and Text Mining with R: Word Clouds, NRC Lexicon, and Scores Text mining and sentiment analysis with R: install the tm package, clean text data, build term-document matrices, generate word clouds,... 13 May 2020 20 min read
Other Annette Allen in Other Isn’t the technical Community great?!! With everything that’s been going on in the world recently and all events being cancelled or postponed you might mistakenly... 07 May 2020 4 min read
Other Phil Factor in Other Tackling Imperial and US Customary Measurements in Databases The old measurements of length, area, volume and weight in the UK and the States refuse to die. They are... 06 May 2020 10 min read
Other Louis Davidson in Other SQL Agent Job Generator: Scheduling A Job In this last entry in the initial series of posts on building a SQL Agent Job Generator, I am going... 17 April 2020 10 min read
Other Dennes Torres in Other Identity column vs ETL Process Creating ETL process can pose so many challenges we will only fully discover them when really building the ETL. Before... 01 March 2020 6 min read
Other Louis Davidson in Other Mixing Relational and Graph DB Objects (Book and Session Prep) Graph structures are something that I have lightly covered in my Database Design book in the last few book editions... 27 February 2020 5 min read
