Function for Proper Case - Most easiest way
This function is used to manage the alphabet case, which means the first letter of all the words will be in caps.
2014-11-26 (first published: 2014-11-03)
1,301 reads
Scripts
Identify Missing Sequence/Identity Numbers
This script is used to identify the missing sequence numbers or identity numbers.
2014-11-20 (first published: 2014-10-29)
1,123 reads
2014-11-19 (first published: 2014-10-29)
1,143 reads
Upload Backup Files to Amazon S3
This script will upload the latest backup files to an AWS S3 bucket
2014-11-14 (first published: 2014-09-14)
1,786 reads
Report on existing user connections
List user connections and possibly any linked server connections older than 1 hour
2014-11-13 (first published: 2014-10-22)
1,720 reads
2014-11-11 (first published: 2014-07-25)
2,721 reads
2014-11-10 (first published: 2014-10-01)
1,381 reads
2014-11-06 (first published: 2014-09-02)
2,510 reads
2014-11-04 (first published: 2014-10-06)
1,398 reads
2014-10-29
1,198 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers