How to Become an Exceptional DBA - download pdf or read online

By Brad M McGehee

ISBN-10: 1906434220

ISBN-13: 9781906434229

A second variation of Brad McGehee's well known "career consultant" for DBAs, designed to aid new and potential DBAs locate their toes within the occupation, and to propose these more-experienced on how they could excel at their jobs, and so develop into remarkable DBAs.

Show description

Read or Download How to Become an Exceptional DBA PDF

Similar sql books

Ken Henderson's The Guru's Guide to Transact-SQL PDF

It is a coder's ebook. it truly is meant to assist builders construct purposes that utilize Transact-SQL. it isn't approximately database management or layout. it isn't approximately end-user or GUI software improvement. it is not even approximately server or database functionality tuning. it truly is approximately constructing the easiest Transact-SQL code attainable, whatever the program.

Pro SQL Server 2008 Analytics Delivering Sales And Marketing by Brian Paulen, Jeff Finken PDF

Seasoned SQL Server 2008 Analytics presents every little thing you must be aware of to strengthen subtle and visually attractive revenues and advertising dashboards utilizing SQL Server 2008 and to combine these dashboards with SharePoint, PerformancePoint, and different key Microsoft applied sciences. The booklet starts via addressing the numerous misconceptions that encompass using key functionality signs (KPIs) and giving a short evaluation of the company intelligence (BI) and reporting instruments that may be mixed at the Microsoft platform that can assist you generate the consequences that you just desire.

New PDF release: The Real MCTS SQL Server 2008 Exam 70-433 Prep Kit: Database

[ this can be an excerpt from my weblog put up approximately this publication: [. .]

I am making plans to take the MCTS 70-433 Certification examination. If and while is that going to take place, it's not that i am convinced but. it's not that i am yes while yet i'm hoping it will likely be within the close to destiny. MCITP 70-451 can also be in my to-do record for the final sector of this 12 months (or first area of 2011) because of this it's fairly very important for me to nail this 70-433 examination the soonest I can.

I am now not utilizing the MCTS 70-433 Self-Paced education package in my training. as a substitute, i'm utilizing the true MCTS SQL Server 2008 examination 70-433 Prep equipment from Syngress. Judging from my confident adventure taking the 70-431 examination few months in the past, i will rather well say that the genuine MCTS 70-433 Prep equipment gets the task performed. i admire the positive factors of this prep booklet. i admire the truth that the reply keys of the self try out questions are chanced on correct after the questions. the various different gains of the ebook i like are:

- record Of examination targets in each chapter
- "Configuring & enforcing" and "Head of the category" bins that spotlight vital notes approximately specific beneficial properties of SQL Server 2008
- examination Warnings that include info on a few gotchas which may be severe whilst taking the exam
- try out Day information which spotlight valuable, good, tips on how to take into accout of.
- step by step Exercises
- FAQ that enhances what you've gotten long past over within the chapter
- and naturally the standard creation and precis in each one chapter.

The in basic terms issues that I pass over from the MS Press Self-Paced education package are the perform examination CD and the tear-out research consultant. yet these shouldn't be difficulties as i've got an entry to a improvement surroundings that i will play with in coaching for this examination; and that i created my very own personalized 70-433 learn consultant (with highlights on each one pursuits and money packing containers) in response to the Microsoft studying web site . i've got made my personalized learn consultant to be had for everyone. you could obtain it [from my blog]:[. .] or electronic mail me at mribunal [at] gmail [dot] com

My actual good fortune or failure eventually will depend on how a lot attempt i'm prepared to exert in learning for this examination and never simply on any books or examine fabrics.

Defensive Database Programming with SQL Server by Alex Kuznetsov PDF

Resilient T-SQL code is code that's designed to final, and to be properly reused via others. The target of protective database programming, the objective of this e-book, is that will help you to provide resilient T-SQL code that robustly and gracefully handles situations of accidental use, and is resilient to universal alterations to the database setting.

Additional info for How to Become an Exceptional DBA

Example text

Their job is to determine what high availability methods are best for their environment, and then to implement and maintain them. 48 Chapter 3: Specialize (You can't do it all) DBA Business Intelligence Specialist DBA Business Intelligence Specialists design, create, and maintain data warehouses and OLAP cubes so that data can more easily be retrieved and analyzed by organizations. This often involves developing BI-based applications, written using MDX queries. They also design or configure Business Intelligence tools for use by end-users.

Productivity Tools Whatever database specialty you choose, you will have both built-in and third-party tools available to help you do your job and be more productive. In my experience, many DBAs don't take the time to learn how to master the tools available to them. This means they end up being less proficient and productive at their work. Not only does the Exceptional DBA master all the tools included with SQL Server, he also learns about related third-party tools that can help him become more productive.

On the left hand side write your strengths, and on the right hand side write down your weaknesses. Once you are done with your assessment, consider which characteristics are your strengths, which ones need work, and which ones you might consider skipping. Remember, most Exceptional DBAs have taken many years to develop these characteristics, and that not all Exceptional DBAs have all these strengths. In later chapters, we will talk more about how you can develop these strengths, including what actions you can take to attain specific goals.

Download PDF sample