Recent Reviews from other Course:
Clear concise and informative – Thomas
Clear and step-by-step information – Rosalia
The course was well structured from start to finish. Keep up the good work. – Arina
VLDB is an acronym. It stands for Very Large Database. The term is not specific to SQL Server.
What constitutes a VLDB is always up for discussion. It’s my opinion that any database over 100 gig should be designed and tuned much more granularly than smaller databases.
For the purposes of this course I’ll use the benchmark of 100 gig for a VLDB.
In this course we will learn how to design a VLDB for SQL Server. We will also look at some additional measures you’ll need to take from a performance tuning perspective.
In the course we will be highlighting practices you should consider implementing in order to maximize scale and performance of your VLDBs.
This course will take a real world approach. That simply means you will be able to take what you’ve learned in the lessons and build out a real world VLDB.
Thanks for your interest in “Architecting Very Large Databases in SQL Server.”
The first 10 minutes are free on every Udemy course. Please take a moment to watch all ten minutes to ensure this course is right for you.
It's also a good idea to read over the lecture titles. The titles will provide you with insight into what's really in the course.
Is this course right for you.
Are you here to learn about VLDBs?
Let's cover a very basic disk to data file and filegroup layout.
Let's learn how to kill all the users in a given database so we can alter our schema.
Let's learn how to move schema and data between filegroups.
Let's highlight what we've covered in this introductory section.
Multiple data files on smaller data files is a good idea.
Multiple data files on VLDS is a requirement.
Let's create some.
What is IFI and why should we enable it?
Let's define what table partitioning is.
Let's demo how to start partitioning our table.
Let's learn how to compress out data and what data we should compress.
Let's continue learning about compression but this time on a partitioned table.
All VLDB should be using back up compression.
Let's learn how to implement it.
Let's back up to more than one backup file.
Let's set up tempdb correctly for our VLDBs.
Let's rebuild our indexes with a higher level of granularity.
Let's wrap up the high points of this section.
Thanks for taking my course.
I've been a production SQL Server DBA most of my career.
I've worked with databases for over two decades. I've worked for or consulted with over 50 different companies as a full time employee or consultant. Fortune 500 as well as several small to mid-size companies. Some include: Georgia Pacific, SunTrust, Reed Construction Data, Building Systems Design, NetCertainty, The Home Shopping Network, SwingVote, Atlanta Gas and Light and Northrup Grumman.
Experience, education and passion
I learn something almost every day. I work with insanely smart people. I'm a voracious learner of all things SQL Server and I'm passionate about sharing what I've learned. My area of concentration is performance tuning. SQL Server is like an exotic sports car, it will run just fine in anyone's hands but put it in the hands of skilled tuner and it will perform like a race car.
Certifications are like college degrees, they are a great starting points to begin learning. I'm a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Engineer (MCSE) and Microsoft Certified Trainer (MCT).
Born in Ohio, raised and educated in Pennsylvania, I currently reside in Atlanta with my wife and two children.