The licensing structure has evolved to reflect advances in technology and diverse use cases. Below are the primary licensing models available:
SQL SERVER – Find All The User Defined Functions (UDF) – Part 2
Madhivanan shared another way to find all the user defined functions in a database, using information_schema.routines. Here is his short script.
Installing SQL Server on Linux
Installing SQL Server on Linux involves supported packages, mssql-conf setup, service checks, and an understanding of Windows differences.
Reading the SQL Server Error Log Properly
Read the SQL Server error log for startup details and incident context, filter it with T-SQL, and cycle files without losing needed history.
SQL SERVER – UDF to Return a Calendar for Any Date for Any Year
Reader Dan Golden built on my weekly calendar function to create a UDF to return a calendar for any date for any year. I fixed a small first and last week bug.
Checking XACT_STATE Before COMMIT or ROLLBACK in a CATCH Block
XACT_STATE separates transaction validity from the decision to retain work. Two isolated examples show a doomed transaction and a committable one, both with deliberate errors. Clean up on the same connection and respect the caller’s transaction ownership.
Rolling Back a Cumulative Update Safely
Rolling Back a Cumulative Update needs backups, setup evidence, a tested uninstall path, and special care for databases changed after patching.