Tricks - Copy T SQL Result to Excel
Sometimes, some of the silliest of tricks save so much of time and effort. Very common scenario is to copy a query result to excel. Most take either of...
2017-11-25
6 reads
Nagaraj Venkatesan
Adaptive Query Processing and Automatic Tuning - Introduction - 1
SQL Server 2017 and Azure SQL Database are being touted as the self learning, artificial intelligent database. One of the main reasons for the same is due to release...
2017-11-13
117 reads
Adaptive Query Processing and Automatic Tuning - Introduction - 1
SQL Server 2017 and Azure SQL Database are being touted as the self learning, artificial intelligent database. One of the main reasons for the same is due to release...
2017-11-13
6 reads
Adaptive Query Processing and Automatic Tuning - Introduction - 1
SQL Server 2017 and Azure SQL Database are being touted as the self learning, artificial intelligent database. One of the...
2017-11-12
544 reads
SQL Azure Databases - Active Secondary - Failover Groups - Part 4
150th Blog Post . So, the post involves video demo 🙂
Previous posts on this series was about using "Geo Replication" to...
2017-10-27
387 reads
SQL Azure Databases - Active Secondary - Failover Groups - Part 4
150th Blog Post . So, the post involves video demo :)Previous posts on this series was about using "Geo Replication" to configure active secondary. However, it comes with few...
2017-10-27
23 reads
SQL Azure Databases - Active Secondary - Failover Groups - Part 4
150th Blog Post . So, the post involves video demo :)Previous posts on this series was about using "Geo Replication" to configure active secondary. However, it comes with few...
2017-10-27
5 reads
Dynamic Threshold for Statistic Update - SQL Server 2016
By default, on a SQL Server Database, statistics are updated automatically when one hits a threshold of changes. If the...
2017-09-19 (first published: 2017-09-06)
2,069 reads
Data Channel Interview - 08 - Leila Etaati on Machine Learning using Microsoft BI
Dear All,
Very happy to share the 8th interview of #DataChannel. Dr. Leila Etaati MVP, MCT from New Zealand discusses...
2017-09-11 (first published: 2017-08-28)
1,633 reads
Dynamic Threshold for Statistic Update - SQL Server 2016
By default, on a SQL Server Database, statistics are updated automatically when one hits a threshold of changes. If the Auto Update Statistics setting is turned on by default,...
2017-09-06
1,572 reads
Blogs
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...
Advice I Like: Ranch Rules
By Steve Jones
Leave a gate behind you the way you first found it. – from Excellent...
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes
By SQLPals
Fix Slow, Bloated MSDB: Purge Old History And Add Missing Indexes ...
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