Azure SQL Database – Automatic Index Tuning
Introduction: -
We live in an era of “Automation”. Planes run on auto pilot mode, cars will soon be auto driven, so why not have auto indexed databases? This article...
2018-03-30
395 reads
SQL and SQL Only
Azure SQL Database – Automatic Index Tuning
Introduction: -
We live in an era of “Automation”. Planes run on auto pilot mode, cars will soon be auto driven, so why not have auto indexed databases? This article...
2018-03-30
11 reads
Azure SQL Database – Automatic Index Tuning
Introduction: -
We live in an era of “Automation”. Planes run on auto pilot mode, cars will soon be auto driven,...
2018-03-30
868 reads
Webinar on Adaptive Query Processing for Data Platform Geeks
My session on Adaptive Query Processing has been finding significant interest in Data Platform events 🙂 Delivered 2 webinars for Data Platform Geeks community, one of them at American...
2018-03-18
22 reads
Webinar on Adaptive Query Processing for Data Platform Geeks
My session on Adaptive Query Processing has been finding significant interest in Data Platform events 🙂 Delivered 2 webinars for Data Platform Geeks community, one of them at American...
2018-03-18
7 reads
Webinar on Adaptive Query Processing for Data Platform Geeks
My session on Adaptive Query Processing has been finding significant interest in Data Platform events 🙂 Delivered 2 webinars for Data...
2018-03-18
764 reads
Data Channel Interview - 10 - Dinesh Priyankara on Azure Data Lake Analytics
Here we go for the 10th Interview of Data Channel. In this interview, Dinesh Priyankara, a 12-time MVP from Sri Lanka, demystifies Azure Data Lake and ADL Analytics. This...
2018-02-09
25 reads
Data Channel Interview - 10 - Dinesh Priyankara on Azure Data Lake Analytics
Here we go for the 10th Interview of Data Channel. In this interview, Dinesh Priyankara, a 12-time MVP from Sri Lanka, demystifies Azure Data Lake and ADL Analytics. This...
2018-02-09
6 reads
Data Channel Interview - 10 - Dinesh Priyankara on Azure Data Lake Analytics
Here we go for the 10th Interview of Data Channel. In this interview, Dinesh Priyankara, a 12-time MVP from Sri...
2018-02-09
378 reads
Configuration Manager Missing - Windows 10
SQL Server Configuration Manager is one of the fundamental tools for a DBA to do basic tasks like starting or stopping SQL Service, knowing how many instances and what...
2018-01-21
7 reads
Blogs
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022
By SQLPals
Reality (And Limits) of Instant File Initialization for Transaction Logs in SQL Server 2022 ...
Looking Back at the Redgate 2026 Company Kickoff
By Steve Jones
Last week I spent a few days in Cambridge, UK for the Redgate Company...
PASS Data Community Summit 2025 Recap
By alevyinroc
This is long overdue but life and distractions happened. It’s been a little over...
Forums
Microsoft no longer being supported?
The word is finally out that Microsoft is no longer supporting SSRS. I just...
SQL Agent job running gMSA cannot backup to NAS target
I'm running a group MSA for the database engine and SQL Agent in a...
sys.query_store_query question
All, My query is as follows: SET DATEFORMAT dmy SELECT p.query_id, DATEADD(MICROSECOND,-rs.max_duration,rs.first_execution_time) AS starttime,...
Question of the Day
Encoding Strings
I have this code in SQL Server 2025. What is the result?
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(@message); SELECT @encoded AS EncodedResult;See possible answers
