Office FOMO
There are many things we may miss about the office, but one of them is the chance to interact with and impress management.
Soft Skills: Controlling your career
Technical skills come and go while soft skills will serve you throughout your life. They will have the greatest influence over your career, job and role. For some people soft skills come naturally. As an Aspergers person (Aspie) I have to practice my soft skills at every opportunity. Pure techies need not lose hope. Soft […]
Learn basics of Data Wrangling in SQL Server to handle Invalid Values
In this article we cover the topic of data wrangling which is steps you can take to cleanup and validate data prior to data analysis.
Dynamically Add a Timestamp To Files in Azure Data Factory
This article will describe how to add your local timestamp at the end of the each file in Azure Data Factory (ADF). In general, ADF gets a UTC timestamp, so we need to convert the timestamp from UTC to EST, since our local time zone is EST. For example, if the input Source file name […]
SQL Server Security – Fixed server and database roles
Security roles can simplify permissions in SQL Server. In this article, Greg Larsen explains fixed server and database roles.
Changing Edge Security
Security is changing, and the "edge" of where we need to protect data is changing as well.
Extending Custom Execution in the SSIS Catalog – Level 21 of the Stairway to Integration Services
In this installment of the Stairway to Integration Services, Andy Leonard shows you how to execute packages synchronously or asynchronously.
Batch Processing using Flyway
How to create a batch file that executes any number of database migration tasks across a range of servers and databases, using Flyway.
Common Data Transformations in Power Query
In this article we walk through an example of using Power Query to transform source data that can be used in a Power BI report.
Blogs
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
Looking Back at the Redgate 2026 Company Kickoff
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
Using AI for Git Hooks
By Steve Jones
Recently I had someone internally ask about whether SQL Source Control supports Git Hooks....
Forums
SQL Agent job running gMSA cannot backup to NAS target
I'm running a group MSA for the database engine and SQL Agent in a...
sys.query_store_query question
All, My query is as follows: SET DATEFORMAT dmy SELECT p.query_id, DATEADD(MICROSECOND,-rs.max_duration,rs.first_execution_time) AS starttime,...
Encoding Strings
Comments posted to this topic are about the item Encoding Strings
Question of the Day
Encoding Strings
I have this code in SQL Server 2025. What is the result?
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(@message); SELECT @encoded AS EncodedResult;See possible answers