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....
A blog about SQL Server, Books, Movies and life in general
Showing posts with label books. Show all posts
Showing posts with label books. Show all posts
Saturday, November 26, 2016
Tuesday, November 01, 2016
Two free SQL Server books from Microsoft Press
I noticed that the Microsoft Virtual Academy has a bunch of SQL Server books available that you might enjoy. These books are free, the data science one come in pdf format, while the introducing SQL
Data Science with Microsoft SQL Server 2016
Buck Woody, Danielle Dean, Debraj GuhaThakurta, Gagan Bansal, Matt Conners, Wee-Hyong Tok
Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud
Stacia Varga, Denny Cherry, and Joseph D’Antoni
There is also a Power BI book available, if you interested in that instead
Here is what is in the 2 books I mentioned
Data Science with Microsoft SQL Server 2016
Chapter 1: Using this book 1
For the data science or R professional 1
Solution example: customer churn 3
Solution example: predictive maintenance
and the Internet of Things 4
Solution example: forecasting 5
For those new to R and data science 7
Step one: the math 8
Step two: SQL Server and Transact-SQL 11
Step three: the R programming language
and environment 14
Chapter 2: Microsoft SQL Server R
Services 16
The advantages of R on SQL Server 16
A brief overview of the SQL Server R
Services architecture 21
SQL Server R Services 21
Preparing to use SQL Server R Services 24
Installing and configuring 24
Server 25
Client 28
Making your solution operational 36
Using SQL Server R Services as a
compute context 36
Using stored procedures with R Code 40
Chapter 3: An end-to-end data science
process example 43
The data science process: an overview 44
The data science process in SQL Server R
Services: a walk-through for R and SQL
developers 47
Data and the modeling task 48
Preparing the infrastructure,
environment, and tools 51
Input data and SQLServerData object 65
Exploratory analysis 68
Data summarization 68
Data visualization 70
Creating a new feature (feature engineering)76
Using R functions 77
Using a SQL function 80
Creating and saving models 83
Using an R environment 84
Using T-SQL 86
Model consumption: scoring data with a
saved model 89
Evaluating model accuracy 95
Summary 97
Chapter 4: Building a customer churn
solution 98
Overview 99
Understanding the data 101
Building the customer churn model 105
Step-by-step 108
Summary 118
Chapter 5: Predictive maintenance and
the Internet of Things 120
What is the Internet of Things? 122
Predictive maintenance in the era of
the IoT 124
Example predictive maintenance use
cases 127
Before beginning a predictive
maintenance project 129
The data science process using SQL Server
R Services 132
Define objective 136
Identify data sources. 137
Explore data 140
Create analytics dataset 142
Create machine learning model 155
Evaluate, tune the model 157
Deploy the model 161
Summary 165
Chapter 6: Forecasting 167
Introduction to forecasting 169
Financial forecasting 169
Demand forecasting 170
Supply forecasting 171
Forecasting accuracy 171
Forecasting tools 173
Statistical models for forecasting 174
Time–series analysis 174
Time–series forecasting 179
Forecasting by using SQL Server R
Services 183
Upload data to SQL Server 183
Splitting data into training and testing 185
Training and scoring time–series
forecasting models 186
Generate accuracy metrics
Introducing Microsoft SQL Server 2016: Mission-Critical Applications, Deeper Insights, Hyperscale Cloud
This book does not have chapters 1 and 5, so don't think that you are going crazy
Chapter 2 Better security 1
Always Encrypted 1
Getting started with Always Encrypted 1
Creating a table with encrypted values 7
CREATE TABLE statement for encrypted columns 7
Migrating existing tables to Always Encrypted 9
Row-Level Security 11
Creating inline table functions 11
Creating security policies 14
Using block predicates 15
Dynamic data masking 15
Dynamic data masking of a new table 16
Dynamic data masking of an existing table 16
Understanding dynamic data masking and permissions 17
Masking encrypted values 18
Using dynamic data masking in SQL Database 18
Chapter 3 Higher availability 20
AlwaysOn Availability Groups 20
Supporting disaster recovery with basic availability groups 21
Using group Managed Service Accounts 23
Triggering failover at the database level 23
Supporting distributed transactions 24
Scaling out read workloads 25
Defining automatic failover targets 26
Reviewing the improved log transport performance 27
Windows Server 2016 Technical Preview high-availability enhancements 28
Creating workgroup clusters 28
Configuring a cloud witness 29
Using Storage Spaces Direct 32
Introducing site-aware failover clusters 32
Windows Server Failover Cluster logging 33
Performing rolling cluster operating system upgrades 33
Chapter 4 Improved database engine 35
TempDB enhancements 35
Configuring data files for TempDB 36
Eliminating specific trace flags 37
Query Store 38
Enabling Query Store 38
Understanding Query Store components 39
Reviewing information in the query store 40
Using Force Plan 42
Managing the query store 43
Tuning with the query store 44
Stretch Database 44
Understanding Stretch Database architecture 45
Security and Stretch Database 45
Identifying tables for Stretch Database 46
Configuring Stretch Database 47
Monitoring Stretch Database 48
Backup and recovery with Stretch Database 49
Chapter 6 More analytics 50
Tabular enhancements 50
Accessing more data sources with DirectQuery 51
Modeling with a DirectQuery source 51
Working with calculated tables 54
Bidirectional cross-filtering 56
Writing formulas 60
Introducing new DAX functions 60
Using variables in DAX 63
R integration 64
Installing and configuring R Services 64
Getting started with R Services 65
Using an R Model in SQL Server 74
Chapter 7 Better reporting 77
Report content types 77
Paginated report development enhancements 77
Introducing changes to paginated report authoring tools 78
Exploring new data visualizations 79
Managing parameter layout in paginated reports 84
Mobile report development 85
KPI development 85
Report access enhancements 86
Accessing reports with modern browsers 86
Viewing reports on mobile
You can get these books here: https://mva.microsoft.com/ebooks/
Subscribe to:
Posts (Atom)