Aaron Bertrand

Aaron Bertrand has asked 2 questions and find answers to 728 problems.

Stats

About

Proud father of two beautiful girls
🇨🇦
Mac user
24-time MVP
blogger at sqlperformance.com, mssqltips.com, and sqlblog.org
OSS contributor (e.g. Brent Ozar's First Responder Kit, Andy Mallon's DBA Database, and my own ParamParser)
Cheer for:
- 🏈 ➜ Patriots
- 🏒 ➜ Bruins
- 🎾 ➜ Nadal
- 🥌 ➜ Me

Aaron Bertrand questions

How do I get date/time information from a TIMESTAMP column?
Improve GeSHi syntax highlighting for T-SQL

Aaron Bertrand answers

Ignore Two Columns in Update Trigger
Can a database be refactored in SQL Server?
SQL Server INSTEAD OF INSERT trigger failure
Pivot to obtain EAV data
retrieve the most recent record for each customer
Finding all views that are using linked server
Different result running a query in SQL Server and from C#
Calculate rank based on Consecutive Dates (Return to 1 if there is a gap days between dates)
group by in sql combining values [closed]
SQL Server check constraint failing on correct input