Modify All Database Data and Logfile Names
This script modifies all dtabase .mdf and .ldf to have a standardized name of DatabaseName_Data and DatabaseName_Log.
2011-08-08 (first published: 2011-07-28)
953 reads
Scripts
2011-08-05 (first published: 2011-07-23)
2,241 reads
2011-08-04 (first published: 2011-07-25)
3,219 reads
SQL Server Security Extract (Reverse Engineer) for ALL Databases
These scripts will extract security for Windows Logins, Database Users, Roles, Objects and SQL Logins.
2011-08-03 (first published: 2011-07-28)
2,191 reads
2011-08-02 (first published: 2011-07-28)
3,027 reads
2011-08-01 (first published: 2011-07-28)
3,191 reads
Changing Primary key names to standard naming convention across the DB
This script will rename the Primary keys to standard notation - PK_TableName
2011-07-29 (first published: 2010-02-09)
1,694 reads
A simple SysProcess query
A quick and simple SysProcess query which will display most of the common parameters of interest.
2011-07-28 (first published: 2011-07-23)
1,390 reads
Verify SQL Server Login and Login Settings
Verifies that a specified login name exists and has correct settings.
2011-07-27 (first published: 2011-07-11)
1,739 reads
Script to get Server Info
This script will gather a number of Server Information items that are useful in baselining a SQL Server.
2011-07-25 (first published: 2010-01-19)
7,385 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers