Bob Pusateri
open-menu closeme
About
Community
Contact
twitter mastodon linkedin github rss
  • What Is A SQL Server Big Data Cluster?

    calendar Dec 7, 2020 · SQL Server Big Data Clusters  ·
    Share on: twitter facebook linkedin copy

    SQL Server Big Data Clusters (BDCs) are a highly anticipated feature of SQL Server 2019, but what are they – and how can their capabilities best be leveraged? Let's dig a little deeper and find out. When SQL Server 2017 added support for Linux, the groundwork was laid for integrating SQL Server with Spark, HDFS, and …


    Read More
  • Finding Your Isolation Level

    calendar Oct 17, 2019 · SQL Server  ·
    Share on: twitter facebook linkedin copy

    Often when I am troubleshooting SQL Server or Azure SQL Database performance issues which I believe to be related to concurrency, I get curious about what isolation level is being used. But how does one find out the isolation level a query is executing with? There are actually several locations that may need to be …


    Read More
  • Topics I’d love to see at Conferences

    calendar Apr 11, 2019 · SQL Server Thoughts  ·
    Share on: twitter facebook linkedin copy

    The Call for Speakers for PASS Summit 2019 has just closed, and now the Program Committee will begin the task of evaluating speakers and sessions and using those results to build a schedule. It's not easy. Really, it's not. I've served on the Program Committee numerous times and there's a lot of effort that goes into …


    Read More
  • Dropping Offline Databases? Be Careful!

    calendar Oct 17, 2018 · SQL Server  ·
    Share on: twitter facebook linkedin copy

    Well, maybe the title is a little bit harsh. You absolutely can drop a SQL Server database that's offline, but remember that its files won't be deleted if you do. Safely Dropping Databases At a previous employer, we had a well-defined process when dropping databases for a client. It went something like this: Confirm …


    Read More
  • New Data Set: Chicago Parking Tickets

    calendar Sep 25, 2018 · Data Sets SQL Server  ·
    Share on: twitter facebook linkedin copy

    I'm always looking for new and interesting data sets for demonstration purposes. I enjoy using data that people can relate to – not only is it easily understood, but often it can be entertaining as well. This data set of real-world parking tickets does all that. A few weeks ago I came across this blog post by Matt …


    Read More
  • Finding Month Ends in T-SQL

    calendar Feb 28, 2018 · SQL Server T-SQL  ·
    Share on: twitter facebook linkedin copy

    Months are funny. Unlike other parts of a date, they vary in length: The last second of a minute is always 59. The last minute of a hour is always 59. The last hour of a day is always 23. But the last day of a month? Well that depends on what month it is. And the year matters too because a leap year means February …


    Read More
  • 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
    • ««
    • «
    • 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