Rename a Primary Key–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-07-21
1,750 reads
Blog Posts
SQL 2016 SSIS new feature AutoAdjustBufferSize
If you have not already seen in the What’s New in Integration Services list there is a new property for...
2016-07-21
1,744 reads
SQL Server: Consolidation Tactics and Best Practices
My very first course has been published on Pluralsight – SQL Server: Consolidation Tactics and Best Practices. In this course I...
2016-07-21
1,505 reads
Who the Hell is Going to Listen to SQL Server on the Radio
About 3 years ago Matan Yungman contacted me and said he has an interesting proposition. We met and talked about...
2016-07-21
281 reads
Day 1: Agile Fundamentals: Scrum, Kanban, Lean and XP
It's week 3 of my jammed packed training schedule this July. This week I'm producing course 918 Agile Fundamentals: Scrum,...
2016-07-20
666 reads
Deploying Dynamic Data Masking Changes
I wrote a short piece over on the Redgate blog that covers how SQL Compare can catch and build a...
2016-07-20
458 reads
Growth or Control – #sqlpass
I’m disturbed.
I read an announcement from the PASS organization this week that bothers me. I am less upset with the...
2016-07-20
776 reads
Multi-tenant databases in the cloud
For companies that sell an on-prem software solution and are looking to move that solution to the cloud, a challenge...
2016-07-20
1,176 reads
Power BI Custom Visuals Class (Module 08 – Dot Plot)
In this module you will learn how to use the Dot Plot Power BI Custom Visual. The Dot Plot is...
2016-07-20 (first published: 2016-07-18)
2,365 reads
Remove-SQLDatabaseSafely My First Contribution to DBATools
What is DBA Tools?
A collection of modules for SQL Server DBAs. It initially started out as ‘sqlmigration’, but has now...
2016-07-20
998 reads
Blogs
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
SQL Server 2025 CU1 Fixes the Docker Desktop AVX Issue on macOS
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
Forums
25 Years of SQL Server Central
Comments posted to this topic are about the item 25 Years of SQL Server...
The Decoded Value
Comments posted to this topic are about the item The Decoded Value
Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers