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)
851 reads
Scripts
2016-11-14 (first published: 2016-11-06)
721 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)
508 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,564 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,380 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,953 reads
2016-11-03 (first published: 2014-10-07)
2,619 reads
Script All Logins / Users / and Roles
This Script Generates A script to Create all Logins, Server Roles, DB Users and DB roles on a SQL Server.
2016-11-02 (first published: 2013-10-31)
33,380 reads
View for Ola Hallengren CommandLog
Add 3 columns, duration in seconds,Pagecount and fragmentation. For people like me who don't enjoy querying XML.
2016-10-31 (first published: 2015-11-12)
3,419 reads
2016-10-28 (first published: 2016-10-05)
23,073 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Hyperscale Replicas II
Comments posted to this topic are about the item Hyperscale Replicas II
Practical Reporting Queries with CROSS APPLY (Part 3)
Comments posted to this topic are about the item Practical Reporting Queries with CROSS...
Your Favorite Quotes
Comments posted to this topic are about the item Your Favorite Quotes
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers