Serial ID Auto Generation
Scripts used to create the functionality to auto-generate your very own customized serial IDs.
2010-02-22 (first published: 2010-02-04)
1,849 reads
Scripts
2010-02-15 (first published: 2010-01-18)
23,050 reads
Database Users And Associated Database Roles
This script basically retreives all database users thier database roles for a database.
2010-02-10 (first published: 2010-01-20)
3,486 reads
2010-02-08 (first published: 2010-01-13)
4,159 reads
2010-02-05 (first published: 2010-01-18)
1,064 reads
Script Table or View structure
This code will let you script a Table or Views structure for source control.
2010-02-02 (first published: 2010-01-12)
2,202 reads
Listing Subscribed SSRS Reports including Parameters & their Values
This script will allow user to analysis their Subscribed Reports.
2010-02-01 (first published: 2010-01-11)
2,263 reads
Object Search for Sql Server 2005
This script will search databases, tables, columns, stored procedures for text.
2010-01-28 (first published: 2008-12-21)
1,286 reads
Display Rows Vertically or Alphabetically
Display a row vertically when a table has hundreds of columns to avoid scrolling.
2010-01-21 (first published: 2009-12-30)
3,304 reads
datetime precision
Accuracy and precision go hand-in-hand. This script helps trim date values to whatever size is stored in a table's column.
2010-01-20 (first published: 2009-12-21)
1,501 reads
Blogs
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Forums
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Upgrading Admin Queries
Comments posted to this topic are about the item Upgrading Admin Queries
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers