PolyBase and SQL Server external tables expose CSV and Parquet files through schemas, while query plans show whether filters reduce remote work.
Time Ago Labels: Showing ‘5 Minutes Ago’ From a Timestamp
Learn time ago labels in SQL Server with practical examples, clear checks, common traps, and guidance for your own database.
SARGable Date Filters: Stop Wrapping Columns in Functions
Write SARGable date filters as half-open ranges for years, months, days, and rolling windows, then compare plans and logical reads.
SQL SERVER – Importance of User Without Login – T-SQL Demo Script
A T-SQL demo script for a user without login: create the user, impersonate it, check its access, revert and then grant permissions, one step at a time.
Renaming a Column Safely Everywhere It Is Used
Renaming a column safely requires finding SQL and application references, applying sp_rename, refreshing modules, and testing every consumer.
SQL SERVER – Preserve Leading Zero While Coping to Excel from SSMS
Want to preserve leading zero values when you paste SSMS results into Excel? The fix is in Excel: format the cells as Text first, and the zeros stay.
SQL SERVER – Importance of User Without Login
Some questions are very open ended. Here is one question I was asked in recent User Group Meeting about user without login.