Auditing SQL Server – Part 4 – Database Configuration Audit
This continues my series on auditing SQL Server. The fist parts covered discovery and documentation, server level […]
Database
Breaking Down DENSE_RANK(): A Step-by-Step Guide for SQL Enthusiasts
Introduction to SQL Window Functions In today’s data-driven world, SQL (Structured Query Language) stands as a cornerstone for […]
Forget the Models, Your Data is the Secret Sauce for ...
Credit: Image generated by Google Bard Generative AI (GenAI) models like GPT, Gemini, PaLM, DALL-E, and others offer […]
SQL Window Functions Series: LAG() and LEAD()
In the realm of data analysis, being able to understand the relationships between sequential data points is paramount. […]
Different Ways to Populate the List of Tables
A database administrator has various tasks and responsibilities. Managing and keeping track of the database is one of […]
7 ways businesses can improve the quality and speed of ...
The post 7 ways businesses can improve the quality and speed of database releases appeared first on SQLServerCentral.
How to Find the SQL Server Instance Startup Time
This article explains the different methods to find the startup time of an SQL Server. We can use […]
How to Automate Cross-Platform Database Development
The post How to Automate Cross-Platform Database Development appeared first on SQLServerCentral.
Database Monitoring: The ROI of Build vs. Buy
The post Database Monitoring: The ROI of Build vs. Buy appeared first on SQLServerCentral.
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 […]
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 […]
Backing up MySQL Part 4: mydumper
There are many tools we can use to back up our MySQL databases. Some are well-known and […]
Amazon RDS – Configuring a Connection to a SQL Server ...
Introduction In a previous article, we explored the factors worth considering when deploying a database in the public […]
Backing up MySQL Part 3: mysqlpump
In the MySQL world, there are a couple of ways to take backups of your data. Backups […]
Backing Up MySQL Part 2: Percona XtraBackup
There’s no doubt about it – if you’ve ever heard of Percona, you’ve heard of XtraBackup as […]
Optimizing MySQL: The Basics of Query Optimization
MySQL is a very interesting beast to deal with – both junior developers and expert database administrators […]
Database Deployment with Terraform – Modules
Reusable code in Terraform is key when automating database deployments of complex environments. As you add more resources, […]
Database Deployment with Terraform – The Basics
This article is an introduction to automated database deployments with Terraform. Terraform is now one of the most […]