My Interview at SQL Server Geeks 2016
One of the biggest highlights of this year for me was speaking at SQL Server Geeks Annual Summit 2016. In...
2016-12-11
392 reads
Nagaraj Venkatesan
Query Store - Part 4 - Find the plans and queries forced by Query Store
As most of you know, one of the most fundamental uses of query store is to force query plans. Unlike...
2016-12-08
1,078 reads
Data Channel - Interview 01 - Andreas Wolter on Columnstore
Dear all,
Welcome to the first ever interview of DataChannel. I am honored to have Mr.Andreas Wolter, a German MVP, MCM, MCSM...
2016-12-03
726 reads
SQL Server 2016 SP1 – Rocking RELEASE!!!
Last week, I did a presentation titled "SQL Server 2016 SP1 – Rocking RELEASE!!!" to Singapore SQL User Group. The Presentation was...
2016-11-29
850 reads
Data Channel - Launch
Dear All,
I am starting a YouTube channel for SQL Server and Microsoft Data Platform Technologies called "Data Channel". What this...
2016-11-26
413 reads
SQL Server 2016 - SQL Service Doesn't Start after GDR Security update
Recently, after an security fix GDR (https://support.microsoft.com/en-us/kb/3194716) on SQL Server 2016 RTM, SQL Service refused to start. Though, the patch...
2016-11-20
1,182 reads
Residual Predicate and "Number of Rows Read" in Execution Plans
What is Residual Predicate?
Lets say one gets a query to fine tune. While checking the execution plan, if there is...
2016-11-17 (first published: 2016-11-13)
4,625 reads
SQL Server 2016 SP1 Release - Thoughts and Comments!!!
SQL Server 2016 SP1 has released last night and most of the features that were previously part of enterprise edition...
2016-11-17
722 reads
SQL Server 2016 - “Number of Rows Read” on Execution plan
One of the coolest things to release with SQL Server 2016 was “Number of Rows Read” information in execution plan....
2016-11-10
829 reads
Query Store - Part 3 - How it works?
Query Store collects 2 important kinds of data. They are
1) Compile time statistics - Query Plan, Estimated Costs, Estimated number of...
2016-11-06
806 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