Part 2 of 3 in the SQL Server 2012 Database Administration (70-462) series. This SQL Server 2012 administration course covers how to configure and maintain an enterprise data management system. You'll learn SQL profiler, SQL server agent, basic high availability principles, and proper management of data and log files. If you're new to SQL Server administration, you'll benefit from this introduction as it introduces you to a broad range of topics.
Database Console Commands (DBCC) Hey everybody and welcome to TrainSignal. Now we're going to talk about DBCCs or Database Console Commands, but everybody just says, DBCC. Now, these are commands that you can use to view some sort of deep level system configuration or get some information on some part of the system that you ordinarily wouldn't have or even maybe just to perform a maintenance task of some kind. And as we go through this, you're going to see really kind of what I'm talking about how these are used for special kinds of purposes. Things that you wouldn't use ordinary TSQL commands for and there are a lot of DBCC commands, there really are. Some of them are documented, some of them aren't documented. I'm going to try to run you through some of the more common ones. Of course, I can't run you through all of them. But I am going to run you though, some of the more common ones that I think you're going to run across more often. And then of course, you can go research the rest on your own. Let's go ahead and get started. So, DropCleanBuffers.
Collecting Troubleshooting Data Hey everybody and welcome to TrainSignal. Now we're going to talk about Collecting Troubleshooting Data. No matter what you do, no matter how good you think you are or how good your devs are or how good your vendors are. Things are going to go wrong. There is just no way around it. So I'm going to show you the basic tools that you need to start collecting some troubleshooting data. And then how to work with it a little bit to get the results. Now there's no way that I can show you everything that you need to know about this. Because there have been DBAs, myself included, who have been doing this for many years. I mean, I've been doing this almost two decades now. And I still learn new stuff about these tools and about the methods and techniques that you use to, to do it. So, there's no way that in this short lesson I can tell you everything you need to know. But what I do hope to do is walk you through the basic techniques and tools that you're going to use. So that then you have a good working knowledge of it. And then you can go off and you can understand books and blogs and speakers and whatnot. When you get more information about it, you'll at least know the basics. And you'll be able to take what I teach you now and directly apply it to your job. Probably even today.