The Axis Of Evil
Views, table variables and local variables are great in terms of programming principles.
But In terms of performance, they can be...
2013-03-25 (first published: 2013-03-20)
2,800 reads
Views, table variables and local variables are great in terms of programming principles.
But In terms of performance, they can be...
2013-03-25 (first published: 2013-03-20)
2,800 reads
One of the most fundamental DMF’s a SQL Server DBA should know is sys.dm_exec_query_plan.
This Dynamic Management Function allows us to see...
2013-03-19 (first published: 2013-03-12)
2,783 reads
Assuming you’ve been on earth lately, you probably heard the terms “Big Data”, “Hadoop”, “NoSQL” and so on.
Companies want to...
2013-03-05
554 reads
About two weeks ago, I wrote about SQL Server Podcasts and why I love that medium so much.
Today, I want...
2013-02-26
1,045 reads
Two weeks ago I delivered a presentation called “Things You Can Find In The Plan Cache” to the israeli SQL Server...
2013-02-18
481 reads
Photo credit: Digitalnative
About a year ago, I came across an online deal for a car stereo system with a USB...
2013-02-14
1,564 reads
I read this awesome post by Joe Sack, titled “Detecting Cardinality Estimate Issues with sys.dm_exec_query_stats”.
I was amazed by the beauty...
2013-01-31
1,879 reads
Usually, a database is meant to serve some kind of application, and .Net applications have a few possible ways to query...
2013-01-09
1,174 reads
SQL Server 2012 is best known for its bombastic new features: AlwaysOn, Columnstore indexes, Window functions enhancements, Extended Events enhancements,...
2012-09-30
1,114 reads
24 Hours of Pass is tomorrow. If you haven’t registered yet, now is a good time.
I expect to:
Have little to no...
2012-09-19
525 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