2016-11-22 (first published: 2016-11-11)
835 reads
Scripts
Taking backup of the databases to the Active server alone
If you have Always On and need to stop running database backups to the stand by server, use the script.
2016-11-21 (first published: 2016-11-01)
285 reads
Generate add / alter script for missing / different type columns
This query generate add/alter script for missing or different columns. Execute on source database and copy resultset. Execute generated script on any database (may be all customer databases) Missing columns will be created and different types will change as source schema.
2016-11-18 (first published: 2016-11-07)
915 reads
Equivalent Oracle's INSTR Function in SQL server
Oracle Built in Function INSTR is a great function if you wish to locate a string or a subset of string in the nth place.
2016-11-17 (first published: 2016-11-04)
1,423 reads
Converting values into Rows
Script describe one of the way to divide values into rows by using any specified dividing value.
2016-11-15 (first published: 2016-11-04)
837 reads
2016-11-14 (first published: 2016-11-06)
710 reads
Function - Word count in a sentence
The function (Inline function) is used to determine the word count in a textual/string input.
* Compatible from SQL Server 2012 and up.
2016-11-11 (first published: 2016-11-04)
491 reads
Automatic restore database to different server from backup file
if you get bunch of back up files ( full backup and transaction log backup, you need restore those database to different server, you can use my stored procedure to genereate the restore command
2016-11-10 (first published: 2014-12-17)
2,558 reads
Build restore scripts dynamically
This script will build restore scripts with the most recent full backup and all t-log backups since, for each user database in the SQL instance.
2016-11-09 (first published: 2016-11-01)
1,370 reads
Monitor your website or any URL from SQL Server
You can monitor your web application by given its url and by creating the job in sql server 2005 which will send you the mail when ever your website is down.
2016-11-07 (first published: 2009-06-17)
11,950 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