Introducing the MySQL INSERT statement
Entry in Robert Sheldon’s series on Learning MySQL. The series so far: Getting started with MySQL Working […]
automate
Introducing the MySQL SELECT statement
The series so far: Getting started with MySQL Working with MySQL tables Working with MySQL views Working […]
Security in MySQL: Part Two
Welcome back to this series about improving the security in your MySQL infrastructure. The first part of […]
Datamarts and exploratory analysis using Power BI
Power BI Datamarts is an important new feature announced during BUILD. This new feature expands Power BI […]
How to troubleshoot and fix PostgreSQL performance issues
PostgreSQL is a popular database that is used by many applications. It’s been in active development for […]
Security in MySQL: Part One
Security is a critical part of any infrastructure – it’s even more so in the database world, […]
Creating unique datasets with managed code
Figuring out uniqueness in large datasets is somewhat trivial in SQL via the DISTINCT statement. This DISTINCT […]
Oracle sequences: The basics
Many database applications make use of “meaningless ids” or “synthetic keys” rather than using columns of user […]
How SQL Server synonyms help database DevOps
Synonyms inside SQL Server are one of those useful but forgotten features. A synonym is a database […]
Key insights from the 2021 State of Database DevOps survey
This is the fifth year that Redgate has surveyed IT professionals about their organization’s DevOps practices. Each […]
Recruiting DBAs for DevOps
Experienced DevOps professionals have the responsibility to assimilate new people into the movement. DBAs coming on board […]
Why database folks should care about User Research
I attended a training session at Redgate this week by Chris Spalton. Chris’ session topic was “An […]