Log Shipping – Error: Failed to update database “DATABASE NAME” because the database is read-only
Here’s a strange one that I’ve recently come across. I had a customer report that their log shipping restore jobs...
2018-02-22
744 reads
Activate Conference 2018: Presentation info
A special hello if you're visiting this blog post during or after my workshops on Thursday afternoon, February 22 at...
2018-02-22
321 reads
dbachecks – Configuration Deep Dive
Today is the day that we have announced dbachecks a PowerShell module enabling you to validate your SQL Instances. You...
2018-02-22
1,084 reads
dbachecks – A different approach for an in-progress and incremental validation
dbachecks is a new PowerShell module from the SQL Server Community! For more information, read introducing dbachecks. If you don't...
2018-02-22
506 reads
dbachecks – Using Power BI dashboards to analyse results
For the last couple of months, members of the dbatools team have been working on a new PowerShell module called...
2018-02-22
865 reads
Announcing dbachecks – Configurable PowerShell Validation For Your SQL Instances
For the last couple of months members of the dbatools team have been working on a new PowerShell module called dbachecks....
2018-03-07 (first published: 2018-02-22)
2,604 reads
Recovering a TDE protected database without the Certificate
If you’ve been careful and done everything right when you’re setting up TDE then you shouldn’t run into this problem.
We...
2018-02-21
3,550 reads
Dates and Times in SQL Server: DATETIME
Last year I ran a series of posts about Database Fundamentals. Over the next few weeks, I will cover the...
2018-02-21
338 reads
Automating Database Deployment: Part 3 Running RoundhousE
Now that we have a basic understanding of RoundhousE database deployment from the first two parts of this series let’s get to the good stuff. If you haven't read...
2018-02-21
35 reads
Windowing without a partition by or an order by
If you’ve never worked with windowing functions they look something like this:
SELECT name, max(create_date) OVER
-- No this isn't meant to...
2018-02-21
1,482 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers