Deploying Row Level Security with SQL Compare
Row Level Security (RLS) is a great new feature in SQL Server 2016. It’s been in Azure SQL Databases for...
2016-07-29 (first published: 2016-07-25)
1,297 reads
Blog Posts
Off-Topic: Phone number spoofing. Why is this still a thing?
A bit of history
Long ago there were such things called diverters. The phone company used them so employees could dial...
2016-07-29
905 reads
SQL Server 2016 FK operator bug?
I recently read an a blog on MSDN that covered new features for the query optimizer in SQL Server 2016....
2016-07-29 (first published: 2016-07-25)
2,030 reads
Why I like SQL Sentry Plan Explorer
Why I like SQL Sentry Plan Explorer. I am going to be honest here, before attending SQLSKILLS Immersion training I...
2016-07-29
640 reads
600 Miles, Limits, Fears, and Possibilities for SQLSaturday
Last week PASS published some new guidance for SQLSaturday that sets a 600 mile rule (has since been updated, still...
2016-07-28
1,333 reads
Learn About SQL Server Master Data Services 2016
SQL Server 2016 comes up with the new release of Master Data Services (MDS). In it, some new features have...
2016-07-28 (first published: 2016-07-25)
2,466 reads
Monitor Query Performance
Blog post #7 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel. Read about it here.
Sooner or later when you’re working...
2016-07-28 (first published: 2016-07-25)
2,621 reads
Quick Scalar Tables–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-07-28
931 reads
Using Context To Traverse Hierarchies In DAX
My friend and coworker Melissa Coates (aka @sqlchick) messaged me the other day to see if I could help with a...
2016-07-28
796 reads
Webinar – What’s new in SSIS 2016
I’ll be giving a webinar on the new features of Integration Services 2016.
When? August 11, 2016
Where? On the MSSQLTips.com website. You...
2016-07-28
814 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