Bob Pusateri
open-menu closeme
About
Community
Contact
twitter mastodon linkedin github rss
  • How To Remember SQL Clause Ordering

    calendar Mar 21, 2023 · T-SQL  ·
    Share on: twitter facebook linkedin copy
    How To Remember SQL Clause Ordering
    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

    calendar Mar 6, 2023 · Blogging Cosmos DB Azure Functions  ·
    Share on: twitter facebook linkedin copy
    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.


    Read More
  • New and Improved - Now With Static!

    calendar Feb 22, 2023 · Blogging Hugo  ·
    Share on: twitter facebook linkedin copy
    New and Improved - Now With Static!
    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!

    calendar Oct 11, 2021 · Speaking PASS Summit  ·
    Share on: twitter facebook linkedin copy

    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 …


    Read More
  • How I Digitally Capture Videotapes

    calendar May 5, 2021 · Video Conversion  ·
    Share on: twitter facebook linkedin copy

    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 …


    Read More
  • Video and Questions from my EightKB session!

    calendar Feb 2, 2021 · Speaking EightKB  ·
    Share on: twitter facebook linkedin copy

    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 …


    Read More
  • What Is A SQL Server Big Data Cluster?

    calendar Dec 7, 2020 · SQL Server Big Data Clusters  ·
    Share on: twitter facebook linkedin copy

    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 …


    Read More
  • I’m a Microsoft Certified Trainer!

    calendar Aug 12, 2020 · Microsoft Certified Trainer  ·
    Share on: twitter facebook linkedin copy

    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 …


    Read More
  • I’m Speaking at Data Community Weekender Europe!

    calendar May 1, 2020 · Community Speaking  ·
    Share on: twitter facebook linkedin copy

    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 …


    Read More
  • Why You Shouldn’t Convert Old Home Movies To DVD (or Blu-Ray)

    calendar Apr 28, 2020 · Video Conversion  ·
    Share on: twitter facebook linkedin copy

    I have long been the digital archivist of my family, putting countless hours into tracing genealogy, scanning and organizing photos, and, recently, digitizing old videos. For the past few years, my labor of love has been converting VHS, Betamax, and 8mm camcorder tapes to digital formats so they can be preserved. It's …


    Read More
    • ««
    • «
    • 1
    • 2
    • 3
    • 4
    • 5
    • »
    • »»

Bob Pusateri

Data and Kindred Subjects
Microsoft MVP Microsoft Certified Master

Newsletter

Subscribe Here

Recent Posts

  • How To Remember SQL Clause Ordering
  • Building A Redirect Service with Cosmos DB and Azure Functions
  • New and Improved - Now With Static!
  • Presenting at PASS Data Community Summit 2021!
  • How I Digitally Capture Videotapes

Tags

SQL-SERVER 83 SPEAKING 37 SQL-SATURDAY 37 TSQL-TUESDAY 37 THOUGHTS 36 PASS-SUMMIT 34 COMMUNITY 33 EVENTS 27 PRESENTATIONS 17 T-SQL 12 SOFTWARE 11 PERSONAL 10 TOOLS 10 CLOUD-STORAGE 9
All Tags
24-HOURS-OF-PASS1 ARTIFICIAL-INTELLIGENCE1 AUDITING1 AZURE-DATA-STUDIO4 AZURE-FUNCTIONS1 AZURE-SQL-DATABASE1 AZURE-VMS1 BACKUP2 BACON8 BIG-DATA-CLUSTERS1 BLOGGING3 BOOK-REVIEW3 CERTIFICATION2 CHICAGO-SQL-ASSOCIATION2 CLOUD-STORAGE9 COMMUNITY33 COMPRESSION2 COMPUTING2 CONFIGURATION2 COSMOS-DB3 DATA-SETS1 DATA-TYPES2 DESIGN3 EIGHTKB1 EVENTS27 FILEGROUPS1 HARDWARE4 HIGH-AVAILABILITY1 HUGO1 INDEXING3 INTERVIEWING3 LINUX1 LITERATURE2 MICROSOFT-CERTIFIED-TRAINER1 MVP1 OFF-TOPIC1 PASS4 PASS-SUMMIT34 PERSONAL10 POWERSHELL7 PRESENTATIONS17 PROFESSIONAL-DEVELOPMENT9 RECOVERY-MODELS1 SECURITY1 SNAPSHOTS1 SOFTWARE11 SPEAKING37 SQL-SATURDAY37 SQL-SERVER83 SQLBITS3 SSMS6 SSRS1 T-SQL12 THOUGHTS36 TIPS-TRICKS3 TOOLS10 TRAINING1 TSQL-TUESDAY37 USER-GROUPS4 VIDEO-CONVERSION2 WINDOWS1 XML2
[A~Z][0~9]
Bob Pusateri

Copyright 2010 -  Bob Pusateri. All Rights Reserved

to-top