Bob Pusateri
open-menu closeme
About
Community
Contact
bluesky linkedin github sessionize twitter rss
  • Is HOLDLOCK Really the Same as SERIALIZABLE?

    calendar Aug 3, 2023 · Azure SQL Database SQL Server T-SQL  ·
    Share on: twitter facebook linkedin copy
    Is HOLDLOCK Really the Same as SERIALIZABLE?

    Does the HOLDLOCK table hint really use the SERIALIZABLE transaction isolation level? Let's experiment and find out!


    Read More
  • 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
  • A Tale of a Trigger

    calendar Sep 11, 2018 · T-SQL TSQL Tuesday  ·
    Share on: twitter facebook linkedin copy

    This month's T-SQL Tuesday is being hosted by Steve Jones, who has asked for blog posts today on experiences we have had with triggers, good or bad. I am not a fan of triggers. While they represent a very simplistic construct of "if something happens, do something else", I've yet to encounter a situation …


    Read More
  • Finding Month Ends in T-SQL

    calendar Feb 28, 2018 · SQL Server T-SQL  ·
    Share on: twitter facebook linkedin copy

    Months are funny. Unlike other parts of a date, they vary in length: The last second of a minute is always 59. The last minute of a hour is always 59. The last hour of a day is always 23. But the last day of a month? Well that depends on what month it is. And the year matters too because a leap year means February gets …


    Read More
  • SQL Prompt 7.2 – Now With Execution Warnings!

    calendar May 10, 2016 · T-SQL Tools  ·
    Share on: twitter facebook linkedin copy

    I've loved using Redgate's tools ever since I discovered what they were, and now that I'm a Friend of Redgate it's even more fun because I get to give feedback to their developers and hear all about what's coming out in new releases! Recently, Redgate announced SQL Prompt 7.2, with a bunch of new features and …


    Read More
  • Dropping Multiple Databases At Once

    calendar Dec 3, 2015 · SQL Server T-SQL  ·
    Share on: twitter facebook linkedin copy

    I'm already at peace with the fact that I'll never know all of SQL Server's secrets, but that doesn't stop me from being surprised every time I figure out something new. In this case, it's another "secret" hiding in plain sight (Books Online). It turns out that the DROP DATABASE statement doesn't just have to …


    Read More
  • T-SQL Tuesday #025: Trick or …?

    calendar Dec 13, 2011 · SQL Server T-SQL TSQL Tuesday XML  ·
    Share on: twitter facebook linkedin copy

    This month's T-SQL Tuesday is hosted by Allen White (blog | @SQLRunr) and is an invitation to show off a nifty T-SQL trick you use to make your job easier. Here's one of my favorites as of late: Some of the source systems we copy from shard their data across multiple similar tables. For example, instead of having 1 …


    Read More
  • Creating Views in Another Database

    calendar Oct 18, 2011 · SQL Server T-SQL  ·
    Share on: twitter facebook linkedin copy

    Have you ever had one of those times where you spent hours trying different ways to make something work the way you envisioned, only to find that the solution was staring you in the face all along? I have those more often than I'd like to admit – and while the title of this post seems like a DBA 101 topic, the answer …


    Read More
  • T-SQL Tuesday #23: WHERE The JOIN Ends

    calendar Oct 4, 2011 · T-SQL TSQL Tuesday  ·
    Share on: twitter facebook linkedin copy

    This month's T-SQL Tuesday topic comes to us courtesy of Stuart Ainsworth (blog | @codegumbo), and is early due to the PASS Summit being next week. Perhaps those planning next year's summit will do a better job to make sure they don't interfere with any blogging parties :) Stuart's topic for the month is joins, and …


    Read More
  • T-SQL Tuesday #17: Applying APPLY

    calendar Apr 12, 2011 · SQL Server T-SQL TSQL Tuesday  ·
    Share on: twitter facebook linkedin copy

    This month's T-SQL Tuesday is the brainchild of Matt Velic and was inspired by a quote from Adam Machanic on the importance of understanding the APPLY operator. It's a good trick to have up your sleeve as it can do some nifty things and really save you some keystrokes when used properly. My first experience with APPLY …


    Read More
    • ««
    • «
    • 1
    • 2
    • »
    • »»

Bob Pusateri

Data and Kindred Subjects
Redgate Community Ambassador
Microsoft Certified Master

Newsletter

Subscribe Here

Recent Posts

  • Using the Proper Tool for the Job
  • Optimized Locking, Part I
  • Speaking at DataGrillen 2024!
  • Does Data Compression Speed Up Datatype Changes?
  • I'm Speaking at SQLBits 2024!

Tags

SQL SERVER 85 SPEAKING 39 SQL SATURDAY 37 THOUGHTS 37 TSQL TUESDAY 37 PASS SUMMIT 34 COMMUNITY 33 EVENTS 27 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 COMMUNITY33 COMPRESSION5 COMPUTING2 CONFIGURATION3 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 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