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
Blogs Louis Davidson in Blogs Generating Repeatable Sets Of Test Rows In order to test graph structures, I needed a large set of random data. In some ways, this data will... 30 September 2022 11 min read
Blogs Louis Davidson in Blogs T-SQL Tuesday #154 – SQL Server 2022, IS DISTINCT FROM Despite my recent job change from full time T-SQL code jockey/architect to website editor for Simple-Talk, I will always be... 13 September 2022 5 min read
