Backing up MySQL Part 1: mysqldump
mysqldump is one of the most popular database backup tools in the MySQL world. The tool is prevalent partly because it’s very basic and quite powerful – mysqldump database backup tool is command line-based, very simple and very straightforw …
Steps to Quickly Configure an AWS RDS SQL Server instance
The post Steps to Quickly Configure an AWS RDS SQL Server instance appeared first on SQLServerCentral.
Office Hours: One-Word Answers Edition
Some of the questions y’all post at https://pollgab.com/room/brento are pretty straightforward. Let’s get ‘er done. LetTheDbaHandleIt: My friend needs to track who has accessed what data. This is easy at OS and app level, but how can …
[Video] Office Hours Live: Ask Me Anything
Got a question for me? Post your questions at https://pollgab.com/room/brento and upvote the ones you’d like to see me discuss. Before heading to NYC for vacation, I recorded a live Office Hours on my Twitch channel. Here’s what we covered: …
Copy SSIS Environment variables to another server
From SQL Server 2012 onwards, Microsoft introduced a new deployment model in SSIS, called the project deployment model. This new model has many benefits in managing SSIS project deployments, executions, and configurations. Every new version of SQL Serv …
How to Apply Clustering in a Scatter Plot to Visualize Segments in Power BI Desktop
The post How to Apply Clustering in a Scatter Plot to Visualize Segments in Power BI Desktop appeared first on SQLServerCentral.
#tsql2sday: Start Your Dynamic SQL with a Comment.
When you write dynamic SQL, start like this:CREATE OR ALTER PROC dbo.MyProc AS BEGIN DECLARE @StringToExecute NVARCHAR(4000); SET @StringToExecute = N’SELECT /* MyProc */ ‘; … Right after the SELECT (or INSERT or UPDATE or whatever), immediately put …
This Week, Fundamentals of Query Tuning Classes are Free!
Every weekday during the month of October, one of the modules from my Fundamentals classes will be absolutely free to watch. But you gotta watch it that day – you snooze, you lose. This week is Fundamentals of Query Tuning. Last week’s clas …
Rethinking SQL Explicit Transactions
The post Rethinking SQL Explicit Transactions appeared first on SQLServerCentral.
Post-migration Validation and Optimization Guide
The post Post-migration Validation and Optimization Guide appeared first on SQLServerCentral.
Database Deployment with Terraform – Modules
Reusable code in Terraform is key when automating database deployments of complex environments. As you add more resources, you must rethink the way you organize your scripts so you can manage them efficiently. In my first article on this subject, I pre …
Introducing the MySQL INSERT statement
Entry in Robert Sheldon’s 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 MySQL SELECT s …
Data Masking: Static vs Dynamic
The problem of data masking comes up surprisingly often in the world of IT. Any time you need to share some potentially sensitive data, you may need to hide, obfuscate, randomize or otherwise dissimulate some of that data — we’ll call that the secret …
Improving the Quality of Data Governance: Where to Start?
The post Improving the Quality of Data Governance: Where to Start? appeared first on SQLServerCentral.
Build Conditional Logic – SQL IF, BEGIN, END, ELSE, ELSEIF
The post Build Conditional Logic – SQL IF, BEGIN, END, ELSE, ELSEIF appeared first on SQLServerCentral.