Backing Up MySQL Part 6: Physical vs. Logical Backups
The Black Friday Sale Has Been Extended!
I got a *lot* of last minute emails this year from companies whose purchasing processes were moving slowly. So to help y’all get across the finish line, you have until the end of this month to get your purchases in. We’re still not doing in …
Basic Checks on a New AWS RDS SQL Server
Introduction In this article, we shall imagine that we were just recruited by a new company and handed over a new Amazon RDS SQL Server instance. Our first job would be to understand the instance and key databases, tables, and other server-level and da …
Webinar | Test Data Management
The post Webinar | Test Data Management appeared first on SQLServerCentral.
Slow “Having” Query? Try Pre-Filtering.
I was helping a client with a query, and I’m going to rework the example to use the Stack Overflow database for easier storytelling. Say we need to: Find all the locations where users have logged in since a certain date, then Return the total cou …
A week in Seattle in 8 Slides at the PASS Data community Summit 2022
Being from home for over a week, having a good travel companion is crucial. And with rising data star Peter Kruis I had the best. Not only did we walk all the surroundings of Seattle, from Pike Market to Washington University. We took the bus to visit …
Being Agile – A Success Story
Introduction What is Agile? The definition of Agile varies depending on the perspective of a person. For example, some may say Agile is a mindset, a framework that allows rapid change, or that Agile is a methodology that enables incremental changes to …
SQL Server at Scale – Using an Archive Table – Part 2
The post SQL Server at Scale – Using an Archive Table – Part 2 appeared first on SQLServerCentral.
The Curious Case of… community
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more frequent. It covers something interesting one of us encountered when working with a client, doing some t …
Backing Up MySQL Part 5: Backing Up Big Data
According to research made by Statista in 2022, the amount of data that is being worked with globally is expected to reach more than 180 zettabytes. Part of that is because more and more data is being introduced to the online world – but another …
[Video] Office Hours: Black Friday Edition
My Black Friday sale is in its last days, so most of my time at the moment is spent keeping an eye on the site and answering customer questions. I’m happy to say it’s our best year so far, too! Y’all really like the new access-for-lif …
Express.js or Next.js for your Backend Project
Backend projects create projects to execute code on a centralized server and then communicate results with a client. These kinds of projects are executed efficiently with Express.js, and the number of web developers who use this framework is increasing …
Is Azure SQL Database a Good Choice for your Database Applications?
The post Is Azure SQL Database a Good Choice for your Database Applications? appeared first on SQLServerCentral.
Why bother automating?
The post Why bother automating? appeared first on SQLServerCentral.
Contest: Guess the Next SQL Server Release Date
When will Microsoft officially release SQL Server 2023 (or 2024, or whatever it’ll be) for download? The dust is just barely starting to settle on the 2022 box, so it’s time to guess the next one. Leave one – and only one – comment here in …