Last Week Reading (2019-02-10)
Hello Data Folks! It has been a very fast week and an extensive weekend whilst I have been at SQL...
2019-02-11
126 reads
Blog Posts
Looking for More Storage
I got a new cell phone. Not big news, but it’s primarily because I need want more storage. It’s a...
2019-02-11
210 reads
Memory Grants part 5: Query hints
Proceed with caution, if you’re thinking of using query hints. This post will specifically cover min_grant_percent and max_grant_percent.
My opinion on...
2019-02-11 (first published: 2019-01-22)
10,100 reads
Query Store and a READ_ONLY Database
What happens in Query Store when the database itself is READ_ONLY? Yeah, I don’t know. Let’s find out. READ_ONLY The only way to find out how this works is...
2019-02-11
7 reads
Quick tip: Speeding up deletes from SSIS execution log
If you have SQL Server Integration Services installed on your server, and you left the default configurations a table named sysssislog is created on MSDB database, it contains logging entries...
2019-02-11
14 reads
Weekly reading #2
Good morning! It is Monday! We spent the weekend in Kraków taking part in the SQLSaturday #824. It was a...
2019-02-11
116 reads
Why You Shouldn't Use SELECT * In Production Systems (EVER!)
OK so the title is a bit of a bold statement but bear with me, I’ve been burned by this...
2019-02-11 (first published: 2019-01-23)
6,794 reads
Azure Virtual Machine Boot Diagnostics
If you have ever rebooted a virtual machine and feel like you are in the dark to it’s current state,...
2019-02-08
354 reads
Developing pipelines in Azure Data Factory using Template gallery
(2019-Feb-08) I often see demos of Azure Data Factory (ADF) development techniques with a modest set of activity tasks and not...
2019-02-08
687 reads
Performance on readable replicas in Availability Groups
I apologize in advance if I mess up the terminology.
I’ve worked with a moderate read workload on a readable replica...
2019-02-08
774 reads
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
BCA KCU PURI INDAH Tlpn/wa0853.7373-7551
Gedung C3 Lt. 1-3 Komplek, Jl. Puri Indah Raya No.1-3 Blok 02, Kec. Kembangan,...
BCA KCU BINTARO Hubungi Cs.0851•8812•0691
BCA KCU BINTARO Hubungi Cs.0851•8812•0691 Bintaro Jaya Blok A-5 No.12 & 15, Sektor 7,...
BCA KCP Bojong Indah Tlpn/wa0853.7373-7551
Komp. Bojong Indah Cengkareng, Jl. Pakis Raya 88 H, Daerah Khusus Ibukota Jakarta 11740
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers