Comprehensive Backup Script
These scripts were generated to standardize our SQL backup environments, and to remove backups from Maintenance Plans.
2011-12-22 (first published: 2008-01-29)
3,451 reads
Simon Facer
- Interests: My kids, building furniture, DIY, garden ponds, SQL Server and PDW
Proc to Rename a file
A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.
2011-10-28 (first published: 2008-05-13)
2,955 reads
Audit SQL Logins
We have auditors in the building, looking at our security (amongst other things). So, we needed an easy way to generate a listing of the SQL logins, and the permissions into each database on our servers (over 70 if them).This script will generate the listings the auditors wanted.
2007-04-02 (first published: 2007-03-07)
5,624 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Katamso Medan TELP/CS:083135765355
Whatsapp:083135765355 Jl. Brigjend Katamso No.56 B-C, A U R, Kec. Medan Maimun, Kota Medan,...
BCA KCP Kramat Jaya Baru Telp:Cs.WA:0831•7943•7466
WhatsApp 0831•7943•7466 Jl. Percetakan Negara II No.16 B-C, RT.3/RW.3, Johar Baru, Kec. Johar Baru,...
BCA KCP BoulevardTelepon 083110611866
WhatsApp 083110611866Kawasan Mega Mas, Jl. Piere Tendean No.8 Blok E, Kota Manado, Sulawesi Utara...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers