[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.
[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 …