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.
What TDS Is and Why It Matters to You
What TDS is becomes practical when a SQL Server connection fails: it carries login and query traffic, packet settings, and encryption negotiation.