Anthony MattasAn Open Letter to the Ohio Legislature on the EdChoice ExpansionDear Senator Coley and Representative Lang2 min read·Dec 12, 2019----
Anthony MattasSmart Home, Insecure Home.At 7:00am EST on October 21, 2016 internet users began having connectivity problems to a large number of major internet properties…5 min read·Jul 3, 2018----
Anthony MattasRebooting all of your Sonos devices[UPDATE 12/07/2018: Sonos has now discontinued the reboot functionality through their UPnP API, so this will no longer work.]3 min read·Jun 19, 2018----
Anthony MattasCreating Partitions Using Dynamic SQLRecently I wrote a post on partition switching, however, one of the big pieces I left out was how to go about properly partitioning your…3 min read·Sep 8, 2012----
Anthony MattasIntroduction to Partition SwitchingQuite often when building a data warehouse we are given the challenge of having to delete existing data before importing the latest and…3 min read·Aug 8, 2012----
Anthony MattasIndexing Data Warehouses in SQL 2012This week I was at the Detroit MTC for a SQL Server 2012 release event where Rick Brewis (Microsoft) and my friend Josh Fennessy…5 min read·Apr 19, 2012----
Anthony MattasChecking IP Against CIDR Netmask with T-SQLI’ve been in the process of improving the functionality in ASLB, one of the improvements I have been working on adding is functionality for…2 min read·Jan 28, 2012----