5,066
  • Welcome to Voluntary DBA!

    5,278 views 3 years ago
    Read additional content on my blog:
    http://voluntarydba.com

    Follow on Twitter:
    https://twitter.com/volunta...

    Like on Facebook:
    https://facebook.com/volunt... Show less
    Read more
  • Uploads Play all

    • How to use Service Broker to scale out SQL Server database applications - Duration: 13 minutes.

      • 3 years ago
      • 18,155 views
      Database applications can be scaled up or out by using SQL Server Service Broker, which provides asynchronous messaging and queuing infrastructure. In this video, watch Microsoft Certified IT Profe...
      • CC
    • Clustered vs. Nonclustered Index Structures in SQL Server - Duration: 8 minutes, 4 seconds.

      • 3 years ago
      • 153,241 views
      Clustered and nonclustered indexes share many of the same internal structures, but they're fundamentally different in nature. Watch Microsoft Certified IT Professional Jon Seigel explain the simila...
      • CC
    • How to configure tempdb in SQL Server - Duration: 7 minutes, 51 seconds.

      • 3 years ago
      • 10,678 views
      The tempdb system database comes out-of-the-box with settings that don't perform well for many production workloads. In this video, Microsoft Certified IT Professional Jon Seigel explains three imp...
      • CC
    • How to improve and manage the performance of vendor databases in SQL Server - Duration: 3 minutes, 20 seconds.

      • 3 years ago
      • 1,316 views
      Sometimes 3rd-party applications store their data in SQL Server, and the client is left to manage the database themselves. In this video, Microsoft Certified IT Professional Jon Seigel gives you se...
      • CC
    • How to minimize the size of fact tables in SQL Server - Duration: 4 minutes, 11 seconds.

      • 3 years ago
      • 1,529 views
      Fact tables often grow large, so it's important to keep them as space-efficient as possible. In this video, Microsoft Certified IT Professional Jon Seigel explains three techniques to help keep you...
      • CC
    • How to manage the size of the SQL Server Error Log - Duration: 111 seconds.

      • 3 years ago
      • 980 views
      If the SQL Server Error Log isn't restarted periodically, the log file can grow very large, which makes it more difficult and time-consuming to find what you're looking for. Watch Microsoft Certifi...
      • CC
    • Registered Servers and Central Management Servers in SQL Server (Part 2) - Duration: 11 minutes.

      • 3 years ago
      • 1,341 views
      SQL Server comes out-of-the-box with a set of powerful tools that allows you to manage multiple servers more effectively, but they're hidden away in the user interface of Management Studio. Watch M...
      • CC
    • Registered Servers and Central Management Servers in SQL Server (Part 1) - Duration: 11 minutes.

      • 3 years ago
      • 3,234 views
      SQL Server comes out of the box with a set of powerful tools that allows you to manage multiple servers more effectively, but they're hidden away in the user interface of Management Studio. Watch M...
      • CC
    • How to allow remote connections to SQL Server Express - Duration: 6 minutes, 25 seconds.

      • 3 years ago
      • 85,410 views
      Can't connect remotely to SQL Server? Watch Microsoft Certified IT Professional Jon Seigel show you how to allow remote connections to SQL Server Express and Developer edition instances without dis...
      • CC
    • How to create a backup Maintenance Plan in SQL Server - Duration: 6 minutes, 54 seconds.

      • 4 years ago
      • 85,021 views
      Maintenance Plans are an easy, simple way to get started with a backup solution. In this video, watch Microsoft Certified IT Professional Jon Seigel show you how to create a backup Maintenance Plan...
      • CC
    • How deadlocks are created in SQL Server - Duration: 11 minutes.

      • 4 years ago
      • 10,110 views
      Deadlocks occur when two processes both hold locks on resources, and also try to take locks on resources from the other process. Watch Microsoft Certified IT Professional Jon Seigel show you how th...
      • CC
    • How to enable Instant File Initialization in SQL Server - Duration: 2 minutes, 53 seconds.

      • 4 years ago
      • 1,725 views
      SQL Server normally writes zeros to new portions of data files. Enabling Instant File Initialization bypasses this process, allowing for faster recovery, restore, and response. In this video, Micro...
      • CC
    This item has been hidden
  • This item has been hidden
to add this to Watch Later

Add to

Loading playlists...