On Aug 22, 2023, I’m co-hosting a webinar with Anderson Rangel, Redgate Solution Engineer in Brisbane. You can register here for the 11am AEST webinar. No, I’m not going...
2023-08-11
13 reads
Years ago Redgate did some traveling events under the SQL in the City brand. These were a lot of fun and kind of amazing. One of the longer tours...
2023-08-10
24 reads
I had a client ask about how to deal with encrypted stored procedures in their database. This post looks at how to find them and I’ll have future posts...
2023-08-09
286 reads
In today’s world of wanting to automate everything, specifically, automating your CI/CD process for your Power BI datasets and dataset refreshes, you need to understand your options when it...
2023-08-09 (first published: 2023-07-24)
187 reads
The defaults for saving SQL Agent Job history are ok (at best), so you should probably check and update them ... Continue reading
2023-08-09 (first published: 2023-07-25)
262 reads
RDS Custom for SQL Server now supports Local Time ZonesAmazon RDS for SQL Server supports minor version 2019 CU21Amazon RDS for SQL Server now supports self-managed Active DirectoryAmazon RDS...
2023-08-08
76 reads
This T-SQL Tuesday is from a new host, Josephine Bush, leader of the Boulder group just North of me. It’s an interesting invitation, asking what our job titles really...
2023-08-08
204 reads
The start of learning at the 2023 PASS Data Community Summit is 100 days away. I checked. The Summit starts for many of us on Monday with precons or...
2023-08-07
33 reads
(2023-July-15) Let's say you have a collection of Power BI .pbix files stored in a git-based source control system (GitHub, Azure DevOps, or any other system). Among these files, one...
2023-08-07 (first published: 2023-07-15)
540 reads
I recently created a treemap in Power BI for a Workout Wednesday challenge. Originally, I had set out to make a different treemap, but I ran into some limitations...
2023-08-07 (first published: 2023-07-14)
201 reads
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
By Steve Jones
I was chatting with the product managers at Flyway and one asked me whether...
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
hi for the 2 years i've been here I believe we've had "encryption" turned...
Hi I have an overnight process that moves allot of claims records Been working...
Comments posted to this topic are about the item Unlocking Data Transformation: My journey...
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers