Dealing with the Bits of a Binary Value in SQL Server
How you used to do it For example, say you want to find all the read-write database using SQL Server 2022 system objects (I think this started back in 2005, in fact). You can write: SELECT name FROM sys.databases WHERE is_read_only = 0 AND name IN (‘ma …
Backing Up MySQL Part 7: MySQL Enterprise Backup
MySQL Enterprise Backup is a known tool for everyone inside of the world of MySQL, no matter if people dealing with the tool are enterprise (business) minded or not. The tool can be considered the flagship of MySQL’s enterprise-level offerings: i …
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.