Check Up Size Of Each Folder In a Path
If you have any requirement to check the size of each sub-folders in a path, you can use my script.
2016-08-18 (first published: 2015-05-20)
1,688 reads
Scripts
Alter database owner to SA from any user details on all user databases
Alter database owner to SA from any other user details against all user databases
2016-08-17 (first published: 2015-01-13)
1,885 reads
SQL Database Migration: Lower to Higher Version
Database Migration - Lower version of Microsoft SQL Server to Higher version of SQL Server, with complete DBA Guide with Automated Scripts and Steps.
2016-08-16 (first published: 2015-01-29)
7,073 reads
Delete SQL Instance name from default backup location
IF you want to delete the SQL Instance folder of your SQL Named instance after uninstall of your SQL Server Instance, then the script will help you. Note: I did an extra step by using / taking data (INSTALLSHAREDDIR) from your .INI file.
2016-08-15 (first published: 2015-03-23)
733 reads
Function to calculate and return age in text to closest minute between
Calculates and returns age in text to closest minute between 2 datetimes, eg: 2 Years, 4 Months, 12 Days, 4 Hours, 17 Minutes
2016-08-12 (first published: 2012-05-17)
1,757 reads
2016-08-11 (first published: 2015-06-12)
3,676 reads
2016-08-10 (first published: 2015-05-05)
5,530 reads
DynamicDateRangeGenerator
Generates # of dates in before/after current year.
No more hardcoded date ranges.
2016-08-08 (first published: 2016-07-28)
619 reads
Quick SQL Server Configuration Summary Report
This script will detect and display a quick summary of your SQL Server installation.
2016-08-03 (first published: 2015-01-29)
9,575 reads
Calendar Table Function
This iTVF will produce a calendar table that can be used for complex date manipulation; quickly and effeciently
2016-08-02 (first published: 2014-12-29)
8,593 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
Alamat BCA KCP Duta Mas Fatmawati Telp/Wa:0821-8200-233
Tlp/Wa:628218200233 Komplek Pertokoan Duta Mas, Jl. RS. Fatmawati Raya No.8 Blok D1 No. 6,...
Alamat BCA KCP Hasanudin Telp/Wa:0821-8200-203
WA Cs:62 8218200203 Jl. Sultan Hasanuddin Dalam No.43/48, RT.2/RW.1, Melawai, Kec. Kby. Baru, Kota...
Alamat BCA KCP Kemang Telp/Wa:0821-8200-174
Telp/Wa:62 8218200174 Jl. Kemang Sel. No.60, RT.4/RW.2, Bangka, Kec. Mampang Prpt., Kota Jakarta Selatan,...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers