Bob Pusateri
open-menu closeme
About
Community
Contact
bluesky linkedin github sessionize twitter rss
  • Everything I Can Tell About My MCM Exam Experience

    calendar Jul 2, 2013 · Professional Development SQL Server  ·
    Share on: twitter facebook linkedin copy

    I was recently extremely honored to find out that I earned the Microsoft Certified Master (MCM) certification for SQL Server 2008. For me, this is a major milestone in a long, difficult, and costly journey. I have received several questions about it already, and while I can't answer everything, I am happy share as much …


    Read More
  • Moving A Database to New Storage With No Downtime

    calendar Mar 12, 2013 · SQL Server TSQL Tuesday  ·
    Share on: twitter facebook linkedin copy

    It's once again the second Tuesday of the month, meaning it's T-SQL Tuesday! This month's topic comes to us from Jen McCown (blog | @JenniferMcCown). Jen is asking us to share our knowledge about filegroups, and it just so happens that I have a story about migrating to new storage that involved a large number of file …


    Read More
  • Bigger Databases Aren’t Always Better

    calendar Feb 12, 2013 · SQL Server  ·
    Share on: twitter facebook linkedin copy

    I'm fortunate to be able to work with some rather large SQL Server instances on a daily basis, including databases over 25TB in size. Due to their bulk, "VLDBs" (Very Large Databases) present some challenges for DBAs: following best practices for small transactional systems might not be feasible on a VLDB. …


    Read More
  • Does Restoring A Database Modify the Boot Page?

    calendar Nov 20, 2012 · SQL Server  ·
    Share on: twitter facebook linkedin copy

    At work, a key function of my team is importing new systems into our data warehouse, most of which come from vendors. To do this we utilize many different methods depending on the capabilities of the source system and desired timeliness of the data. ETL through SSIS, snapshot replication, and transactional replication …


    Read More
  • Red Gate SQL in the City: Chicago

    calendar Oct 18, 2012 · SQL Server  ·
    Share on: twitter facebook linkedin copy

    Back at the first Chicago Free-Con event in 2011, Brent Ozar was talking about how wonderful the SQL Saturday movement is and prophesized that in the near future we'll be seeing similar free training events put on by individual vendors instead of community volunteers. Eighteen months later I found myself at Red Gate's …


    Read More
  • T-SQL Tuesday #35: A Horror Story

    calendar Oct 9, 2012 · SQL Server TSQL Tuesday  ·
    Share on: twitter facebook linkedin copy

    This year, time seems to be flying by faster than ever. It's October already, and we're up to our 35th installment of T-SQL Tuesday. This time we're hosted by Nick Haslam (blog | @nhaslam). Nick's asking "what is your most horrifying discovery from your work with SQL Server?" The story that scares me the most …


    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
  • Do your backups run at the right time?

    calendar Jul 31, 2012 · SQL Server  ·
    Share on: twitter facebook linkedin copy

    Many articles on database backups reference running database backups and maintenance processes overnight. In lots of situations this is a great idea, especially if you’re dealing with a transactional system that has users connecting to the database during the day and minimal activity outside of business hours. But for …


    Read More
  • T-SQL Tuesday: A Day in the Life

    calendar Jul 17, 2012 · SQL Server TSQL Tuesday  ·
    Share on: twitter facebook linkedin copy

    July 2012 is the thirty-second installation of T-SQL Tuesday – wow that’s a lot! I can still remember reading posts that were part of the first one… This month’s topic comes from Erin Stellato (blog | @erinstellato), the newest employee of SQLskills (congrats Erin!!) She’s asking us to track what we do for a day and …


    Read More
  • SQL Saturday #119 Update

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

    Chicago's third annual SQL Saturday will soon be upon us, and as food and beverage coordinator it's my job to obsess over what's on the menu. SQL Saturday food offerings seem to have evolved over time. The first few I attended offered pizza, which is of course a great way to feed a large number of people. While very …


    Read More
    • ««
    • «
    • 1
    • 2
    • 3
    • 4
    • 5
    • »
    • »»

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