Bob Pusateri
open-menu closeme
About
Community
Contact
twitter mastodon linkedin github rss
  • I’m Speaking at Data Platform Discovery Day!

    calendar Apr 24, 2020 · Community Speaking SSMS Tips & Tricks  ·
    Share on: twitter facebook linkedin copy

    I'm always honored to be chosen to present at events, but I'm especially happy to be speaking at the first ever Data Platform Discovery Day! Data Platform Discovery Day is "A free one-day virtual conference introducing you to the Microsoft Data Platform", and it's new this year. It's actually 2 days, …


    Read More
  • Split Views of Files: SSMS Still is Best

    calendar Feb 5, 2018 · SSMS  ·
    Share on: twitter facebook linkedin copy

    While programming, I often need to view different parts of a file at the same time. Consider a long stored procedure: the list of parameters is at the top and it may be helpful to reference them when working elsewhere in the code. I could scroll repeatedly between the top of the file and wherever I am working, but that …


    Read More
  • Video: SQL Prompt Execution Warnings

    calendar Sep 9, 2016 · SSMS Tools  ·
    Share on: twitter facebook linkedin copy

    A while back, I wrote about how SQL Prompt now includes execution warnings and how useful I think that feature is. It's saved my bacon several times now, including just last week! I'm now happy to announce that I've recorded a demo video of this feature for Redgate's series of #SuperSQLTips for SQL Prompt. Be sure to …


    Read More
  • T-SQL Tuesday #68: Defaults

    calendar Jul 14, 2015 · SSMS TSQL Tuesday  ·
    Share on: twitter facebook linkedin copy

    I'm so happy to be able to contribute to this month's T-SQL Tuesday! Andy Yun picked an excellent topic: default settings. Defaults exist for a reason: in the absence of a user's preference, they represent the option that the application's author(s) believe will generally work the best for the greatest number of …


    Read More
  • Wanted: More Object Explorer Filters

    calendar Sep 25, 2012 · SQL Server SSMS  ·
    Share on: twitter facebook linkedin copy

    More often than not, I’ll expand the “Tables” folder in SQL Server Management Studio and browse the list to find whatever table or index I’m looking for. This works well in many situations, but when your database has over 20,000 tables, the results can be overwhelming! As your databases get larger and more complex, you …


    Read More
  • Multiple Result Sets = Multiple Row Counts

    calendar Dec 1, 2010 · SQL Server SSMS  ·
    Share on: twitter facebook linkedin copy

    I'm sure this one's been in SQL Server Management Studio for quite a while, but I never noticed it before now. Let's say you're running a batch in SSMS containing 2 T-SQL Statements. For simplicity's sake, I'll do some selects from my Numbers table: 1SELECTTOP10FROMNumbers;2SELECTTOP100FROMNumbers; The …


    Read More

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