TRY_PARSE needs an explicit culture when punctuation has a specific numeric meaning. I keep that culture beside the source text. A successful conversion alone cannot establish that the intended number was read.
SQL SERVER – T-SQL Script for FizzBuzz Logic
FizzBuzz is a common interview puzzle: print 1 to 100, with Fizz for multiples of three and Buzz for five. Here is my T-SQL answer using a WHILE loop.
SQL SERVER – 2008 – 2005 – Rebuild Every Index of All Tables of Database – Rebuild Index with FillFactor
A quick script to rebuild every index of all tables in a database with a fillfactor of 80, plus a short note on what fillfactor does to leaf-level pages.
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.
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.







