Building calendar table using MTVF
This script is a small extension to this excellent article
http://www.sqlservercentral.com/articles/calendar/145206/
2017-03-28 (first published: 2017-02-21)
1,417 reads
Scripts
Stored Proc Archives rows to another table
This will Archive and Purge rows from one table to another.
2017-03-27 (first published: 2017-03-17)
802 reads
PatReplace8K
This inline table valued function takes three parameters: @String, @Pattern and @Replace. It located the @pattern in @string and replaces it with @replace.
2017-03-24 (first published: 2015-05-16)
2,426 reads
2017-03-21 (first published: 2017-03-15)
484 reads
Connect to MongoDB on Remote Linux Server with Powershell
Return values from MongoDB on Linux server with Powershell
2017-03-20 (first published: 2017-03-16)
1,179 reads
Find all published tables with row counts and table size
This script will show you all the tables that are being published with sizes.
2017-03-16 (first published: 2017-03-13)
3,521 reads
2017-03-08 (first published: 2017-02-16)
2,001 reads
2017-03-07 (first published: 2017-03-01)
1,251 reads
Corrupt Page Notification
This trigger will send mail notification once a row is written in the suspect pages table
2017-03-03 (first published: 2017-02-21)
517 reads
Missing index with change impact percentage
This script will list all missing indexes with create statements.
2017-03-01 (first published: 2017-02-24)
1,345 reads
Blogs
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
Rambling about Data on Wheels – origins, branding, expansion
By DataOnWheels
I have been asked many times about how the name “Data on Wheels” came...
Think Twice Before Enabling Fabric’s Inbound Network Protection
Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...
Forums
AI Observability Challenges in FinOps as a DBA
Comments posted to this topic are about the item AI Observability Challenges in FinOps...
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers