2014-11-19 (first published: 2014-10-29)
1,139 reads
Scripts
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,766 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,708 reads
2014-11-11 (first published: 2014-07-25)
2,684 reads
2014-11-10 (first published: 2014-10-01)
1,363 reads
2014-11-06 (first published: 2014-09-02)
2,495 reads
2014-11-04 (first published: 2014-10-06)
1,386 reads
2014-10-29
1,187 reads
Extract SQL Server Key details
Extract SQL Server Name, Instance Name, Service Account details, startMode and ServiceState details with Powershell.
2014-10-27 (first published: 2014-10-13)
6,134 reads
Retrieve instance-wide index level fill factor information
This script retrieves all fill factor information for all indexes (clustered and non) when it is not set to 0 or 100
2014-10-24 (first published: 2014-10-14)
635 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers