Bob Pusateri
open-menu closeme
About
Community
Contact
twitter mastodon linkedin github rss
  • T-SQL and B-Ball: My 2012 NCAA Bracket

    calendar Mar 14, 2012 · SQL Server  ·
    Share on: twitter facebook linkedin copy

    March Madness is once again upon us, which means it's time for one of the biggest time sinks of the year: filling out a bracket for the pseudo-sanctioned office NCAA pool. Along with the superbowl, this is a hallowed time when bosses turn a blind eye to all the cash that seems to be heading towards that person who has …


    Read More
  • T-SQL Tuesday #28: Jack of All Trades or Master of None?

    calendar Mar 13, 2012 · SQL Server TSQL Tuesday  ·
    Share on: twitter facebook linkedin copy

    This month's T-SQL Tuesday is brought to us by newly-minted MCM Argenis Fernandez (blog | @DBArgenis), who I had the pleasure of meeting in person for the first time a few weeks ago. Argenis is asking if we specialize or not, why we do (or don't) specialize, and why we feel that's a good thing. For a very long time …


    Read More
  • Collecting Index Usage Statistics

    calendar Jan 26, 2012 · Indexing SQL Server  ·
    Share on: twitter facebook linkedin copy

    Knowing when and how often your indexes are used can really come in handy. Indexes that are never utilized aren't worth keeping around, and knowing their usage patterns can be a big help when making decisions regarding things such as filegroup placement and compression settings. SQL Server 2005 brought some great …


    Read More
  • 2012: New Year, New Goals

    calendar Jan 3, 2012 · Personal SQL Server  ·
    Share on: twitter facebook linkedin copy

    Happy New Year to all! At the start of 2011, I laid out some goals for the year and did an update on them back in July. Now that it's 2012 it's a great time to take a look at what I accomplished (and fell short on) last year and also set some new targets. My 2011 goals were as follows: Speak More – I spoke at two SQL …


    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
  • SQL Saturday #119 Open for Registration!

    calendar Dec 9, 2011 · Events SQL Saturday SQL Server  ·
    Share on: twitter facebook linkedin copy

    The third time's a charm! SQL Saturday #119 (Chicago 2012) has been posted on the SQL Saturday website! It will once again be held at the DeVry University campus in Addison, IL and will be on May 19, 2012. SQL Saturday in Chicago has a special place in my heart for a few reasons. The first SQL Saturday I ever attended …


    Read More
  • Christmas Gifts I’d Like to See

    calendar Dec 5, 2011 · SQL Server  ·
    Share on: twitter facebook linkedin copy

    Well, we're back at the top of the month again, and this time around for Meme Monday we're to talk about what we'd love to see under the tree from Microsoft. This got my creative juices flowing, and I came up three wishes: First and foremost, if I had one wish that I could wish this holiday season, it would be that all …


    Read More
  • T-SQL Tuesday #24: Functions v. Procedures

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

    This month brings us the 24th edition of T-SQL Tuesday (24 already? wow….). This time around our topic comes from Brad Schulz (blog) and has to do with stored procedures and functions. Brad's asking us to write whatever we'd like about either of them. While from the bird's-eye view both functions (the table-valued …


    Read More
  • SQL Saturday #101 Wrap Up

    calendar Nov 1, 2011 · Events SQL Saturday SQL Server  ·
    Share on: twitter facebook linkedin copy

    After my trek to Iowa City last year for SQL Saturday #50, I knew I'd have to travel to more out-of-town SQL Saturdays in the future. Unfortunately I couldn't make it back to Iowa City this year, but I was very happy when I found I would be able to travel to Kansas City this time around for SQL Saturday #101. This is …


    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
    • ««
    • «
    • 2
    • 3
    • 4
    • 5
    • 6
    • »
    • »»

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