Avoid Transaction Logs volume from filling
Script for preventing the volumes of the transaction logs from filling.
2016-01-27 (first published: 2014-05-13)
3,528 reads
Scripts
Query Performance Report
The procedure created by this script rolls up the collected query execution statistics and groups them daily by the plan hash value.
2016-01-20 (first published: 2015-05-13)
5,468 reads
Hassle free parameters in dynamic SQL
An alternative solution to passing parameters to sp_executesql.
2016-01-19 (first published: 2014-04-23)
4,155 reads
SQLPS Meets the DMV's
This is a great wrapper for your DMV's to automate a quick performance metric capture.
2016-01-12 (first published: 2016-01-06)
468 reads
SQL Server System Report
Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more.
2016-01-11 (first published: 2010-05-11)
16,106 reads
Adaptative Files Autogrow
Set minimal autogrow values for datafiles and logfiles depending on the file size, thresholds for all databases
2016-01-07 (first published: 2015-06-08)
1,131 reads
Mirror Partner Agent Job To Auto Kick Back to Primary
Query the mirror instance via agent job to auto kick back to primary. If db is in suspended state will resume mirroring.
2016-01-05 (first published: 2015-12-23)
477 reads
Fix Orphan Users for Instance Migration
Use provided script to fix orphan users for all databases after Instance Migration. Tested on SQL 2014.
2016-01-04 (first published: 2015-12-17)
1,620 reads
Index Breakdown
Provides a robust breakdown of all indexes contained within a database allowing for quick analysis and identification of inefficient, redundant, unused, bloated, stale, and / or poorly architected indexes.
2015-12-31 (first published: 2013-11-08)
7,218 reads
Failed and Successful Login Auditing Using xp_readerrorlog
Script uses undocumented extended stored procedure xp_readerrorlog to find failed logins (grouped) and last successful login
2015-12-30 (first published: 2015-12-15)
1,995 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers