Voluntary DBA
Voluntary DBA
  • Видео 13
  • Просмотров 1 152 192
How to use Service Broker to scale out SQL Server database applications
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 Professional Jon Seigel explain the basics of how Service Broker works and the database objects behind creating your own Service Broker applications.
Blog post for this video:
voluntarydba.com/post/2014/02/18/Introduction-to-SQL-Server-Service-Broker.aspx
SqlDependency class:
msdn.microsoft.com/en-us/library/system.data.sqlclient.sqldependency%28v=vs.110%29.aspx
Service Broker samples on CodePlex:
msftsbprodsamples.codeplex.com
ssbdiagnose utility documentation:
technet.microsoft.com/en-us/library/bb934450.a...
Просмотров: 49 774

Видео

Clustered vs. Nonclustered Index Structures in SQL Server
Просмотров 672 тыс.11 лет назад
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 similarities and differences of clustered and nonclustered indexes, using a real-world example to show how these structures work to improve the performance of SQL queries. Blog post on primary key vs. the c...
How to configure tempdb in SQL Server
Просмотров 30 тыс.11 лет назад
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 important considerations to configure tempdb for optimal performance, including an in-depth discussion about how to choose the number of data files to create. Blog post: voluntarydba.com/post/2013/12/10/...
How to improve and manage the performance of vendor databases in SQL Server
Просмотров 3,3 тыс.11 лет назад
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 several ways to improve and manage the performance of a vendor database. Visit my channel for more database administration videos: ruclips.net/user/voluntarydba Subscribe to get notified about my latest...
How to minimize the size of fact tables in SQL Server
Просмотров 5 тыс.11 лет назад
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 your fact table sizes at their minimum. Read more about Data Compression: technet.microsoft.com/en-us/library/cc280449.aspx Read more about SPARSE columns: technet.microsoft.com/en-us/library/cc280604.as...
How to manage the size of the SQL Server Error Log
Просмотров 3,7 тыс.11 лет назад
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 Certified IT Professional Jon Seigel show you how to automatically cycle the Error Log without restarting the SQL Server instance. Read more about sp_cycle_errorlog: technet.microsoft.com/en-us/library/ms182...
Registered Servers and Central Management Servers in SQL Server (Part 2)
Просмотров 4,4 тыс.11 лет назад
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 Microsoft Certified IT Professional Jon Seigel show you how to use them in the second part of this two-part series. Watch Part 1: ruclips.net/video/2T0m1KCgQa0/видео.html Blog post for this video: volu...
Registered Servers and Central Management Servers in SQL Server (Part 1)
Просмотров 12 тыс.11 лет назад
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 Microsoft Certified IT Professional Jon Seigel show you where to find these tools and how to get started with them in the first part of this two-part series. Registered Servers XML file path: %APPDATA%...
How to allow remote connections to SQL Server Express
Просмотров 137 тыс.11 лет назад
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 disabling the Windows Firewall. While the configuration shown is based on installation defaults, a more complete reference is available on MSDN: msdn.microsoft.com/en-us/library/ms189083.aspx Blog post f...
How to create a backup Maintenance Plan in SQL Server
Просмотров 168 тыс.12 лет назад
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 that includes full, differential, and transaction log backup subplans. Blog post for this video: voluntarydba.com/post/2012/10/18/Creating-a-Backup-Maintenance-Plan.aspx Visit my channel for more dat...
How deadlocks are created in SQL Server
Просмотров 15 тыс.12 лет назад
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 this scenario comes about using T-SQL code, and learn how to read the resulting deadlock graph in SQL Server Profiler. Blog post for this video: voluntarydba.com/post/2012/10/04/How-are-deadlocks-create...
How to enable Instant File Initialization in SQL Server
Просмотров 4,6 тыс.12 лет назад
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, Microsoft Certified IT Professional Jon Seigel shows you how to enable this feature, and verify that it's been enabled correctly. Blog post for this video: voluntarydba.com/post/2012/09/11/Enable-Instant-D...
How to move the system database files in SQL Server
Просмотров 47 тыс.12 лет назад
Sometimes installation defaults are missed, or storage is added, and you need to move the system database files to a new location. In this video, watch Microsoft Certified IT Professional Jon Seigel show you how to perform this procedure, including how to set the security permissions on the target folder. Blog post for this video: voluntarydba.com/post/2012/09/06/Moving-the-System-Databases.asp...

Комментарии

  • @Shubhamkumar-cq5wt
    @Shubhamkumar-cq5wt 22 дня назад

    Best video on this topic!❤ Thanks man!

  • @gpasdeprenom5760
    @gpasdeprenom5760 27 дней назад

    je t'aime bebou, tu lave Ioana sache le

  • @Watson22j
    @Watson22j Месяц назад

    wow! what a clear explanation. Perfect!

  • @EmilEgiazarian
    @EmilEgiazarian 2 месяца назад

    Emil Egiazarian Math professor of NYU Excellent presentation

  • @RobertParham-p6r
    @RobertParham-p6r 2 месяца назад

    The Mr. Rogers of Database administration.

  • @Klinoklaz
    @Klinoklaz 2 месяца назад

    That the upload date is ten years ago must be my hallucination

  • @นพไกรใจดี
    @นพไกรใจดี 3 месяца назад

    Thank you, Very much for your kindness

  • @Amrmohamed-us3dw
    @Amrmohamed-us3dw 3 месяца назад

    wow I thought you were Nicolas Cage for a second

  • @platoh
    @platoh 3 месяца назад

    Awesome video. It's kicking Pluralsight's backend 😀.

  • @KingslyOjongAko
    @KingslyOjongAko 4 месяца назад

    GREAT JOB

  • @haizk
    @haizk 4 месяца назад

    WOW??? VERY CLEAR EXPLAINATION! GOD BLESS

  • @samlinus836
    @samlinus836 5 месяцев назад

    I would love to see more videos on Ambiguous concepts of SQL on this channel thanks man.

  • @samlinus836
    @samlinus836 5 месяцев назад

    Man, you've researched a lot such a quality video, you just kept answering all of the questions that I had referencing blogs and videos. God bless you brother

  • @3bood_kr
    @3bood_kr 6 месяцев назад

    I watched so many videos about this topic and didn't understand but when i watched your video i still don't understand

  • @davewhelton4166
    @davewhelton4166 6 месяцев назад

    For 10 years, I've learned the definitions of both coz i just couldnt grasp what it actually meant but the 2nd time watching this video, you have finally made me understand

  • @energy-tunes
    @energy-tunes 7 месяцев назад

    ???

  • @logicmindautomation1458
    @logicmindautomation1458 7 месяцев назад

    Hi, thanks for the nice tutorial. I have a problem though. I have my sql server on one computer and trying to connect to it from another computer and it doesn't seem to work. I am trying to connect using VB Script in Tia Portal. Any help would be highly appreciated.

  • @troop53no
    @troop53no 8 месяцев назад

    Thank you! I interact with a SQL database often, but indexes are not something I deal with enough. This was great information and exactly what I needed (:

  • @prabhatgaur1150
    @prabhatgaur1150 9 месяцев назад

    Somehow this video is a failure for me

  • @Machine-Human
    @Machine-Human 9 месяцев назад

    Amazing Job

  • @pralaysangma8019
    @pralaysangma8019 10 месяцев назад

    Thank you Nicholas Cage for the wonderful explanation.

  • @sasanknimmagadda2010
    @sasanknimmagadda2010 10 месяцев назад

    Super explanation..... Great job !!

  • @davidmolnar0
    @davidmolnar0 11 месяцев назад

    What if it doesnt work?

  • @imrana.8370
    @imrana.8370 Год назад

    I had a hard time understanding the difference until I watched your video. Thanks for the simple explanation!

  • @oscaroscuro
    @oscaroscuro Год назад

    i still dont get it

  • @Pani70326
    @Pani70326 Год назад

    This is awesome, I referred lost video but this one really hits me. This is next level explanantion.

  • @stinkbonk
    @stinkbonk Год назад

    Great video! Most of our slides on this topic in my college are based on this :)

  • @Rich-id8kc
    @Rich-id8kc Год назад

    Really nice video. Clear, concise, and provided a simple process to follow to allow networked connections. Thank you for posting this, I really appreciate the time/effort you put into this.

  • @michaelkennedy5126
    @michaelkennedy5126 Год назад

    Thanks friend, that was a clear and concise explanation with excellent graphics.

  • @manasr3969
    @manasr3969 Год назад

    Excellent video. Much easier with visuals than reading articles. Keep up the good work.

  • @GhOnAu
    @GhOnAu Год назад

    Great work, learned quite a lot about such a important topics in database the slides and visual explanation was piece of master piece

  • @bhys570
    @bhys570 Год назад

    Big thanks man , you are the best

  • @AlexJordan-d9l
    @AlexJordan-d9l Год назад

    Buena explicacion, estoy dando mis primeros pasos en SQL server, y tu explicación me aclaro muchas dudas

  • @matveyshishov
    @matveyshishov Год назад

    DBA videos 9 years ago: "After the table data is put into physical order, SQL Server builds up a set of index pages". "DBA" videos today: "So you want to have a FAANG career? You'll need to have SQL on your CV, and I'm going to teach you how to pass the interview in 60 seconds."

  • @juleko-v8p
    @juleko-v8p Год назад

    ohhh I like it

  • @CreativeUserGoesHere
    @CreativeUserGoesHere Год назад

    what is an in decks?

  • @surajkumarsingh4857
    @surajkumarsingh4857 Год назад

    Very nice and precise information

  • @garou8863
    @garou8863 Год назад

    i love u bro

  • @Alstash
    @Alstash Год назад

    Elegant explanations like this are truly timeless, shifted through a bunch of videos attempting to word this same information in, like, double the time, and yet STILL failed to deliver as well as you did, sir, truly thank you.

  • @urmomkenza7501
    @urmomkenza7501 Год назад

    veryy good explaining tyyy 😄

  • @Skillamu
    @Skillamu Год назад

    Great video!!

  • @aklsshinobiworld8689
    @aklsshinobiworld8689 Год назад

    i understand more from this video than 3 hour training

  • @akashverma1640
    @akashverma1640 Год назад

    This is all I was looking for. Best explanation about behind the scenes of indexing.

  • @rahulsyaban9744
    @rahulsyaban9744 Год назад

    thank you its works

  • @ac-devfullstack9709
    @ac-devfullstack9709 Год назад

    Excellent video, but even enabling tcp from windows 10, it didn't work. I have a VPS on Hostinger, with Firewall and open port, and it gives the same error, what could it be?

  • @akankshakaul744
    @akankshakaul744 Год назад

    Excellent video. Finally I could find a video which is so crisp and clear. Thanks a ton!!

  • @galrickgak9615
    @galrickgak9615 Год назад

    Thank you

  • @Niloo33
    @Niloo33 Год назад

    way too fast for me to follow

  • @Mahmoud-ys1kt
    @Mahmoud-ys1kt Год назад

    Thanks a lot .

  • @yowanehaku8725
    @yowanehaku8725 2 года назад

    Clustered = index tree of actual data Nonclustered = separated index tree of pointers(to actual data) so you can sort/filter it however you want without affecting actual data god, they could have named them better