T H E O S O P H I A
.wisdom is here.

Proudly Presents
SQL Admin 2012: Server Optimization

Release notes:

Date.........: November 22, 2015
Size.........: 08x15mb
Url..........: http://is.gd/dLqK8g
Type.........: Bookware

Description:

n this course we are going to go through a few topics covering some
basic optimizing and troubleshooting in SQL 2012. We will discuss
Trace flags which are used to alter the behavior of SQL Server.
Sometimes this is useful, sometimes it is dangerous and sometimes it
is just bizarre what they do. We will review the use of trace flags
to capture deadlock information so we can more efficiently
troubleshoot the cause. Then we will look into blocks, a common
issue in SQL server and go over how to determine which process is
blocking others and how to resolve it. Next we will then go through
a series of DMVs that are quite useful in optimizing and
troubleshooting SQL Server. I even share some DMV based queries I
use all the time to check indexes fragmentation and usage along with
a query to identify the most expensive queries in your database.

Install notes:

Unpack, burn/mount and go learning

Greetings:

To all the groups who brings quality - you know who you are