Object names in SQL Server can be up to 128 characters, but local temp tables stop at 116. Guest author Balmukund Lakhani explains this limit for Temp Objects.
Designing a Simple ETL Framework
An ETL framework in SQL Server needs a small set of configuration, run logs, restart checkpoints, and alerts that operators can trust.
SQL SERVER – Microsoft Certification – SQL Server 2012
Microsoft Certification changed for SQL Server 2012. A simple map of the new MCSA and MCSE path and of exams 70-461, 70-462 and 70-463.
SQL SERVER – Introduction to SQL Server Security – A Primer
A primer on SQL Server Security terms with a simple story: Tom needs Read access to the Financial Folder. Learn what a securable, principal and permission are.
SQL SERVER – Working with FileTables in SQL Server 2012 – Part 3 – Retrieving Various FileTable Properties
Part 3 of my FileTables series for SQL Server 2012: queries to tell files from folders and find root paths, path locators and relative paths.
Finding the Worst Query in Five Minutes With Query Store
Find the worst query with Query Store totals, compare CPU and duration over the last day, inspect plans, and choose the first tuning target.
JSON_PATH_EXISTS and Typed ISJSON in SQL Server 2022
Validate payloads with JSON_PATH_EXISTS and typed ISJSON in SQL Server 2022, distinguish null from missing, and enforce a clear contract.