30 March 2023
30 March 2023

A Beginners Guide to MySQL Replication Part 1

MySQL Replication is a process where data from one MySQL database known as the source (formerly called “master”) is copied over to one or more other databases called replicas (formerly called “slaves”). Think of this like having a backup buddy that is always in sync and up to date, giving you peace of mind. It’s … Read more
06 March 2023
06 March 2023

Synapse Serverless and Dedicated Pool: The differences no one told you about

0
2
The basic differences between Synapse Serverless and the Dedicated pool are obvious: While the serverless doesn’t store data, only access data from storage accounts and scale the MPP environment automatically, the dedicate SQL Pool keeps a static number of servers according to the service level we choose and a constant number of distributions – always … Read more
09 February 2023
09 February 2023

How to ask for programming help

0
3
Over the past 25 years, I have answered a lot of programming questions in online forums, from co-workers, and from friends. It has been a while since I had been around forums, but I recently decided it was time to get back to what started me in the SQL community: answering questions. Not only is … Read more
06 February 2023
06 February 2023

3 Key Areas to Drive Digital Transformation

0
2
Originally published on 21 August 2020 as “Understanding digital transformation & how it transcends to driving organizational growth“, edited by Louis Davidson including updated references. IDC report forecasts that global spending on enterprise applications will rise from $279.6 billion in 2022 to 385.2 billion in 2025. Nearly all of this will be in public cloud … Read more
23 January 2023
23 January 2023

Azure Functions and Managed Identity: More Secrets

0
3
I wrote about Managed Identity Secrets a few weeks ago, but since that article was published I made new interesting discoveries to add more to these secrets. The combination of possibilities is considerable, and I faced two new situations I hadn’t faced before. Let’s discover the new secrets.   Storage Accounts and Triggers The storage … Read more
19 December 2022
19 December 2022

SQL Server 2022: How Auto-Drop Statistics Work

0
7
Auto-Create statistics is a well-known feature critical for the database performance. When one statistic is auto created, changing the table structure is not blocked by the presence of the statistic. An auto-created statistics is also dropped automatically when a schema change happens. On the other hand, if the statistic is created by the user, any … Read more
12 December 2022
12 December 2022

What’s new on Power BI DataMarts UI

0
1
I wrote an article about Power BI Datamarts which was released together the feature, on the exact moment it was being announced in a conference. Of course, this feature has being evolved since that time. I would emphasize the performance. The general UI performance seems way better than when it was first released. Let’s talk … Read more
21 November 2022
21 November 2022

SQL Server 2022: Azure AD Authentication

0
4
SQL Server 2022 is finally GA and one of the features I was most expecting is finally available. It’s the allows Azure AD Authentication. Azure AD users can access SQL Server directly, without a second user account. SQL Server on premises requires Azure ARC to be integrated to Azure. Azure VMs, on the other hand, … Read more