Set up FileTable prerequisites, create a Windows-accessible file namespace, query stored file metadata, and compare simpler path storage.
SQL SERVER – Finding Different ColumnName From Almost Identitical Tables
A reader had archive and current tables in pairs, but the schemas drifted apart. Here is my way of finding different ColumnName values in almost identical tables.
Audit Columns From Day One: CreatedAt, UpdatedAt and Who Changed It
Add audit columns with UTC timestamps and trusted change identities, maintain updates in procedures, and know when history is needed.
A Multi-Tenant Schema With a TenantId Column: Keys, Indexes and Safety
Design a multi-tenant schema with composite keys, tenant-first indexes, trusted session context, and row-level security checks.
Backing Up msdb: Jobs, History and Mail Live There
Your user databases come back, but the jobs and mail setup do not. A short demo of what lives in msdb and how to protect it.
SQL SERVER – Find First Non-Numeric Character from String
No built-in function finds the first non-numeric character in a string, so I use PATINDEX. Here is a quick script with sample data you can try.
SQL SERVER – 2012 – List All The Column With Specific Data Types in Database
An updated SQL Server 2012 script to list every column with specific data types in a database, including user data types, schema and table names.