Bob Pusateri
open-menu closeme
About
Community
Contact
bluesky linkedin github sessionize rss
  • Planes, Trains, and #SQLFamily

    calendar Oct 27, 2014 · Community Events PASS Summit  ·
    Share on: twitter facebook linkedin copy
    It's my favorite time of year again – Autumn. It gets colder, the days get shorter, leaves change colors, and there's that little annual event called PASS Summit. This year I have even more reasons to love it because I was able to work 2 more events into my trip: SQL Saturday Oregon and [Red Gate's SQL in the City][3] …
    Read More
  • Three-Byte Integers in SQL Server: Fact or Fiction?

    calendar Jun 26, 2014 · Compression Data Types  ·
    Share on: twitter facebook linkedin copy
    I've been told on two occasions that the absence of the MEDIUMINT datatype is a serious shortcoming of SQL Server. If you're not familiar with MEDIUMINT, it's an integer type available in MySQL that consumes 3 Bytes and is capable of storing values ranging from -8,388,608 to 8,388,607 (signed) or from 0 to 15,777,215 …
    Read More
  • T-SQL Tuesday #54 – Interviews and Hiring

    calendar May 13, 2014 · Interviewing TSQL Tuesday  ·
    Share on: twitter facebook linkedin copy
    T-SQL Tuesday Logo

    This month's T-SQL Tuesday (the 54th!) is brought to us by Boris Hristov (@BorisHristov), and he's asking us to write about interviews and hiring. I think many of us have at least one tale of an interview or interaction with a recruiter that's gone good, bad, or ugly. I know I've got plenty of them, two of which I've …


    Read More
  • Why I Hate Row Compression

    calendar Mar 11, 2014 · Compression SQL Server TSQL Tuesday  ·
    Share on: twitter facebook linkedin copy

    T-SQL Tuesday Logo This post is part of T-SQL Tuesday #52, which is being hosted this month by Michael J. Swart (@MJSwart). Michael is asking us to argue against a popular opinion, and I'm more than happy to do so, as this is a belief that I've kept to myself for quite a while.

    SQL Server's row compression feature can be an amazing …


    Read More
  • Copying and Pasting File Paths

    calendar Feb 21, 2014 · Tips & Tricks  ·
    Share on: twitter facebook linkedin copy

    I know most of my important file locations by heart. Whenever I need to do things that require typing out a file's full path, such as copying a backup or taking a peek at logs, I can type those paths from memory without issue.

    On the other hand, when I'm working with systems I'm less familiar with or have never seen …


    Read More
  • Auditing Database Snapshots: Free Lunch!

    calendar Jan 31, 2014 · Auditing Snapshots SQL Server  ·
    Share on: twitter facebook linkedin copy
    The ability to keep track of what's being executed on a SQL Server instance, or to create a read-only copy of a database at a specific point in time can be very valuable if required by the solution you are developing. But a lesser-known fact about SQL Auditing and Database Snapshots is that not only do they work well …
    Read More
  • Recruiter Email Fail

    calendar Jan 23, 2014 · Thoughts  ·
    Share on: twitter facebook linkedin copy
    Pro Tip: If you're a recruiter and sending out mass emails about positions you're trying to fill, do yourself a favor and make sure you're not accidentally including other things, like a letter of reprimand from your boss. The names have been changed to protect the not-so-innocent, but here's the email I received …
    Read More
  • Apply for the PASS Summit 2014 Program Committee!

    calendar Jan 22, 2014 · PASS Summit Professional Development  ·
    Share on: twitter facebook linkedin copy

    PASS Summit 2014 logoWith over 40 weeks to go, PASS Summit 2014 may seem like the distant future, however the planning phase is already well underway. An event like the Summit is only possible because of the efforts of hundreds of volunteers, and opportunities to help this year are already starting to pop up.

    One such opportunity is the …


    Read More
  • SQL Saturday Coming Back to Chicago in 2014!

    calendar Jan 9, 2014 · Events SQL Saturday  ·
    Share on: twitter facebook linkedin copy

    This year Chicago will be hosting it's 5th SQL Saturday! SQL Saturday #291: Chicago 2014 is now open for registration! As always, the event itself is free. An optional lunch will be provided for $10.

    We are once again very grateful to DeVry University for hosting us. This year it will take place on Saturday April 26, …


    Read More
  • Break Stuff Like an Expert

    calendar Dec 10, 2013 · Community Professional Development Thoughts  ·
    Share on: twitter facebook linkedin copy

    This post is part of the DBA JumpStart series being written by myself and 19 other professionals from the SQL Server community and coordinated by John Sansom (@SQLBrit). It has been compiled into a free eBook, which can be found here. Be sure to download a copy!

    If you could give an aspiring DBA just one piece of …


    Read More
    • ««
    • «
    • 14
    • 15
    • 16
    • 17
    • 18
    • »
    • »»

Bob Pusateri

Data and Kindred Subjects
Redgate Ambassador
Microsoft Certified Master

Newsletter

Subscribe Here

Recent Posts

  • Data Saturday Chicago 2026 Wrap-Up
  • Data Saturday Chicago 2026 Update
  • Data Saturday Chicago 2026 Pre-Conference Sessions
  • Data Saturday Chicago 2026!
  • Using the Proper Tool for the Job

Tags

SQL SERVER 85 SPEAKING 39 COMMUNITY 37 SQL SATURDAY 37 THOUGHTS 37 TSQL TUESDAY 37 PASS SUMMIT 34 EVENTS 31 PRESENTATIONS 17 T-SQL 13 PERSONAL 10 SOFTWARE 10 TOOLS 10 PROFESSIONAL DEVELOPMENT 9
All Tags
24 HOURS OF PASS1 ARTIFICIAL INTELLIGENCE1 AUDITING1 AZURE DATA STUDIO4 AZURE FUNCTIONS1 AZURE SQL DATABASE4 AZURE VMS2 BACKUP2 BACON8 BIG DATA CLUSTERS1 BLOGGING3 BOOK REVIEW3 CERTIFICATION2 CHICAGO SQL ASSOCIATION2 CLOUD STORAGE8 COMMUNITY37 COMPRESSION5 COMPUTING2 CONFIGURATION3 COSMOS DB3 DATA SATURDAY4 DATA SETS1 DATA TYPES2 DESIGN3 EIGHTKB1 EVENTS31 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 SOFTWARE10 SPEAKING39 SQL SATURDAY37 SQL SERVER85 SQLBITS4 SSMS6 SSRS1 T-SQL13 THOUGHTS37 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