Database Compatibility Level 101
Each SQL Server database has a setting called Compatibility Level that determines how T-SQL commands are interpreted and what features...
2015-04-12
1,708 reads
Each SQL Server database has a setting called Compatibility Level that determines how T-SQL commands are interpreted and what features...
2015-04-12
1,708 reads
It was a great honor to be asked to join my associates from SolidQ at the Microsoft Virtual Academy Studios...
2015-04-12
440 reads
It was a great honor to be asked to join my associates from SolidQ at the Microsoft Virtual Academy Studios...
2015-04-12
173 reads
When I think about Baltimore, I think about Edgar Allan Poe. Baltimore was Poe’s one-time home, and in fact there...
2015-04-10
618 reads
Big Data, what a term! Some people instantly think of a huge sometimes cumbersome volume of information, others define it...
2015-04-10
1,635 reads
2015-04-10
1,113 reads
I decided in January that I would write regularly about people that I’m grateful for. Now it’s April. Oops.
The concepts...
2015-04-10
531 reads
In-Memory OLTP is getting a lot of (rightly deserved imho) hype at the moment. But what does it entail exactly?...
2015-04-10 (first published: 2015-04-06)
837 reads
I use PowerShell a lot and I write about using it to solve problems quite frequently. The fact that I...
2015-04-10
672 reads
I use PowerShell a lot and I write about using it to solve problems quite frequently. The fact that I...
2015-04-10
412 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