Converting identifiers into SQL Server table variables in Management Studio
If I had a nickel for every time someone gave me a list of identifiers and asked me to pull...
2015-04-20 (first published: 2015-04-09)
5,792 reads
If I had a nickel for every time someone gave me a list of identifiers and asked me to pull...
2015-04-20 (first published: 2015-04-09)
5,792 reads
This post follows on from In-Memory OLTP: Part 2 – Indexes
So far in this blog series memory optimised tables have been...
2015-04-20
1,092 reads
This post follows on from In-Memory OLTP: Part 2 – Indexes
So far in this blog series memory optimised tables have been...
2015-04-20
417 reads
I’m a big fan of automation. I’ve been in IT for 27 years now. One unchanging rule during that time...
2015-04-20 (first published: 2015-04-09)
5,069 reads
2015-04-20
537 reads
To be fair it’s not actually hidden, just not so well known.
Have you ever wondered how to grant permissions...
2015-04-20
1,505 reads
Starting with SQL Server 2008, we can use the MERGE statement to solve some every day scenarios in more elegant...
2015-04-20
2,294 reads
HOST_ID and HOST_NAME
Included in T-SQL for SQL Server is a functions that returns the workstation information that executes a SQL...
2015-04-20
3,515 reads
Continuation from the previous 50 parts, the whole series can be found at http://www.nikoport.com/columnstore/
This post is dedicated to usage of...
2015-04-19
1,111 reads
Hi friends, in this blog I am going to tell you about effect of CONCAT_NULL_YIELDS_NULL for computed columns while creating...
2015-04-18
226 reads
By Steve Jones
Recently I had someone internally ask about whether SQL Source Control supports Git Hooks....
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...
All, My query is as follows: SET DATEFORMAT dmy SELECT p.query_id, DATEADD(MICROSECOND,-rs.max_duration,rs.first_execution_time) AS starttime,...
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
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