2017-02-28 (first published: 2015-06-22)
2,118 reads
Scripts
Getting resource content from blocked process report
This script serves to display the content of the waiting resource. It is divided in two parts. In first one I'm using t-sql, and in second one I accomplished the same task using SQLCRL.
2017-02-27 (first published: 2017-02-21)
1,297 reads
Check if xp_cmdshell is turned on and flip the bit
The code works well for an automation process that needs to have xp_cmdhsell turned on.
2017-02-22 (first published: 2017-02-13)
1,575 reads
2017-01-31 (first published: 2017-01-30)
806 reads
2017-01-30 (first published: 2017-01-26)
19,642 reads
Query details about objects allocated in TEMPDB.
TEMPDB doesn't have to be a black box. Know what objects and processes are causing it to bloat in size.
2017-01-30 (first published: 2016-12-29)
2,241 reads
Powershell Script to find a SQL\Windows login in SQL Server
This script will help you to find out whether a particular id (SQL or Windows ID) is present in the SQL Server
2017-01-26 (first published: 2017-01-24)
653 reads
TDE Decryption Timer Script
Decryption Timer to let you know when the removal of encryption for a TDE encrypted database has completed to perform a backup of the data after masking.
2017-01-24 (first published: 2017-01-18)
457 reads
Generic, parameterised, create DB script
A script to be used as part of development deployments where new databases are required, so as to provide standardisation.
2017-01-23 (first published: 2017-01-18)
470 reads
Backup databases in an Availability Group
Use this script to backup databases based on their role in an availability group
2017-01-12 (first published: 2017-01-07)
687 reads
Blogs
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Getting Started with Azure SQL Developer on Macbook
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
AI Experiments: Claude Solved a DAB Issue
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Forums
ALAMAT KANTOR BCA KCP Klender Telp:083831618008
WhatsApp:0838-3161-8008 Jl. I Gusti Ngurah Rai No.8 A-B, RT.8/RW.6, Wil, Kec. Duren Sawit, Kota...
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers