Bob Pusateri
open-menu closeme
About
Community
Contact
twitter mastodon linkedin github rss
  • SQL Server Backup Terminology Part 1: Media Sets & Backup Sets

    calendar Nov 19, 2015 · Backup SQL Server  ·
    Share on: twitter facebook linkedin copy

    When backing up a database or transaction log, SQL Server needs to know two basic things: What information the backup should contain Where it's going to be written Many options exist to control the contents and behavior of a backup: whether it's full, differential, or a log, if it should be compressed, copy_only, …


    Read More
  • Who’s In Your Fixed Server Roles?

    calendar May 8, 2015 · Security SQL Server  ·
    Share on: twitter facebook linkedin copy

    It's 10PM*. Do you know who your sysadmin role members are? SQL Server's fixed server roles control incredibly broad permissions across your entire instance. For this reason, membership in these roles should be granted carefully and reviewed often. Fortunately, reviewing role membership is extremely easy, so you can …


    Read More
  • Why I Hate Row Compression

    calendar Mar 11, 2014 · Compression SQL Server TSQL Tuesday  ·
    Share on: twitter facebook linkedin copy

    This post is part of T-SQL Tuesday #52, which is being hosted this month by Michael J. Swart (@MJSwart). Michael is asking us to argue against a popular opinion, and I'm more than happy to do so, as this is a belief that I've kept to myself for quite a while. SQL Server's row compression feature can be an amazing tool. …


    Read More
  • Auditing Database Snapshots: Free Lunch!

    calendar Jan 31, 2014 · Auditing Snapshots SQL Server  ·
    Share on: twitter facebook linkedin copy

    The ability to keep track of what's being executed on a SQL Server instance, or to create a read-only copy of a database at a specific point in time can be very valuable if required by the solution you are developing. But a lesser-known fact about SQL Auditing and Database Snapshots is that not only do they work well …


    Read More
  • Wow – I’m an Author!

    calendar Nov 4, 2013 · SQL Server  ·
    Share on: twitter facebook linkedin copy

    I'm very proud to have contributed a chapter to Tribal SQL, which is now available for purchase at Amazon and finer bookstores everywhere. This is the first book I've had any part in writing, something I never thought I would do. I always hated English and literature classes in school – if it wasn't math, hard science, …


    Read More
  • A Dynamic Duo: Data Compression and Backup Compression

    calendar Aug 6, 2013 · SQL Server  ·
    Share on: twitter facebook linkedin copy

    When I'm presenting on SQL Server data compression, I frequently get asked if data compression and backup compression can be used together. I keep meaning to put together a blog post with a demo so I have something to direct people towards for further reading. So here we are – let's give it the old college try and find …


    Read More
  • 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
    • ««
    • «
    • 1
    • 2
    • 3
    • 4
    • 5
    • »
    • »»

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