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
Alamat Kontak Bank BCA KCP Riau Telp:08218154392
WA CS (08218154392) Jl. Laks Jl. L. L. R.E. Martadinata No.92, Cihapit, Kec. Bandung...
Alamat Kontak Bank BCA KCP Banda Telp:08218154392
WA CS (08218154392) Jl. Banda No.39, Citarum, Kec. Bandung Wetan, Kota Bandung, Jawa Barat...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Question of the Day
DBCC CHECKDB Limits III
On SQL Server 2025, does DBCC CHECKDB support Memory-Optimized tables?
See possible answers