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