2019-05-03 (first published: 2015-03-29)
1,780 reads
Scripts
Getting transaction log space usage statistics for all databases.
Easy way to get the TLOg space Usage details
2019-05-03 (first published: 2015-11-19)
1,389 reads
Job Step Log Output file path
If you have a requirement to carefully have the output file against each sql agent job step, you can use this script. If incase, there are many sql agent jobs and by any reason if any of the step does not have proper o/p file, this script can automatically create the o/p file.
2019-05-03 (first published: 2016-05-20)
1,555 reads
Kill all USer Sessions before starting to restore a Database
If you have a requirement to Kill all USer Sessions before starting to restore a Database, you may use this script
2019-05-03 (first published: 2015-07-08)
2,152 reads
Killing User Connection(session) connected to the Database.
The script will be helpful to kill all the user sessions before performing the refresh of the database.
2019-05-03 (first published: 2011-03-29)
2,657 reads
List Out All User Defined Triggers
List Out All User Defined Triggers, along with the database where the triggers are disabled. is_ms_shipped = 1 denotes that its an user written trigger.
2019-05-03 (first published: 2015-07-07)
842 reads
2019-05-03 (first published: 2015-09-13)
1,929 reads
PowerShell Query to remove backup folders against multiple servers
Remove backup folders from multiple servers.
2019-05-03 (first published: 2014-12-09)
621 reads
Query to check whether my Full Database Backup is running fine.
The query will help to find whether my database backup to a specific instance of SQL Server is running fine. If HH> 1, this would signify that the backup is running, else this is a failure.
2019-05-03 (first published: 2012-08-25)
1,244 reads
Query to Delete all Folders, Sub-Folders and Files located in a Path
A script to help you cleanup Files/Folders & Sub-folders.
2019-05-03 (first published: 2015-07-30)
71 reads
Blogs
T-SQL Tuesday #199 Invitation: Back to on-prem?
It’s time for T-SQL Tuesday again! And we’re almost to number 200! T-SQL Tuesday...
Data Skew in Data Engineering: What It Is and How to Fix It
You kick off a distributed job expecting it to finish in minutes — but...
Error Deploying GraphQL in Fabric: dm_exec_describe_first_result_set
A while ago we suddenly had an error while trying to deploy one Fabric...
Forums
BCA KCP Tumpang Call Center/Telpon 0818-740-011
WhatsApp:0818-740-011 Jl. Raya Tumpang No.1, Ledoksari, Tumpang, Kec. Tumpang, Kabupaten Malang, Jawa Timur 65156
BCA KCP Singosari Call Center/Telpon 0818-740-011
WhatsApp:0818-740-011 Jl. Raya Singosari No.91 A, Losari, Kec. Singosari, Kabupaten Malang, Jawa Timur 65153
BCA KCP Blimbing Call Center/Telpon 0818-740-011
WhatsApp:0818-740-011 Jl. Ahmad Yani No.183, Purwodadi, Kec. Blimbing, Kota Malang, Jawa Timur 65125
Question of the Day
Secure Cached Plans
The DMV, sys.dm_exec_cached_plans, contains rows for each cached plan on an instance. In Azure SQL Database, not every used has rights to every database, as there does exist an instance behind each database. How is security handled for this DMV in Azure?
See possible answers