October 2021

It is 10 PM, do you know where your pages are?

2021-10-26
SQL Server Database Engine, SQL Server Reporting Services, Tools and Scripts
1 Comment

Back in April 2020, I created an open-source project called “SQL Server Page Allocation Reports“. It consisted of a set of SQL queries and some Power BI reports that can be used for visualizing the size and locations of your data and transaction log pages.

Well, recently I also added SSMS Custom Reports into the mix. So, it’s time to revisit this project and see what’s new!

T-SQL Tuesday #143 – Short Powershell code to move DB files in AlwaysOn

2021-10-13
T-SQL Tuesday, Tools and Scripts
1 Comment

This month’s #tsql2sday is hosted by John McCormack who asks us to share some useful snippets of code that can help us in our everyday jobs.

Well, honestly, this is more or less what my blog is mostly about anyway: sharing insights, scripts, and code snippets that I found to be helpful in my day-to-day job as a SQL Server consultant.