Articles

Why I Chose Georgia Tech's OMSCS Program

Why I Chose Georgia Tech's OMSCS Program

In the tech industry, continuous learning isn't just optional; it's essential. After several years in the industry, I found myself at a familiar crossroads: how do I advance my knowledge and credentials while maintaining my career momentum? The answer came in the form of Georgia Tech's Online Master of Science...

New Beginnings: From Classrooms to Cloud Computing

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

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 EdChoice...

Smart Home, Insecure Home

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 was unusual...

Rebooting all of your Sonos devices

Rebooting all of your Sonos devices

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 Sonos zones on your network at one time. Fortunately, Sonos provides a bunch of advanced capabilities through a web interface. One of...

Creating Partitions Using Dynamic SQL

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

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't...

Indexing Data Warehouses in SQL 2012

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 increases...

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 which...

You've reached the end of all articles.