Check Azure SQL DB Space Used
A couple of days ago I was doing some cleaning on some Azure SQL DBs and shrinking some files to lower the bill.
To check my progress I needed to...
2024-05-02
222 reads
Cláudio Silva
- Website: https://claudioessilva.eu
2024-03-29
9,304 reads
Query Store: How to open multiple instances of the 'Tracked Queries' dashboard
At the beginning of this week, I shared how you can Search for queries with Query Store GUI .
Today I want to share something, Query Store related, that bugged...
2024-02-16 (first published: 2024-02-01)
375 reads
Search for queries with Query Store GUI
Hey folks, long time no write!
Today I want to bring a tip that I use every week but I found that most SSMS users are unaware it exists.
I can...
2024-02-09 (first published: 2024-01-29)
702 reads
dbatools - Exceptions
Who doesn’t like a good red and verbose exception? At PowerShell community we often call it a “sea of red” which we found as something that can be intimidating....
2022-06-27 (first published: 2022-06-07)
371 reads
dbatools - Rich Datatypes
Some datatypes can be shown in so many different forms (think measurament units, dates with short/long forms, or regional settings) that can be difficult to have a standard. What...
2022-06-13 (first published: 2022-06-02)
303 reads
A (big) SQLPackage caveat
Context I had a request to help with a database from a third-party vendor which uses a lot of FullText-Search (FTS) catalogs. I have to say that I just...
2021-12-29
20 reads
T-SQL Copy & Paste Pattern – Increasing a performance problem
Disclaimer: The title is my assumption because I saw it in the past happening this way. This blog post aims to make you remember something: something that is obvious...
2021-04-29 (first published: 2020-02-21)
1,283 reads
Finding the Free Space Difference Between Availability Groups Replicas
When was last time you have checked your Always On Availability Groups' replicas storage distribution?
2020-11-09
2,199 reads
Great Power(Shell)...Great Responsibility
-WhatIf you could see what would happen if you ran a command?
2020-10-23
3,932 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