Using sp_help, sp_helpindex, sp_helptext, and sp_spaceused gives a quick SQL Server tour before you reach for catalog views.
Estimating Table Growth for Next Year From Backup History
Estimate table growth with monthly full backup history, a twelve month forecast, and table space checks that separate evidence from guesses.
SQL SERVER – Generate A Single Random Number for Range of Rows of Any Table – Very interesting Question from Reader
A reader asked how to get a single random number for a set of rows, like one per PostalCode. I compare NEWID() for each row with RAND() for a whole set.
Tracking Which Updates Every Server Has
Tracking Which Updates each SQL Server runs takes a dated inventory table, SERVERPROPERTY snapshots, and a report of instances behind the target.
Connecting to SQL Server From Java, Python and .NET
Choose a SQL Server driver for Java, Python, or .NET, then verify encryption, authentication, pooling, and the application's connection.
Connecting Excel to SQL Server Safely
Connecting Excel to SQL Server safely means a narrow read-only view, a scoped login, controlled refresh load, and no saved password in the workbook.
Securing Linked Servers
Securing linked servers requires explicit login mappings, limited RPC settings, remote privilege checks, and dependency ownership.