18
Jun
10

In My Tools Database – Chapter 20

I have mentioned time and time again to people… when you want to learn more about SQL Server it’s time to create your own database, and now use that database to track all sort of things, like the history of your database growth, or what about the history of your jobs long term? Even the number of times your procs have been executed can be tracked in your database world, this database will help you be a better DBA. What a better way to learn then using your databases that you understand. If you don’t understand them, you will when you’re done.

With the DMV’s containing all the information about your server that most of us ask for this experience will not only provide you with awesome information but creating this on your own will help you develop your skills. So where do you start? First keep your info in there and by reading all the DMV’s that you can and use them to fill the tables. When your done it is time to add the tools that can help in you so many more places, this is where Denis Gobo chapter comes in. Use the code, use the hints that he gives you.

The two different types of data can exist in different databases, but the thought is the same.

Thanks for the chapter Denis.

Advertisements

0 Responses to “In My Tools Database – Chapter 20”



  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


Chapters

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 13 other followers