Ben Johnston in Blogs Writing an Efficient Query SQL is easy to start writing. The basic syntax to start returning data is very simple. This low threshold for... 19 October 2024 20 min read
Simple Talk Editor Simple Talk has a fresh new look and feel Simple Talk has always revolved around Redgate’s value of keeping things ‘ingeniously simple’. This is something which was reflected in... 11 July 2024 3 min read
Simple Talk Editor Introducing Simple Talks: The Go-To Podcast for Database Professionals If you’re a database professional, IT expert, or tech enthusiast, we’ve got something exciting for you—Simple Talks, our very own... 11 July 2024 4 min read
Simple Talk Editor Why We Removed Star Ratings from Simple Talk Star ratings have always been an interesting thing on the Internet. They can be a way to encourage interaction with... 18 May 2024 3 min read
Blogs Dennes Torres in Blogs 4 Reasons to use KustoDB for Real-Time When implementing real-time ingestion, we usually implement an architecture called lambda. Using the lambda architecture, KustoDB in Microsoft Fabric is... 23 April 2024 2 min read
Dennes Torres Model Optimization: Available In MDX Property Power BI Semantic Models have a property called Available In MDX. Each field in the model has this property and... 28 February 2024 3 min read
Blogs Dennes Torres in Blogs Synapse Analytics: When you should use (or not use) Synapse Synapse is a great data lake house tool. This means in a single tool we have resources to manage a... 05 September 2022 5 min read
Blogs Ben Brown in Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Dennes Torres in Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Annette Allen in Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Dennes Torres in Blogs 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
Blogs Phil Factor in Blogs 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
Blogs Louis Davidson in Blogs 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