ConvertFrom-Gzip

Not too long ago, I needed to figure out how many total lines I had in a series of files.  Normally, this would not be difficult:  I can use the Measure-Object Powershell cmdlet with the -Line parameter and get a line count.  The tricky part here, though, was two-fold:  first, I had approximately 9400 files to…

Cross-Database Memory Optimized Queries Still Not Available

In SQL Server 2014, we learned that memory-optimized tables cannot join to tables outside the current database.  I wanted to see if this had changed in SQL Server 2016 CTP 3.2. My result: (6 row(s) affected) Msg 41317, Level 16, State 5, Line 24 A user transaction that accesses memory optimized tables or natively compiled modules…

Don’t let the door hit you in the ass on the way out?

Jason Cole of the Bleacher Report suggests that the firing of Ray Farmer is imminent, whereas Mike Pettine will be retained for at least another season. I, most notably, turned on Ray Farmer a few weeks ago when he tried to trade Joe Thomas. That said, I'm still not convinced the right guy is going to…

New Talk Planned

I'm introducing a new talk for 2016:  Securing SQL Server.  Here's my abstract: A default SQL Server installation is reasonably secure, but "reasonably secure" doesn't cut it anymore in an era in which one bad line of code, one week password, or one open port can result in your customer database ending up on Pastebin.…

Buffalo’s Failed Season

Coming into 2015, Buffalo fans were hopeful that Rex Ryan would be the difference maker and lead Buffalo into their first playoff bid this millennium.  And if you told me that Buffalo would have the 7th-rated pass offense and 4th-rated pass offense, I'd say there would be a good chance that they were fighting the…

A Day In The Life

Via Paul Turley, I saw this FlowingData analysis of how a sample of Americans spend their days.  Do click through because it's a beautiful example of how visualization can work.

Azure ML: Custom Data Sets

Last time around, I built a simple Azure ML experiment based on flight delay data made available to us as a Microsoft sample.  Today, I want to load a custom data set and build an experiment against it. The Data Set I'm using SQL Saturday data for this demo.  I came up with a set of…

Azure ML: Getting Started

Machine Learning Setup Go to your old Azure portal.  Then, go to New --> Data Services --> Machine Learning --> Quick Create.  You'll need an Azure account and an Azure storage account. Once we have our workspace, we can connect to Azure ML Studio to continue. Build An Experiment We want to build the following Azure…