Aaron Bertrand

He/him. Canadian. DBRE @StackOverflow. SQL Server. 25-year MVP. Bruins. Patriots. The Hip. Equality. Ask is not a noun. Friends don't let friends use MERGE.

[Aaron Bertrand @AaronBertrand]

Recent blog posts:

April 2023 – Spring break, work travel, and other stuff
https://t.co/okndMnfqcM

GENERATE_SERIES: My new go-to to build sets
https://t.co/9fglVw1Yl8

Refresh views automatically after schema changes:
https://t.co/prdTqObQDc

[Aaron Bertrand @AaronBertrand]

New blog posts this week.

A few pics from our trip to Powassan, Ontario, for the Can/Am Cup:
https://t.co/0aGbaW6ZSs

And a quick post on using DDL triggers to refresh views automatically:
https://t.co/prdTqObQDc

[Aaron Bertrand @AaronBertrand]

[Blog] : Part 3 of visual calendars, now covering MySQL

https://t.co/iX9ryEShZO

[Aaron Bertrand @AaronBertrand]

@sql_williamd Not me. It was a question on dba.

[Aaron Bertrand @AaronBertrand]

Because I like self-inflicted headaches, I took a stab at simulating TRY_PARSE(... AS date) in SQL Server 2008.

https://t.co/pKd3VolU5o

[Aaron Bertrand @AaronBertrand]

@ObsidianDev The entire series of bad decisions (eg every decision) since he took over. Name one way twitter has changed for the better?

[Aaron Bertrand @AaronBertrand]

He should just shut this web site down.

[Aaron Bertrand @AaronBertrand]

@pamanes7 Why not? If I have an M1 (either by choice or because it is what work offered me, or both), and I have to work locally/offline on some stored procedures someone implemented, and they have FORMAT() for example, a container is much lighter weight than unreliable VMs. YMMV.

[Aaron Bertrand @AaronBertrand]

[Blog] : Regular SQL Server on Apple Silicon? Yes you can!

https://t.co/jYdOOzQM4X

[Aaron Bertrand @AaronBertrand]

Busy week for the blogger in me!

1. Bunch of SQL Server updates:
https://t.co/Lhamo51f4J

2. I am now getting ~5 Gbps to my laptop:
https://t.co/GZe5EpkGg4

3. Part 2 of pretty calendars from SQL:
https://t.co/OSOsz0zEVK

4. My first post on Simple Talk:
https://t.co/JteQdEItHf

[Aaron Bertrand @AaronBertrand]

I blogged about Gord today:
https://t.co/dgnBKmgQD3

Earlier in the week, my first tip in a series on generating pretty CSS calendars for blog archives:
https://t.co/aaqlVfpoto

[Aaron Bertrand @AaronBertrand]

@pkanavos Not in the slightest, seems like bulk insert has some margin of error and is forgiving / doing some kind of wraparound on the values. That is not good, whatever it is.

[Aaron Bertrand @AaronBertrand]

[Blog] : T-SQL Tuesday #158 : Worst Practices

https://t.co/DVuYn5VAbq

/cc @SQLDoubleG #sqlblog #sqlserver #TSQL2sDay

[Aaron Bertrand @AaronBertrand]

[Blog] : And then there were shirts… the story behind new SQLBlog-branded clothing (with proceeds going to The Trevor Project and Black Lives Matter).

https://t.co/2qblbeZ13D

[Aaron Bertrand @AaronBertrand]

@SirFisch I don’t know, the number of successful challenges I see (and the number of times they still get it wrong even after a review, and the lame explanations), and the inconsistency (Kelce vs. Hunter Henry), leads me to believe I’d like the sport a lot less with zero accountability.

[Aaron Bertrand @AaronBertrand]

So, basically, they didn’t even look at it.

[Mike Reiss @MikeReiss]

Pool report with NFL Senior VP of Officiating Walt Anderson on the upheld Keelan Cole touchdown — nothing clear and obvious in replay to overturn.

[Aaron Bertrand @AaronBertrand]

@ElfJesuit @MikeGiardi @scottzolak Ha, are you seriously suggesting a rule that benefitted the Patriots 20 years ago (and also went against them earlier that same season) makes it ok to continue making worse and worse calls today? Ok.

[Aaron Bertrand @AaronBertrand]

Don’t get me wrong. The Patriots deserved to lose that game. What a goofy Benny Hill sequence, for what, to avoid overtime? Why? I’d rather have let Folk try a 70-yarder because why not?

But they never should have been in a tie at the end in the first place; that’s on the refs.

[Aaron Bertrand @AaronBertrand]

@spaghettidba Where’s the hole for your head to pop through? Surely you don’t see the road *through the windshield*