datetime2 precision changes can round into the next second or date. Compare typed seven-digit values with millisecond and whole-second conversions.
Where a Self-Service Report Actually Gets Its Data
Trace self-service BI numbers through source data, transformations, refresh schedules, credentials, gateways, and the owner of each step.
SQL SERVER – 1500 Posts – A MileStone – Origin of Blog Name Revealed
For my 1500th blog post, I keep a promise and reveal the origin of blog name SQLAuthority.com, inspired by a ColdFusion site called Fusion Authority.
SQL SERVER – Visiting Alma Mater – Delivering Session on Database Performance and Career – Nirma Institute of Technology
I went back to my alma mater, Nirma Institute of Technology in Ahmedabad, to deliver a session on database performance and career. It felt wonderful.
SQL SERVER – Indexed View always Use Index on Table
A table can have only one clustered index, but what about an indexed view built on the whole table? My T-SQL Tuesday post tests which index SQL Server uses.
Accent-Insensitive Searches: Finding Jose and José Together
Build accent-insensitive searches with explicit collations, compare case rules, and index a computed search column for consistent lookup.
SQL SERVER – Encrypted Stored Procedure and Activity Monitor
Can you see the definition of an encrypted stored procedure in Activity Monitor? The answer is No. Here is a quick test that proves it.