10 Things Every Production SQL Server Should Have
- 1.5 hours on-demand video
- 12 mins on-demand audio
- 14 articles
- 1 downloadable resource
- Full lifetime access
- Access on mobile and TV
- Certificate of Completion
Get your team access to 4,000+ top Udemy courses anytime, anywhere.Try Udemy for Business
- Configure SQL Server correctly for production environments
- Set up an alerting system so you are notified when jobs fail and when alerts are fired
- Become more confident when an outage occurs.
- You'll need to have SQL Server installed. It can be any version but I'd suggest 2012 or 2014.
- You'll also need a fundamental understanding of SQL Server.
- There is no other cost other than the price of the course. Everything else is included or free.
Some recent reviews!!!
"I can't thank Mike enough for providing such useful information without cost; the content in this course is invaluable." Ken
"Thank you for the 10" David V
"Great Course." David S
This course focuses on 10 things that every SQL Server in production should have.
We will start with the single MOST important facet to every SQL Server DBAs job. Backups. We will cover the different kinds of backups and discuss how often we should be taking them. We will demo restores so WE understand the mechanics of how SQL Server backups up a database.
We will talk about the importance of the FULL backup and what having it means to recovery.
WE will cover consistency checks and talk about how often they should be run and why they should be run.
WE will cover statistics and index REBUILDS and how and why we should use them.
Lastly, WE will cover how to set up database MAIL so we can be alerted when OUR jobs fail.
Many organizations don't have production DBAs so this course can assist them with setting up the very basic necessities for a production SQL Server.
This is an entry level course and can be taken by developers, network administrators and database administrators. The course is even well suited for those who manage DBAs.
The course is a real world approach to setting up your SQL Server in a production environment.
The course if FREE so sign up now.
- There are no prerequisites for this course. If you have a basic knowledge of SQL Server then this course is for you.
- This course will cover the bare minimum we need for our SQL Servers in a production environment.
- Using the collegiate scale as a guide this course will be a 101 level course.
What are we going to learn in this course? This course will cover 10 things all production SQL Servers should have.
In this lesson let's overview those 10 items.
Let's cover the very basics of what a SQL Server database is. All SQL Server databases must have 2 files. Each database must have one data file and one log file.
SQL Server has three major types of backups.
A full backup.
A differential backup.
A transaction log backup.
Let's discuss the different types in this lesson.
In this lecture let's demo the different kinds of backups. We will start with the full and then work our way to the differential and finally the transaction log backup.
A description of the errors and how we approach them is beyond the scope of the course.
However, should one of these critical errors arise it would be good to have a reference point to start from.
Tim's article is a great overview of the various areas we need to be on the look out for.