Hello SQL Server world!
Hi folks! Look, my very first post, yay!
I’ve been thinking about starting my own SQL-related blog for a long time and I guess...
2015-04-04
536 reads
Hi folks! Look, my very first post, yay!
I’ve been thinking about starting my own SQL-related blog for a long time and I guess...
2015-04-04
536 reads
I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are...
2015-04-03 (first published: 2015-03-30)
8,926 reads
Have you ever had a user run a query against one of your largest tables only for them to immediately...
2015-04-03
16,273 reads
One of my favorite events of the year is the SQL Saturday in Silicon Valley. They’ve had four of them...
2015-04-03
605 reads
Hi Folks
Highlighting on the issue that I faced last week while working on reporting services 2005.
Requirement :- A data region (table)...
2015-04-03
635 reads
Someone asked me the question recently about how tSQLt works with TRY..CATCH blocks and the exceptions that we might test...
2015-04-03 (first published: 2015-03-25)
8,288 reads
The TL;DR - beware of Failover Cluster Manager trying to steal your non-shared storage!
--At a client recently two availability groups on...
2015-04-02
12,919 reads
When you configure log shipping, there are 4 SQL Server Agent jobs that are set up:
Backup: Performs a backup log...
2015-04-02 (first published: 2015-03-30)
6,890 reads
Today I learned that you can’t adjust the font size in SQL Server Management Studio’s Object Explorer pane. Nor registered...
2015-04-02
622 reads
Generating tSQLt tests from a dacpac
I use SSDT and tSQLt in my work and I am always interested in productivity...
2015-04-02
1,277 reads
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
I was messing around performing investigative work on a pod running SQL Server 2025...
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Comments posted to this topic are about the item Encoding Strings
Comments posted to this topic are about the item Deep Learning and Craftsmanship Matter
Comments posted to this topic are about the item Building a Real-Time Analytics Pipeline...
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