- Видео 13
- Просмотров 1 152 192
Voluntary DBA
Канада
Добавлен 8 авг 2012
SQL Server database administration and development, made simple.
Hosted by Microsoft Certified IT Professional Jon Seigel.
Hosted by Microsoft Certified IT Professional Jon Seigel.
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...
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...
Best video on this topic!❤ Thanks man!
je t'aime bebou, tu lave Ioana sache le
wow! what a clear explanation. Perfect!
Emil Egiazarian Math professor of NYU Excellent presentation
The Mr. Rogers of Database administration.
That the upload date is ten years ago must be my hallucination
Thank you, Very much for your kindness
wow I thought you were Nicolas Cage for a second
Awesome video. It's kicking Pluralsight's backend 😀.
GREAT JOB
WOW??? VERY CLEAR EXPLAINATION! GOD BLESS
I would love to see more videos on Ambiguous concepts of SQL on this channel thanks man.
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
I watched so many videos about this topic and didn't understand but when i watched your video i still don't understand
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
???
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.
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 (:
Somehow this video is a failure for me
I played it several times at low speeds 😭
Amazing Job
Thank you Nicholas Cage for the wonderful explanation.
Super explanation..... Great job !!
What if it doesnt work?
I had a hard time understanding the difference until I watched your video. Thanks for the simple explanation!
i still dont get it
This is awesome, I referred lost video but this one really hits me. This is next level explanantion.
Great video! Most of our slides on this topic in my college are based on this :)
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.
Thanks friend, that was a clear and concise explanation with excellent graphics.
Excellent video. Much easier with visuals than reading articles. Keep up the good work.
Great work, learned quite a lot about such a important topics in database the slides and visual explanation was piece of master piece
Big thanks man , you are the best
Buena explicacion, estoy dando mis primeros pasos en SQL server, y tu explicación me aclaro muchas dudas
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."
ohhh I like it
what is an in decks?
Very nice and precise information
i love u bro
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.
veryy good explaining tyyy 😄
Great video!!
i understand more from this video than 3 hour training
This is all I was looking for. Best explanation about behind the scenes of indexing.
thank you its works
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?
Excellent video. Finally I could find a video which is so crisp and clear. Thanks a ton!!
Thank you
way too fast for me to follow
Thanks a lot .
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