Covers the steps you need to monitor your SQL Server using the Database Health Monitor application. Learn how to monitor your wait statistics, you blocking queries, and to find out the best ways to improve performance with what you learn. …
This complete course will help you determine if you have a sufficient backup strategy and restore plan OR will help you build one from scratch. In this course we dive into real life stories, RTO and RPO lesson with examples, …
This is a followup to my Whats more important than a backup plan article posted a couple of months ago. When you do a database restore, including log backups, it is very important to get the log chain in the …
One of the common task that I have come across is the need to convert a list of results into a comma separated list. There are many ways to use this, one if which is in reports. Download the AsCSV.sql …
Converting part of a result set to a comma separated list Read more »
Here are the slide decks from the Introduction to SQL Server class – January 2010. Class 1 About the Instructor Introduction and Class Overview (Review Syllabus) Course Logistics – What to expect and what is expected What is SQL Server? …
Notes from the Introduction to SQL server class. Read more »