or
Sign in to turn on 1-Click ordering.
Trade in Yours
For a £6.00 Gift Card
Trade in
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Tell the Publisher!
I’d like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Learn SQL Server Administration in a Month of Lunches [Paperback]

Don Jones

RRP: £21.99
Price: £14.86 & FREE Delivery in the UK. Details
You Save: £7.13 (32%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 3 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want it Tuesday, 23 Sep.? Choose Express delivery at checkout. Details
Trade In this Item for up to £6.00
Trade in Learn SQL Server Administration in a Month of Lunches for an Amazon Gift Card of up to £6.00, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Learn more

Book Description

12 May 2014 1617292133 978-1617292132 1

Summary

Learn SQL Server Administration in a Month of Lunches is the perfect way to get started with SQL Server operations, including maintenance, backup and recovery, high availability, and performance monitoring. In about an hour a day over a month, you'll learn exactly what you can do, and what you shouldn't touch. Most importantly, you'll learn the day-to-day tasks and techniques you need to keep SQL Server humming along smoothly.

Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications.

About the Book

Microsoft SQL Server is used by millions of businesses, ranging in size from Fortune 500s to small shops worldwide. Whether you're just getting started as a DBA, supporting a SQL Server-driven application, or you've been drafted by your office as the SQL Server admin, you do not need a thousand-page book to get up and running.

Learn SQL Server Administration in a Month of Lunches is the perfect way to get started with SQL Server. This concise, easy-to-read book skips academic introductions and teaches you day-to-day techniques for maintenance, backup and recovery, performance monitoring, and more. Each of the 21 short lessons gives you practical takeaways you'll use over and over.

What's Inside

  • Master the basics—indexes, logins, backup, recovery ... and more
  • Learn what you can and cannot do when supporting a third-party application
  • Monitor and improve performance
  • Written by expert trainer and bestselling author Don Jones
  • Accessible to readers of any level of experience, the book covers techniques for all versions of SQLServer 2005-2014.

About the Author

Don Jones is a Microsoft MVP, speaker, and trainer. He is the creator of the Month of Lunches series and author of over 50 books on PowerShell, IIS, Active Directory, SCCM, SQL Server, and more.

Table of Contents

  • Before you begin
  • Server assessment and configuration
  • T-SQL crash course
  • Managing databases
  • Backup and recovery
  • Authentication: who are you?
  • Authorization: what are you allowed to do?
  • Accounting: what did you do?
  • Analyzing indexes
  • Maintaining indexes
  • Tuning index designs
  • Reading query execution plans
  • Block and deadlock analysis
  • Automating management with SQL Server Agent
  • Multiserver management
  • Windows PowerShell and SQL Server
  • Using Extended Events
  • Monitoring and analyzing performance
  • Options for high availability
  • Virtualizing SQL Server
  • Moving, migrating, and upgrading databases
  • SQL Server performance checklist
  • Never the end

Frequently Bought Together

Learn SQL Server Administration in a Month of Lunches + Learn Active Directory Management in a Month of Lunches + Learn Windows IIS in a Month of Lunches
Price For All Three: £55.61

Buy the selected items together


Product details


More About the Author

Discover books, learn about writers, and more.

Product Description

About the Author

Don Jones is a Microsoft MVP, speaker, and trainer. He developed the Microsoft PowerShell courseware and has taught SQL Server, PowerShell, and other practical technologies to more than 20,000 IT pros. Don writes for TechNet Magazine and blogs for WindowsITPro.com. He is the creator of the Month of Lunches series that covers PowerShell, IIS, Active Directory, SCCM, SQL Server, and more.


Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

There are no customer reviews yet on Amazon.co.uk.
5 star
4 star
3 star
2 star
1 star
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 4.5 out of 5 stars  4 reviews
1 of 1 people found the following review helpful
3.0 out of 5 stars Concise introduction with practical advice 18 Jun 2014
By Chris Gaschler - Published on Amazon.com
Format:Paperback
SQL Server administration in a month of lunches is targeted at "the Reluctant DBA”, i.e. the person in the organization that administers existing Microsoft products and gets asked to look after the database as well.

I do not fit into that category but found the book to be a concise overview with some sound operational and troubleshooting advice on the key areas of SQL Server Administration covering topics from installation and virtualization, to maintenance and backups, to performance monitoring and index health.

However, there are some things I didn’t like about the book. In the first few chapters the pace was really slow and in particular chapter 3 on T-SQL tried to cram in too much and didn’t accomplish what I think they were intending. Those familiar will SQL should skim or skip.

Several other chapters, and topics, felt like they ended abruptly and redirected to recommended reading instead of going into what would have been interesting content. This may have been so it would fit in the month of lunches concept or because it’s aimed at being an introduction not a reference book but either way I wanted more.

There was also a little of the "DBA vs Developer" rhetoric scattered throughout the book, which is unfortunate because there is some good practical advice on topics like authentication/authorization, scripting, indexing and performance monitoring that would be as applicable for a developer working with SQL Server as a reluctant DBA.
5.0 out of 5 stars The best book for beginners on SQL Server to be "Immediately Effective" 25 Jun 2014
By Manoj R. Nair - Published on Amazon.com
Format:Paperback
What I liked about the book?

If you had a chance to read Don's book on "The Nine Principles of Immediately Effective Instruction", you will understand why his books are so popular. He employs all the 9 principles to great perfection in this book like he did for the PowerShell book.

I was sent a copy of the book for the purpose of reviewing it. (Thank you Manning!) So who am I to review this book? Well, I am not a SQL Guru nor do I work exclusively with SQL Servers in my day job. However, I spend an awful lot of time working with products that require SQL, e.g. Configuration Manager 2012 R2, Operations Manager 2012 R2 etc. I wanted to learn more about SQL as it would help me better understand products that use SQL as their data store.

The book has 23 Chapters. Unlike other books I have read on this subject, the chapters weave well together helping you build your SQL skills as and when you progress through the chapters. The hands-on labs at the end of the chapter are pretty good and help cement the concepts.I could complete all the hands-on labs with relative ease. Don's writing style is very engaging and interesting so you don't have to struggle to remain awake to read up on the chapters.

I agree with the Timothy, Chapter 7 on SQL Security has one of the best explanations on the topic. Loved the coverage SQL's PowerShell support in Chapter 16.

What could have been better in this book?

The coverage of T-SQL in the book could been deeper especially if you consider that the first few chapters spend a considerable time on lab setup and getting things ready. I could attribute this to my carving for T-SQL. Probably the structure of "in a month of lunches" book format might have cramped information that I wished deserved more coverage. The chapter on virtualizing SQL looks to be trimmed down and was looking for more real world best practices rather than a link to read up at my leisure.

Final thoughts:

Have I become a SQL Guru. Ofcourse not. That was never the objective of this book. But can I become one, yes. And this book has paved the way for it. It delivers what it promises at the very beginning of the book,

"Instead, this book is meant as a starting point, and from here you could go on to being a DBA or developer".

So for me, that's worth my money I would invest in purchasing this book.

A must have for anyone wanting to get up speed with SQL Server.
5.0 out of 5 stars Highly Recommended for New or "Accidental" SQL Server DBAs 24 Jun 2014
By Timothy Edwards - Published on Amazon.com
Format:Paperback
This is a great introduction to SQL Server administration for those just getting into SQL Server database administration or who may be “accidental” DBAs. As a senior database administrator, this is certainly a resource that I would recommend while mentoring and training junior DBAs.

One of the topics that I think that the author covered extremely well that I think many introductory books on SQL Server tend to gloss over (or even leave the reader with more questions than answers) is the topic of SQL Server security. To the uninitiated, SQL Server security can be quite confusing. The author did a great job of explaining this in a real-world context, but also provided the reader with a basis and approach that can be applied to managing security in any type of IT system.

The book also gives a great crash course in the T-SQL language and some best practices to consider for T-SQL development.

Overall, in a series of easily digestible chapters, the author provides the reader with a rather comprehensive overview of the most important functions and features of SQL Server from an administrative standpoint and does a good job of pointing out best practices for configuration and management of SQL Server all along the way.
5.0 out of 5 stars Very detailed read for a person new to SQL Server 24 Jun 2014
By jw13 - Published on Amazon.com
Format:Paperback
I am a reluctant DBA that was given the job responsibility and never had any formal training. That was 6yrs ago. I wish I had this book back then. Even though I have a good amount of experience with SQL Server I found this book to be very informative. I am not a sql server guru so this was a great book to fill in some cracks. The hands on labs and were very helpful in demonstrating some of the elements that I have not dealt with. Auditing was a very nice chapter to layout ways to audit what users are doing on the server. Indexes are covered in depth via three chapters. I learned how to backup an index, which I didn't know was possible. Profiler is also covered very well and is a super helpful too when debugging. The performance monitor section was also helpful as it did not just say 'do this', it gave why and what some of the stats you are looking for might mean. Didn't get into much in the way of TSQL but did get into a good amount of powershell, which is also a must in todays sql environments.
Were these reviews helpful?   Let us know

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category


Feedback