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
209 reads
Blog Posts
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)
9,860 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
6 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
114 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,760 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
341 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
685 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
771 reads
Pro SQL Server Linux–Moving to Linux
As part of my learning goals for 2018, I wanted to work through various books. This is part of my...
2019-02-08
1,354 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Cross-DB Ownership Chaining problem
We want to setup a gateway db to host stored procedures which use tables...
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers