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)
970 reads
Scripts
2011-08-05 (first published: 2011-07-23)
2,272 reads
2011-08-04 (first published: 2011-07-25)
3,304 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,218 reads
2011-08-02 (first published: 2011-07-28)
3,051 reads
2011-08-01 (first published: 2011-07-28)
3,208 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,715 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,413 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,762 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,416 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers