In Memory Optimized Table in SQL Server 2014
To increase performance of highly accessible tables, a new feature incorporated in Sql Server 2014 “In-Memory OLTP”.You can define a...
2015-04-21 (first published: 2015-04-11)
8,229 reads
Blog Posts
Moving SQL Server data between filegroups – Part 1 – Database Structures
Why is moving data between filegroups hard?
****As a consultant its common to walk into a customer site and find databases that are contained in one very large file. For...
2015-04-21
6 reads
Outlier Detection with SQL Server, part 6.1: Visual Outlier Detection with Reporting Services
By Steve Bolton
…………Most of the previous articles in this self-tutorials on using SQL Server to find outliers required us to...
2015-04-21
1,734 reads
Query Hash Formula Changes Between Versions
The question came up on SQL Server Central that someone wanted to track queries on their 2008R2 instance and on...
2015-04-21
617 reads
Speaking at IT/Dev Connections
I am very happy to announce that I will be presenting two sessions at this year’s IT/Dev Connections conference in Las Vegas!...
2015-04-21
407 reads
SQL 2014 CU5
By David Postlethwaite
If you are using SQL Server 2012 or 2014 RTM you will find that SSMS offers very limited...
2015-04-21
782 reads
What Permissions do I need to generate a deploy script with SSDT?
It is sometimes useful to be able to use sqlpackage.exe to create a script that can be deployed manually or...
2015-04-21
469 reads
What Permissions do I need to generate a deploy script with SSDT?
It is sometimes useful to be able to use sqlpackage.exe to create a script that can be deployed manually or...
2015-04-21
38 reads
What Permissions do I need to generate a deploy script with SSDT?
It is sometimes useful to be able to use sqlpackage.exe to create a script that can be deployed manually or...
2015-04-21
66 reads
What Permissions do I need to generate a deploy script with SSDT?
It is sometimes useful to be able to use sqlpackage.exe to create a script that can be deployed manually or still automatically but at a later date plus you...
2015-04-21
7 reads
Blogs
Using AI for Git Hooks
By Steve Jones
Recently I had someone internally ask about whether SQL Source Control supports Git Hooks....
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...
Forums
SQL Agent job running gMSA cannot backup to NAS target
I'm running a group MSA for the database engine and SQL Agent in a...
sys.query_store_query question
All, My query is as follows: SET DATEFORMAT dmy SELECT p.query_id, DATEADD(MICROSECOND,-rs.max_duration,rs.first_execution_time) AS starttime,...
Encoding Strings
Comments posted to this topic are about the item Encoding Strings
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