An update on AutoAdjustBufferSize in SSIS 2016
This week SQL Server 2016 Cumulative Update 1 was released and it contains a lot of updates/fixes for SSIS, SSAS,...
2016-07-27
2,939 reads
Blog Posts
Bug fixes in SQL Server
SQL Server 2016 CU1 has been released and one thing I noticed was: –
FIX: Canceling a backup task crashes SQL...
2016-07-27
849 reads
Day1 - Assertiveness Skills: Communicating with Authority and Impact
This is the last course of my July training month. This is my second course this week. Yesterday I was...
2016-07-27
990 reads
I wrote a SQL Server auditing whitepaper!
I recently collaborated with Idera to produce a short whitepaper on the top 5 things to audit in SQL Server...
2016-07-27
1,020 reads
Playing with TDE
UPDATE November 2016 – With SQL Server 2016 SP1, Microsoft will include key enterprise-class features in every edition of SQL Server...
2016-07-27
525 reads
T-SQL Tuesday #081: Sharpen Something
This month I am asking you to not only write a post but to do a little homework - first. In other words, plan to do something, carry out...
2016-07-27
4 reads
T-SQL Tuesday #081: Sharpen Something
Sharpen Something
It has now been 30 months since the last time I hosted a TSQL Tuesday, that was TSQL Tuesday...
2016-07-27
918 reads
What’s Database Drift?
The first time I heard someone mention drift at Redgate, it made sense to me. After all, in the context...
2016-07-27 (first published: 2016-07-22)
4,412 reads
When was this database restored?
I frequently need to know where backups went and I restore those backups for operational recovery on a regular basis....
2016-07-27
855 reads
Another Query to Help Find the Right Event
Finding the right event or combination of events to monitor may seem like quite a daunting task with so many...
2016-07-26 (first published: 2016-07-21)
1,599 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