Data Activity Tracking Using SQL Triggers
Introduction In Today’s IT world, data is everything, so providing data access to many users introduces a potential threat of unknown risks. We must take proper measures to capture data changes and updates to avoid such risks. Therefore, the data manag …
Data Masking in Principle
The post Data Masking in Principle appeared first on SQLServerCentral.
Who’s Hiring in the Microsoft Data Platform Community? December 2022 Edition
Is your company hiring for a database position as of December 2022? Do you wanna work with the kinds of people who read this blog? Let’s set up some rapid networking here. If your company is hiring, leave a comment. The rules: Your comment must i …
The Good, The Bad, and Suboptimal of Sticking to What You Know
The Good In the late 1990s, one of the world’s most popular technologies was waning. COBOL. Relational databases were starting to take over, and COBOL usage was waning. By now, you would think it was utterly dead, right? You would be wrong. Go to …
Webinar | Database Monitoring: The ROI of Build vs. Buy
The post Webinar | Database Monitoring: The ROI of Build vs. Buy appeared first on SQLServerCentral.
Amazon EC2 | Creating a Connection to an Amazon RDS Instance
Introduction In a previous article, we showed how to expose an Amazon RDS instance to the public internet securely for direct access to the database. This article focuses on configuring an Amazon EC2 instance for network access to an existing Amazon RD …
SQL Server 2022 Paid Editions Require a Licensing Key
The post SQL Server 2022 Paid Editions Require a Licensing Key appeared first on SQLServerCentral.
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