Thursday, 19 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.

Tuesday, 10 November 2015

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.