New Beginnings: From Classrooms to Cloud Computing Summer is almost over, pumpkin-spiced lattes are already sneaking in, and children are strapping on their backpacks as they head back to school. My household is no exception to the back-to-school buzz. As my kids gear up for another academic year, so do I, albeit in a slightly different arena.
An Open Letter to the Ohio Legislature on the EdChoice Expansion Dear Senator Coley and Representative Lang, I’m writing today out of extreme concern with the recently updated list of public schools eligible for EdChoice scholarships. Although I live in a district now eligible for EdChoice scholarships and send my children to a private school, I do not support the
Smart 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 including Netflix, Twitter, Spotify, Amazon.com, as a key internet service provider was hit by a distributed denial of service attack facilitated by the Mirari botnet. The attack
Rebooting 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.] I’m an avid Sonos user. I’ve used their devices for many years now and love the platform, sans one feature — the ability to reboot all of your
Creating Partitions Using Dynamic SQL Recently I wrote a post on partition switching, however, one of the big pieces I left out was how to go about properly partitioning your database tables. Unfortunately, partitioning strategy can vary greatly, but generally your partitions will be aligned with your clustered index (quite frequently date). I recommend reading
Introduction to Partition Switching Quite often when building a data warehouse we are given the challenge of having to delete existing data before importing the latest and greatest. In an ideal world we would just insert new records and be on our way, but quite often that is not the case. Deleting data isn’
Indexing Data Warehouses in SQL 2012 This week I was at the Detroit MTC for a SQL Server 2012 release event where Rick Brewis (Microsoft) and my friend Josh Fennessy (BlueGranite) presented on the new functionality of SQL Server 2012. One of the highlights Rick’s presentation was the new Columnstore Index, and the huge performance
Checking IP Against CIDR Netmask with T-SQL I’ve been in the process of improving the functionality in ASLB, one of the improvements I have been working on adding is functionality for ASLB to be smart enough to understand geo-location in a large network. However in doing so I went through many iterations on how to identify
