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,299 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,784 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,719 reads
2014-11-11 (first published: 2014-07-25)
2,715 reads
2014-11-10 (first published: 2014-10-01)
1,380 reads
2014-11-06 (first published: 2014-09-02)
2,509 reads
2014-11-04 (first published: 2014-10-06)
1,394 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
SSL/TLS Cert Validity Periods Decreasing
Hi, to all of you who are using CA certs on SQL Server boxes...
It's Never Just One Thing
Comments posted to this topic are about the item It's Never Just One Thing
Calculating Min-Max Normalization in PowerBI
Comments posted to this topic are about the item Calculating Min-Max Normalization in PowerBI
Question of the Day
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers