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
Blogs Lukas Vileikis in Blogs Backing Up MySQL Part 2: Percona XtraBackup In this blog, we walk you through one of the flagship backup offerings by Percona - XtraBackup.… 16 November 2022 7 min read
Lukas Vileikis Optimizing MySQL: The Basics of Query Optimization In this blog, we will walk you through the basics of query optimization in MySQL. Have a read!… 10 November 2022 4 min read
Blogs Louis Davidson in Blogs The PASS Data Community Sessions I Am Most Excited For In this blog, Louis shares some of the sessions that he is most looking forward to during (and after) the... 29 October 2022 6 min read
Blogs Tony Davis in Blogs Aha Moments at PASS Data Community Summit As our team and countless others prepare to head off to the PASS Data Community Summit; We want to share... 25 October 2022 2 min read
