Marcella McKeown in Editorials Insights from Redgate’s PASS Senior Program Manager In today’s editorial, guest writer Marcella McKeown shares some insights from her tenure from working on the program of PASS... 27 July 2024 5 min read
Koen Verbeeck in BI How to Stream Data from Azure Event Hubs into a Fabric Eventhouse At Microsoft Build 2024, Real-Time Intelligence was announced with the Real-Time hub as its centralized location for all data-in-motion. This... 26 July 2024 9 min read
Ben Johnston in Blogs Auditing SQL Server – Part 3 – SQL Server Configuration Audit This is the continuation of my series on auditing SQL Server. In the first part, I discussed basic server discovery... 25 July 2024 21 min read
Blogs Dennes Torres in Blogs AI Studio and The New AI Features When Microsoft announced the new AI Studio, it was easy to mistake it by any of the other studios available.... 25 July 2024 3 min read
Aaron Bertrand in T-SQL Programming Index cleanup : Harder than it looks I’m not the first person to write about cleaning up unused or redundant indexes. You can read many articles about... 22 July 2024 7 min read
Goodness Woke in Web An Introduction to Frappe Framework: Features and Benefits Frappe is a full-stack, battery-included web framework with MariaDB as the database, written in Python and JavaScript. Frappe is a... 19 July 2024 16 min read
Dennes Torres in Blogs Microsoft Fabric: Moving Dataflows Gen 2 to different workspaces Dataflows Gen 2 are not supported by source control and deployment pipelines yet. When we need to promote a dataflow... 17 July 2024 2 min read
Ben Johnston in Blogs Auditing SQL Server – Part 2 – Hardware Audit This is the second part of my series on auditing SQL Server. In the first part, I discussed basic server... 17 July 2024 13 min read
Louis Davidson in Opinion T-SQL Tuesday #176 Roundup of advice There was a lot of great advice, and I really wonder how much of this I would have listened to... 16 July 2024 6 min read
Boris Novikov in PostgreSQL Making Temporal Databases Work. Part 2: Computing Aggregates Across Temporal Versions The temporal database is a database that can keep information on time when the facts represented in the database were,... 16 July 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
Robert Sheldon in MongoDB Working with Documents in the MongoDB Compass GUI Throughout this series, I’ve discussed various ways to work with the documents in a MongoDB collection. If you’ve been following... 10 July 2024 23 min read
Dennes Torres in Blogs Microsoft Fabric: New Features you should not miss Microsoft Build was full of new features announcements and the fact it was so close to the Fabric May Updates... 10 July 2024 2 min read
Matt Hilbert in News Hot off the press Every day an avalanche of news hits us from all directions in all kinds of media. So what are the... 09 July 2024 5 min read
Aaron Bertrand in Database Administration It’s a recovery strategy, not a backup strategy I’ve talked about it before; you shouldn’t have a backup strategy, you should have a recovery strategy. I can’t possibly... 08 July 2024 12 min read
Bravin Wasike in Containers and Virtualization Docker Logging Guide Part 2: Advanced Concepts & Best Practices Welcome to part 2 of our Docker Logging Guide series. In this article, we will cover Docker logging in detail.... 05 July 2024 20 min read
Dennes Torres in Blogs Real-Time Intelligence: More than a name change When everyone starts to announce Real-Time Intelligence in Microsoft Fabric as something new, I need to double check what’s happening:... 03 July 2024 5 min read
Fabriano Richard in BI Microsoft Fabric, the Land of Wizards and Trolls In my previous article (What is Microsoft Fabric All About) I explained what Microsoft Fabric is, how it came about... 03 July 2024 9 min read
Louis Davidson in Blogs T-SQL Tuesday #176: One piece of advice you wish Past You had After so many years, here in July 2024, I am finally hosting T-SQL Tuesday. The challenge One of the things... 02 July 2024 3 min read