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.
[Video] Office Hours Silent Edition
Okay, I, uh, forgot to unmute the microphone for this one: So here are the answers in text form instead. <sigh> Thank goodness it was a speed round! Mike: When Brent Ozar’s certification exams for SQL Server will be available? Looking forwa …
What’s New in SQL Server 2022: GENERATE_SERIES()
I’ve been doing a lot of work with SQL Server 2022 lately and one of my absolute favorite new features that I just came across today is the GENERATE_SERIES() built-in table function. I just happened to see it in the Books Online content while loo …
Who’s Hiring in the Microsoft Data Platform Community? October 2022 Edition
Is your company hiring for a database position as of October 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 in …
Delivering Cloud Transformation Excellence: Collaboration, Communication and Governance – Part 6
The post Delivering Cloud Transformation Excellence: Collaboration, Communication and Governance – Part 6 appeared first on SQLServerCentral.
Transaction locking and row versioning guide
The post Transaction locking and row versioning guide appeared first on SQLServerCentral.
The Basics of Inserting Data into a SQL Server Table
Entry in Greg Larsen series on Learning T-SQL. The series so far: The basic T-SQL Select Statement Ordering a result set in SQL Server The ins and outs of joining tables in SQL Server Summarizing data using GROUP BY and HAVING The Basics of Inserting D …
Erik Darling’s Month of Free Tools Training
Over the past month (plus or minus a couple days), Erik Darling churned out dozens of posts to show how he uses different SQL Server Community Tools that are free and open source to troubleshoot SQL Server issues. You should read all of them. I did. (I …
October is Free Fundamentals Month – And The Training Starts Now.
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 Index Tuning. To follow along with t …
Convert Problematic Data in SQL Server
The post Convert Problematic Data in SQL Server appeared first on SQLServerCentral.
Join the EAP: Next-gen database cloning
The post Join the EAP: Next-gen database cloning appeared first on SQLServerCentral.