Bob Pusateri
open-menu closeme
About
Community
Contact
bluesky twitter linkedin github sessionize rss
  • 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
  • BETWEEN a DATE and a DATETIME Place

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

    I'm not a fan of the BETWEEN operator. While the syntax is very easy to understand and requires less typing than my favorite alternative, it can lead to situations where unwanted results are returned. Because of this I've gotten into the habit of avoiding it all together. If you'd like a refresher on BETWEEN, its …


    Read More
  • Meme Monday: 11 words or less

    calendar Apr 4, 2011 · SQL Server  ·
    Share on: twitter facebook linkedin copy

    My shortest post to date comes as from the inaugural "Meme Monday" as declared by Tom LaRock. Here's my deep SQL Server thought in 11 words or less: Don't deploy changes until they've been tested in a dev environment. Tagged: Jose Chinchilla (blog) Kendra Little (blog | twitter)


    Read More
  • SQL Saturday #67 Wrap Up

    calendar Mar 29, 2011 · Events SQL Saturday SQL Server  ·
    Share on: twitter facebook linkedin copy

    Another SQL Saturday has come and gone, but for me this one was the best by far. I've now had the pleasure of attending 3 SQL Saturday events but this was the first one I've had a hand in planning. It was a great experience and I can't wait until next year! Friday On Friday I spent the day at Brent Ozar's (blog | …


    Read More
  • SQL Saturday #67 This Week!

    calendar Mar 22, 2011 · Events Presentations Speaking SQL Saturday SQL Server  ·
    Share on: twitter facebook linkedin copy

    After months of planning, SQL Saturday #67 is finally upon us! While this is the 3rd SQL Saturday I'll be attending, it's the first one I've had a hand in planning. It's been a real pleasure to be part of such an awesome team putting it all together along with: – Wendy Pastrick (blog | twitter) – Norman Kelm (blog | …


    Read More
  • T-SQL and the Big D520

    calendar Mar 15, 2011 · SQL Server  ·
    Share on: twitter facebook linkedin copy

    I enjoy watching college basketball but am absolutely horrible at making my NCAA tournament bracket each year. This time around, rather than spending an hour making guesses, I decided to let SQL Server do the work for me. Besides it's way cooler to be able to justify your bracket with T-SQL, right? My bracket is based …


    Read More
  • A Poor Man’s Data Warehouse

    calendar Mar 8, 2011 · SQL Server TSQL Tuesday  ·
    Share on: twitter facebook linkedin copy

    T-SQL Tuesday this month is being hosted by the one and only Jes Borland (blog | twitter), and the topic of the month is aggregation. Powerful and fast aggregation tools are one of the biggest reasons to use a database. Without them, there would be a lot less awesomeness to look forward to – kind of like a meal without …


    Read More
  • T-SQL Tuesday #15: Automation

    calendar Feb 8, 2011 · Powershell SQL Server TSQL Tuesday  ·
    Share on: twitter facebook linkedin copy

    This Month's T-SQL Tuesday is being hosted by Pat Wright (blog | twitter) and Pat is asking about tips and tricks for making life easier through automation using either T-SQL or PowerShell. Recently I have been doing more and more work in PowerShell in order to get familiar with it. So far I've been quite happy. Batch …


    Read More
  • T-SQL Tuesday #14: My Techie Resolutions

    calendar Jan 11, 2011 · SQL Server TSQL Tuesday  ·
    Share on: twitter facebook linkedin copy

    This month is the 14th T-SQL Tuesday (my how time flies!) and it's graciously being hosted by MidnightDBA and newly-minted MVP Jen McCown (blog | twitter). Jen is asking what our techie resolutions are for 2011 – what we hope to accomplish and why. I think this is a great topic, and I'm so glad I hadn't already done a …


    Read More
  • Microsoft Exam 70-433 Wrap Up

    calendar Jan 4, 2011 · Certification SQL Server  ·
    Share on: twitter facebook linkedin copy

    What do you call someone who graduated last in their class? In this case, me! I recently took Microsoft Exam 70-433 (MCTS: Database Developer 2008), and am pleased to report that I passed. I'm happy to offer up some of my thoughts as well as tips for those who might take it in the future. Scoring – Why Bother? So you …


    Read More
    • ««
    • «
    • 4
    • 5
    • 6
    • 7
    • 8
    • »
    • »»

Bob Pusateri

Data and Kindred Subjects
Microsoft MVP
Friend of Redgate
Microsoft Certified Master

Newsletter

Subscribe Here

Recent Posts

  • Finding Install Media on an Azure SQL Virtual Machine
  • 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!

Tags

SQL-SERVER 82 SPEAKING 37 SQL-SATURDAY 37 TSQL-TUESDAY 37 THOUGHTS 36 PASS-SUMMIT 34 COMMUNITY 33 EVENTS 27 PRESENTATIONS 17 T-SQL 12 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-DATABASE1 AZURE-VMS2 BACKUP2 BACON8 BIG-DATA-CLUSTERS1 BLOGGING3 BOOK-REVIEW3 CERTIFICATION2 CHICAGO-SQL-ASSOCIATION2 CLOUD-STORAGE8 COMMUNITY33 COMPRESSION2 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 SPEAKING37 SQL-SATURDAY37 SQL-SERVER82 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