Searching Flyway Migration Files using Grep and Regex
The post Searching Flyway Migration Files using Grep and Regex appeared first on SQLServerCentral.
Archives du mois : juin 2023
Unpivot Data Using Python
Problem Statement In one of the Business Analytics Dashboards Projects, Sales data is received from different countries (100 […]
[Video] How to Use ChatGPT to Write WordPress Blog Posts
Today’s live stream was a little different: I demonstrated using the Aiomatic WordPress plugin, ChatGPT, and Azure Open […]
[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 […]
How to Reduce the Need for Bookmarks Using Parameters in ...
Introduction to the Problem When developing Power BI reports, it’s often necessary to slice and interpret datasets in […]
Unmasking SQL Server Dynamic Data Masking, Part 4, Unmasking Formatted ...
This is part of a series on Dynamic Data Masking by Ben Johnson. For the rest of […]
On the Road Again, Next Up Columbus
January 18, 2020, was the last time I stood in front of a live group of people […]
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 […]
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 […]
[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 […]
Cheat Sheet for SQL Server DBAs – Monitoring Current Activity, ...
The post Cheat Sheet for SQL Server DBAs – Monitoring Current Activity, Blocking and Performance appeared first on […]
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 […]
Call for Panelists – WIT Panel at PASS Data Community ...
The WIT panel at the PASS Summit has been a longstanding tradition. We, the Data Platform WIT team, […]
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 […]
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 […]
Updated First Responder Kit and Consultant Toolkit for June 2023
This one’s a pretty quiet release: just bug fixes in sp_Blitz, sp_BlitzLock, and sp_DatabaseRestore. Wanna watch me use […]
How to Avoid N+1 Queries: Comprehensive Guide and Python Code ...
Introduction N+1 queries are a prevalent performance issue in software applications that involve retrieving data from databases. The […]
The Best Career Advice I Ever Got (#TSQL2sday)
Steve Jobs. Photo by Matthew Yohe. I have been absurdly lucky to be around so many amazing and […]