Posts

Showing posts from November, 2015

Stop People From Changing Tables with This One Trick

I received today's posts from Brent Ozar, I feel it is very interesting, LOL: Brent Ozar says: Stop People From Changing Tables with This One Trick Brace yourselves. Our Black Friday sale is coming. Developers hate his bad idea jeans: CREATE VIEW dbo.StopThemDead WITH SCHEMABINDING AS SELECT COUNT(*) FROM dbo.Table1 UNION ALL SELECT COUNT(*) FROM dbo.Table2 UNION ALL.... Presto, the schemabinding option means no one can change the underlying tables. (At least, until they figure out about your view.) Obligatory disclaimer: seriously, this is a really bad idea. But it’s hilarious.

Lily will be absent from Michigan Scholastic Club Championship

Though Lily had perfect 5/5 score being 1st place under K-8 Section in 2013, 2014, she will be absent from this year's Michigan Scholastic tournament, I am too tired to bring her to such tournaments. Windsor will still send a huge strong team to participate all k-3, k-5, k-8,k-12 sections. Good luck to every Windsor players.