Blogs Dennes Torres in Blogs 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
Blogs Aisha Bukar in Blogs 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
Blogs Aisha Bukar in Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Dennes Torres in Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Mithun Gaur in Blogs 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
Blogs Dennes Torres in Blogs 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
Blogs Dennes Torres in Blogs 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
Blogs Dennes Torres in Blogs 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
Blogs Lukas Vileikis in Blogs 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
Blogs Louis Davidson in Blogs 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
Blogs Lukas Vileikis in Blogs Backing Up MySQL Part 7: MySQL Enterprise Backup In this blog, we walk you through the primary way to take enterprise-level backups in MySQL: MySQL Enterprise Backup. Have... 03 December 2022 7 min read
Blogs Lukas Vileikis in Blogs Backing Up MySQL Part 6: Physical vs. Logical Backups In this blog, we compare two of the most popular types of backups in MySQL - backups of a physical... 01 December 2022 9 min read
Blogs Lukas Vileikis in Blogs Backing Up MySQL Part 5: Backing Up Big Data This blog will guide you through backing up big data sets in MySQL with ease. Have a read!… 26 November 2022 14 min read
Blogs Lukas Vileikis in Blogs Backing up MySQL Part 4: mydumper In this blog, we walk you through one of the most prominent MySQL logical backup solutions - a CLI-based tool... 22 November 2022 4 min read
Blogs Dennes Torres in Blogs SQL Server 2022: Azure AD Authentication SQL Server 2022 is finally GA and one of the features I was most expecting is finally available. It’s the... 21 November 2022 3 min read
Blogs Lukas Vileikis in Blogs Backing up MySQL Part 3: mysqlpump In this blog, we walk you through the brother of mysqldump - mysqlpump - and tell you everything about it.... 19 November 2022 6 min read
