This blog post will explore three underused features that can significantly enhance your SQL Server experience. Let us discuss 3 Underutilized Features.
SQL Server Maintenance Techniques: A Comprehensive Guide to Keeping Your Server Running Smoothly
This comprehensive guide explore into some essential maintenance techniques and best practices to ensure your SQL Server deployment.
Tagging Queries With SESSION_CONTEXT to Trace App Users
Tag SQL Server work with SESSION_CONTEXT, read tags in audit defaults and modules, and handle read-only values and pooled connections.
SQL SERVER – Cluster Install Failure – Code 0x84cf0003 – Updating Permission Setting for Folder Failed
A SQL Server cluster install failed with code 0x84cf0003: Updating permission setting for folder failed. Here is why volume mount points can cause it.
SQL SERVER – Unable to Attach Database Files – The PageAudit Property is Incorrect – Ransomware Attack
After a ransomware attack, a client could not attach database files and saw: The PageAudit property is incorrect. Here is what the error means.
How to Enable Files & Folders Level Auditing in SQL Server? – Interview Question of the Week #176
Files kept vanishing from a client’s SQL Server Binn folder. SQL Server cannot track that, so here is how to enable Files and Folders Level Auditing in Windows.
Find Who Dropped a Table by Reading the Transaction Log
To find who dropped a table, read the transaction log for the DROPOBJ transaction and look up the login behind its security ID. This post runs that search on a demo database, shows the default trace as a second source when the log has been truncated, and explains what to do when everyone shares one login.