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
5 reads
Blog Posts
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
113 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,757 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
340 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
Rotating Expired SQL Server TDE Certificates
In general, SQL Server TDE certificates will expire at some point. In SQL Server, if we have setup TDE using...
2019-02-08 (first published: 2019-01-23)
1,761 reads
Scheduling things to Run in SQL Server
A key part of the SQL Server Agent is the ability to schedule jobs. While you can create one schedule...
2019-02-08 (first published: 2019-01-23)
2,745 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
What's the Date?
Comments posted to this topic are about the item What's the Date?
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers