Other Dennes Torres in Other Power BI Connections Management Some time between January and now, a new preview feature was included in Power BI Portal. It’s a new Manage... 06 June 2023 2 min read
Other Pankaj Gupta in Other On-Premises vs Cloud In this blog, we will explore the disparities between on-premises and cloud infrastructures, highlighting their respective benefits and drawbacks. What... 02 June 2023 9 min read
Editorials Louis Davidson in Editorials The Importance of Tact The concept of tact is simple. Telling people truths, often harsh truths, without making it seem harsh. Hopefully, it is... 30 May 2023 3 min read
Other Dennes Torres in Other Microsoft Fabric: Enabling your Free Trial After the great announcement of Microsoft Fabric this week, it’s time to get a trial and start playing with this... 24 May 2023 3 min read
Dennes Torres in Other Microsoft Fabric: Data Warehouse Ingestion using T-SQL and more .In this blog I will illustrate how we can ingest data from a blob storage to a Microsoft Fabric Data... 24 May 2023 5 min read
Other Louis Davidson in Other Self Review: Practical Graph Structures in SQL Server and Azure SQL I just finished writing this book a few weeks ago, and as I read it, I thought “why not review... 23 May 2023 4 min read
Other Dennes Torres in Other List Azure Functions based on Configuration Values A company’s Azure environment can easily grow to a level that managing all the objects may become harder. The solution... 10 April 2023 4 min read
Other Aisha Bukar in Other A Beginners Guide To MySQL Replication Part 2: Configuring Source and Replica Servers In the first part of this series, we spoke about MySQL Replication, the different types, replication formats, benefits, and downsides,... 10 April 2023 8 min read
Other Aisha Bukar in Other A Beginners Guide to MySQL Replication Part 1: Introduction to MySQL Replication MySQL Replication is a process where data from one MySQL database known as the source (formerly called “master”) is copied... 30 March 2023 9 min read
Other Louis Davidson in Other The role of forethought for a computer engineer If you have ever played a game of chess against someone good, or perhaps against a computer, you know that... 28 March 2023 4 min read
Other Dennes Torres in Other Synapse Serverless and Dedicated Pool: The differences no one told you about The basic differences between Synapse Serverless and the Dedicated pool are obvious: While the serverless doesn’t store data, only access... 06 March 2023 5 min read
T-SQL Programming Louis Davidson in T-SQL Programming Optional Code in T-SQL Scripts using SQLCMD When you are writing T-SQL scripts to save away, for example one to create a new database, there are often... 06 March 2023 6 min read
Other Louis Davidson in Other How to ask for programming help Over the past 25 years, I have answered a lot of programming questions in online forums, from co-workers, and from... 09 February 2023 7 min read
Other Mithun Gaur in Other 3 Key Areas to Drive Digital Transformation Originally published on 21 August 2020 as “Understanding digital transformation & how it transcends to driving organizational growth“, edited by... 06 February 2023 7 min read
Other Dennes Torres in Other Azure Functions and Managed Identity: More Secrets I wrote about Managed Identity Secrets a few weeks ago, but since that article was published I made new interesting... 23 January 2023 3 min read
Dennes Torres Synapse Serverless: CETAS requires DFS to work CETAS is the acronym for Create External Table As Select. This allow us to export the result of a select... 16 January 2023 3 min read
Other Dennes Torres in Other SQL Server 2022: How Auto-Drop Statistics Work Auto-Create statistics is a well-known feature critical for the database performance. When one statistic is auto created, changing the table... 19 December 2022 2 min read
Other Dennes Torres in Other What’s new on Power BI DataMarts UI I wrote an article about Power BI Datamarts which was released together the feature, on the exact moment it was... 12 December 2022 3 min read
Other Lukas Vileikis in Other Backing up MySQL Part 8: Zmanda Backups for MySQL & Other Backup Tools In this blog, we're walking you through one of the most popular MySQL backup tools - ZRM - and a... 09 December 2022 5 min read
Other Louis Davidson in Other Dealing with the Bits of a Binary Value in SQL Server In this article, I want to talk about a topic that you may never need. The only time I have... 04 December 2022 5 min read
