HOWTO-Get-T-SQL-Into-SSDT
Ok so you have created an SSDT project and are currently congratulating yourself on how awesome and cool you are...
2015-04-08
31 reads
Blog Posts
Journey to Being a Consultant – Webinar Today
Today at 11am Central time I will be presenting a new session entitled “Journey to Being a Consultant” for the...
2015-04-08
526 reads
Make sure you back up the Service Master Key
I’m by no means an expert in SQL Server encryption. What I do know however, is that the Service Master...
2015-04-08
817 reads
Trust No One Implicitly
At the Charlotte BI Group meeting last night, one of the questions I was asked after I gave my talk...
2015-04-08
283 reads
What is a data lake?
A “data lake” is a storage repository, usually in Hadoop, that holds a vast amount of raw data in its...
2015-04-08
2,644 reads
A New Use Case for SQL Prompt – Shrinking Code
I thought this would work, but I wasn’t sure. I saw some code the other day like this:
DECLARE@charASCHAR(1);
SET@char=NULL;
SELECTISNULL(@char, 0);
SELECTCOALESCE(@char, 0);
SET@char='E';
SELECTISNULL(@char,...
2015-04-07
643 reads
Audit who Dropped the Database
In the first article on this topic (which can be read here), I discussed the problem of having a database get dropped and the need to find out who...
2015-04-07
11 reads
Connecting SQLite to SQL Server with PowerShell
This post is part of Ed Leighton-Dick’s SQL New Blogger Challenge. Please follow and support these new (or reborn) bloggers.
I’m working with a number of SQLite databases as extra data...
2015-04-07
45 reads
Documentation: Are You Ready?
Would your coworkers know how to handle your job if you weren’t there?
This question was top-of-mind for me last week...
2015-04-07
1,093 reads
Error: Unknown Property ismemoryoptimized
If you’re starting the process of moving your databases in Azure SQL Databast to v12, you need to do one...
2015-04-07
2,062 reads
Blogs
Flyway Tips: AI Helps with Commit Messages
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
Startup scripts in SQL Server containers
I was messing around performing investigative work on a pod running SQL Server 2025...
Using SQL Compare with Redgate Data Modeler
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Forums
Encoding Strings
Comments posted to this topic are about the item Encoding Strings
Deep Learning and Craftsmanship Matter
Comments posted to this topic are about the item Deep Learning and Craftsmanship Matter
Building a Real-Time Analytics Pipeline with Azure Stream Analytics and SQL Server
Comments posted to this topic are about the item Building a Real-Time Analytics Pipeline...
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