[Video] Office Hours: As They Pour My Patio Concrete Edition
I can finally see the finish line in my backyard renovation, now that the concrete’s going in. I took a break from watching the construction folks to go through your highly upvoted questions at https://pollgab.com/room/brento: Here’s what w …
How to Reduce the Need for Bookmarks Using Parameters in Power BI
Introduction to the Problem When developing Power BI reports, it’s often necessary to slice and interpret datasets in different ways. Using a combination of multiple pages, overlaying visuals and toggling their visibility, setting navigation and action …
Unmasking SQL Server Dynamic Data Masking, Part 4, Unmasking Formatted and Unformatted Text
This is part of a series on Dynamic Data Masking by Ben Johnson. For the rest of the series, click here Continuing from the previous entry in this series on security concerns with using Dynamic Data Masking, in this blog I want to close out that discus …
On the Road Again, Next Up Columbus
January 18, 2020, was the last time I stood in front of a live group of people and spoke about anything. It was at the location where I did my first SQL Saturday presentation, back at the first SQL Saturday in Nashville. Speaking at the time was a norm …
How to Make Database Changes Without Breaking Everything
You’ve got an existing application with a database back end. You’re thinking about changing the database, and you don’t wanna break stuff. The most important thing to understand is difference between constructive and destructive chang …
Using a Subquery in a SELECT statement
This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 10 items in the series, click here. Did you know you can include a SELECT statement within another SELECT statement? When a SELECT statement is embedded within anothe …
[Video] Office Hours: Professional Development & Training Questions
The post [Video] Office Hours: Professional Development & Training Questions appeared first on SQLServerCentral.
SQL Server Resumable Index Operations
As the DBA, have you ever had to cancel an online rebuild or create index process on a very large table? Perhaps it didn’t finish during your maintenance window or consumed valuable resources, causing other queries to run slowly? It is a headache for a …
Cheat Sheet for SQL Server DBAs – Monitoring Current Activity, Blocking and Performance
The post Cheat Sheet for SQL Server DBAs – Monitoring Current Activity, Blocking and Performance appeared first on SQLServerCentral.
Pipelining Configuration Information Securely to Flyway
The post Pipelining Configuration Information Securely to Flyway appeared first on SQLServerCentral.
It’s Friday. I’m Not Answering These 14 Office Hours Questions.
Sometimes, I don’t care if questions get a lot of upvotes at https://pollgab.com/room/brento – I just don’t wanna answer ’em. They’re not necessarily bad questions, but I’m just not interested in them, or I’ve …
Call for Panelists – WIT Panel at PASS Data Community Summit, 2023
The WIT panel at the PASS Summit has been a longstanding tradition. We, the Data Platform WIT team, are honored to be entrusted with the task of selecting and hosting this year’s panel. To determine the topic, we conducted a brief poll and arrived at t …
How to Find the SQL Server Version
This article explains various methods to find the SQL Server version for an instance. Knowing the SQL Server version is important for several reasons: Feature availability: Different versions of SQL Server have different sets of features available. Som …
Troubleshoot SQL Server Deadlocks in Stored Procedures
The post Troubleshoot SQL Server Deadlocks in Stored Procedures appeared first on SQLServerCentral.
[Video] Office Hours: Github Copilot in Azure Data Studio
I start today’s Office Hours by playing with the very underwhelming Github Copilot in ADS, then take your questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 04:06 Github Copilot in Azure Data Studio 24:36 By …