A Real-world Implementation of Database DevOps: People, Processes, Tools
The post A Real-world Implementation of Database DevOps: People, Processes, Tools appeared first on SQLServerCentral.
SQL RAISERROR to Better Handle Errors
The post SQL RAISERROR to Better Handle Errors appeared first on SQLServerCentral.
Getting started with ROUND() and Its Use Cases
In this article, I will explore one of the SQL Server mathematical functions, ROUND. The T-SQL ROUND() function rounds off a numeric value to a specified length or precision. The syntax to use this function is given below: ROUND ( numeric_value , lengt …
Subqueries in MySQL
Part of Robert Sheldon’s continuing series on Learning MySQL. The series so far: Getting started with MySQL Working with MySQL tables Working with MySQL views Working with MySQL stored procedures Working with MySQL stored functions Introducing the MySQ …
Mentoring 2023 – want some help from me?
[Edit 12/16/2022:the deadline for submissions is now closed.] In 2015 I mentored 54 people for six months. In 2020 I mentored 37 people on-and-off for over a year. In 2023 I’ll be mentoring ?… Why do I do it? I get nothing from this; I just …
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 …