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,600 reads
Scripts
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,189 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,978 reads
2015-12-29 (first published: 2015-12-09)
1,988 reads
Add empty first step for every job
This script adds empty first step for every job for easier job history viewing.
2015-12-28 (first published: 2015-12-10)
1,867 reads
2015-12-25 (first published: 2015-12-17)
1,709 reads
String Search
Search for a string value within columns of data types CHAR, NCHAR, NTEXT, NVARCHAR, TEXT, VARCHAR, XML.
2015-12-24 (first published: 2012-03-19)
6,761 reads
Object Search
Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.
2015-12-23 (first published: 2009-04-29)
5,036 reads
2015-12-22 (first published: 2012-11-26)
3,396 reads
Know read and write ratio before you tune database performance
A script to get the user table query ratio and update radio,etc
2015-12-21 (first published: 2015-12-11)
1,791 reads
Blogs
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...
Audit – Security Compliance Frameworks (Part 1)
By Vinay Thakur
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Forums
Alamat Kontak Bank BCA KCU MALANG Telp:08218154392
WA CS:08218154392 Jl. Jenderal Basuki Rahmat No.70-74, Klojen, Kec. Klojen, Kota Malang, Jawa Timur...
ALAMAT KANTOR BCA KCU PONTIANAK Telp:083831618008
WhatsApp:0838-3161-8008 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...
Can You Really Downgrade from Enterprise to Standard and Save Thousands? Here's What Happened
Comments posted to this topic are about the item Can You Really Downgrade from...
Question of the Day
Limiting Checkpoints
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers