Other Lukas Vileikis in Other 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
Other Lukas Vileikis in Other 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
Other Lukas Vileikis in Other 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
Other Lukas Vileikis in Other 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
Other Dennes Torres in Other 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
Other Lukas Vileikis in Other 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
Other Lukas Vileikis in Other 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
Other Louis Davidson in Other 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
Other Tony Davis in Other 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
Other Louis Davidson in Other 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
Other Louis Davidson in Other 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
Other Dennes Torres in Other Synapse Analytics: When you should use (or not use) Synapse Synapse is a great data lake house tool. This means in a single tool we have resources to manage a... 05 September 2022 5 min read
Editorials Louis Davidson in Editorials Starting my dream job… “ A new adventure, there in your eyes. It’s just beginning, Feel your heart beat faster. Reach out and find... 01 September 2022 3 min read
Other Louis Davidson in Other Into the unknown, sort of Over half of my life ago, I was looking for a job. I had written a bunch of triggers and... 31 August 2022 5 min read
Other Dennes Torres in Other .NET App Services: Containers or not containers, that’s the question The app services in the title can be function apps, web apps or more. We can deploy the app services... 30 August 2022 5 min read
Other Dennes Torres in Other Creating Azure Policy to setup Virtual Machine Auto-Shutdown The Auto-Shutdown policy is another important policy to ensure our virtual machines don’t expend more than what we planned for... 25 July 2022 3 min read
Other Dennes Torres in Other What’s new in T-SQL in SQL Server 2022 There are many new features in SQL Server 2022. In relation to T-SQL querying, there are a few as well... 04 July 2022 8 min read
Other Ben Brown in Other Boost productivity with ‘Solution Summary’ cards Solution Summary cards are the name I have given to simple 1-page documents we provide to developers to get up-to-speed... 02 July 2022 3 min read
Other Phil Factor in Other Searching through a database via SQL Imagine that while developing or testing a SQL Server database, you get an error message mentioning a database object, and... 29 June 2022 13 min read
