Bob Pusateri

Finding Install Media on an Azure SQL Virtual Machine

May 23, 2023 · Azure VMs SQL Server Configuration ·

I spun up an Azure SQL Virtual Machine, but I quickly found that PolyBase wasn't installed. To add it I would need the install media of course, but how does one get that in an Azure SQL VM?

How To Remember SQL Clause Ordering

Mar 21, 2023 · T-SQL ·

Share on:

Despite the fact that I've now been writing and tuning SQL statements for over half my life, I still don't feel like I'm an expert. Whenever I need a reminder of this, all I do is ask myself where a GROUP BY clause goes in a SQL query. Does it go before or after WHERE?
Read More

Building A Redirect Service with Cosmos DB and Azure Functions

Mar 6, 2023 · Blogging Cosmos DB Azure Functions ·

Share on:

Building A Redirect Service with Cosmos DB and Azure Functions

Design choices, tooling, and code I used to build a URL redirection service using Azure Cosmos DB and Azure Functions.

New and Improved - Now With Static!

Feb 22, 2023 · Blogging Hugo ·

Share on:

I've been hard at work recently redesigning this blog and converting it from WordPress into a static site. Please don't be too shocked! Get it? Static…shocked… ok that’s my dad joke quota for the day. But honestly it's been a really interesting process that I'm excited to share with you!
Read More

Presenting at PASS Data Community Summit 2021!

Oct 11, 2021 · Speaking PASS Summit ·

Share on:

It's that time of year again – the air is cold and that means it's once again time for PASS Summit. It really doesn't feel like a year has passed! While the pandemic once again means that the summit will be virtual, I'm still looking forward to the opportunities to present and (virtually) meet up with old friends and …

How I Digitally Capture Videotapes

May 5, 2021 · Video Conversion ·

Share on:

For the past few years I have had an ongoing project to preserve all my family's old home movies. This has involved a deep dive into understanding videotapes, VCRs, and video capture technologies that I never thought I would do, but I feel it's necessary to get the highest quality copies of everything I can before …

Video and Questions from my EightKB session!

Feb 2, 2021 · Speaking EightKB ·

Share on:

I was extremely fortunate to be able to present about data compression at the EightKB SQL Server internals conference last week. If you missed my talk in person, you can now view it, as well as the entire day, on YouTube! I was able to answer many questions during the session, but there were a few still left after time …

What Is A SQL Server Big Data Cluster?

Dec 7, 2020 · SQL Server Big Data Clusters ·

Share on:

SQL Server Big Data Clusters (BDCs) are a highly anticipated feature of SQL Server 2019, but what are they – and how can their capabilities best be leveraged? Let's dig a little deeper and find out. When SQL Server 2017 added support for Linux, the groundwork was laid for integrating SQL Server with Spark, HDFS, and …

I’m a Microsoft Certified Trainer!

Aug 12, 2020 · Microsoft Certified Trainer ·

Share on:

I'm very proud to announce that I am now a Microsoft Certified Trainer for 2020-2021! I have benefitted greatly from skilled trainers throughout my career, and am really excited to now be an official member of this group! I'm really looking forward to being a part of the MCT community, and have some big plans for the …

I’m Speaking at Data Community Weekender Europe!

May 1, 2020 · Community Speaking ·

Share on:

I am extremely honored to be speaking at a new online conference – the very first Data Community Weekender Europe! Data Community Weekender Europe was created to address the need for an online data platform conference since so many in-person events around the world have been cancelled as of late. It's taking place on …