You have a DBA that you want to get something for this holiday season, but you have a hard time figuring out what to get him?
Here are 3 choices that will make a good present
The first two have to do with the availability of SQL Server on Linux. This is in preview right now, but it will be here before you know it.
I can already see the job postings a year fron now...
Install SQL Server on Windows as well as Linux
Manage Linux and Windows servers
And of course... 5 years experience installing SQL Server vNext on Linux :-)
You go to the interview, then someone asks what does touch File1 do?
You get my point, SQL Server DBAs will need to learn Linux and they will need to learn this fast.
If your DBA likes to read, as a first step, I would recommend the following two books
Unix and Linux: Visual QuickStart Guide (4th Edition)
How Linux Works: What Every Superuser Should Know 2nd Edition
The Visual QuickStart book is for the total beginner, the How Linux Works book will go into more detail. Either book is perfect if the person has never touched a *nix system before.
Both books are nicely formatted, clear and concise, once the person is done with one of these books, the person can get himself/herself one of those 1000 page tomes
The next item is a book by an author whose previous work I have read and enjoyed
High Performance SQL Server The Go Faster Book by Benjamin Nevarez
I noticed that Benjamin Nevarez's latest book is available now on the Apress site for $9.99 in epub and pdf format, this price is valid through November 29, 2016
I didn't read this book yet, so here is what the website has to say about this book
What You Will Learn
Understand SQL Server's database engine and how it processes queries
Configure instances in support of high-throughput applications
Provide consistent response times to varying user numbers and query volumes
Design databases for high-throughput applications with focus on performance
Record performance baselines and monitor SQL Server instances against them
Troubleshot and fix performance problems
Here is a breakdown of the chapters
How SQL Server Works
Pages 1-19
Analyzing Wait Statistics
Pages 21-43
The Query Store
Pages 45-69
SQL Server Configuration
Pages 71-84
tempdb Troubleshooting and Configuration
Pages 85-99
SQL Server In-Memory Technologies
Pages 101-129
Performance Troubleshooting
Pages 131-154
Indexing
Pages 155-180
SQL Server Storage
Pages 181-196
There you have it...one of these will make a nice gift for your friendly DBA....
No comments:
Post a Comment