Bob Pusateri
open-menu closeme
About
Community
Contact
bluesky linkedin github sessionize twitter rss
  • Mirroring? Make Sure Editions Match!

    calendar Feb 13, 2018 · High Availability SQL Server  ·
    Share on: twitter facebook linkedin copy

    SQL Server Mirroring has had a rough time the past few years. It was deprecated in SQL Server 2016, and now it's more or less being replaced by Basic Availability Groups, (which I love to refer to as "BAGS"). Database Mirroring hasn't gone the way of the Dodo yet though. Perhaps it won't be quite so popular …


    Read More
  • Interviewed by Mohammad Darab

    calendar Jan 23, 2018 · Professional Development SQL Server  ·
    Share on: twitter facebook linkedin copy

    I very recently had the pleasure of being interviewed by Mohammad Darab. He asked some very insightful questions, and I'm so grateful he decided to ask me! You can read the full interview here. He also has a very impressive list of interviews on his site. See the entire list here!


    Read More
  • SQL Server 2016: What’s Going Away

    calendar Jun 22, 2016 · SQL Server  ·
    Share on: twitter facebook linkedin copy

    SQL Server 2016 is upon us, with all the much-anticipated hoopla and sexy new features people have been lusting over in the CTPs for months. It's always great to see the hype around a new release. But in the circle of (an application's) life, the arrival of new things often means others are going away for good. Let's …


    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
  • 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 Compression  ·
    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
    • ««
    • «
    • 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