Free e-Book: Introducing Microsoft SQL Server 2014

This fee e-Book "Introducing Microsoft SQL Server 2014" – by Ross Mistry and Stacia Misner .

Microsoft SQL Server 2014 is the next generation of Microsoft’s information platform, with new features that deliver faster performance, expand capabilities in the cloud, and provide powerful business insights.

In this book, we explain how SQL Server 2014 incorporates in-memory technology to boost performance in online transaction processing (OLTP) and data-warehouse solutions. We also describe how it eases the transition from on-premises solutions to the cloud with added support for hybrid environments.

SQL Server 2014 continues to include components that support analysis, although no major new features for business intelligence were included in this release. However, several advances of note have been made in related technologies such as Microsoft Excel 2013, Power BI for Office 365, HDInsight, and PolyBase, and we describe these advances in this book as well.

The book includes below chapters:

Database AdministrationChapter 1: SQL Server 2014 editions and engine enhancements
Chapter 2: In-Memory OLTP investments
Chapter 3: High-availability, hybrid-cloud, and backups enhancements

Business intelligence DevelopmentChapter 4: Exploring self-service BI in Microsoft Excel 2013
Chapter 5: Introducing Power BI for Office 365
Chapter 6: Big Data Solutions

You can download the e-Book 

1. PDF version of this title here
2. The EPUB format is here and Mobi for Kindle file here

Regards

Satishbabu Gunukula

http://www.sqlserver-expert.com

Free ebook:Rethinking Enterprise Storage: A Hybrid Cloud Model

This fee e-Book "FREE e-Book: Rethinking Enterprise Storage: A Hybrid Cloud Model" by Marc Farley .

The author, Marc Farley, works at Microsoft on hybrid cloud storage solutions as a senior marketing manager. The book includes a Foreword by storage industry expert and noted blogger Martin Glassborow, better known in the industry as Storagebod.

The book includes seven chapters:

Chapter 1 Rethinking enterprise storage
Chapter 2 Leapfrogging backup with cloud snapshots
Chapter 3 Accelerating and broadening disaster recovery protection
Chapter 4 Taming the capacity monster
Chapter 5 Archiving data with the hybrid cloud
Chapter 6 Putting all the pieces together
Chapter 7 Imagining the possibilities with hybrid cloud storage

You can download the 

1. PDF version of this title here

2. The EPUB format is here and the MOBI format is here.

Regards

Satishbabu Gunukula

http://www.sqlserver-expert.com

Comprehensive list of O365 Tools and Diagnostics

This wiki contains information about tools that can be used to diagnose and troubleshoot issues with Office 365 services. This wiki also contains links to resources such as articles, videos, and training that show how the tools are used to diagnose and resolve Office 365 scenarios. We also recommend using the troubleshooting section of the Office 365 Community for additional troubleshooting content.

http://community.office365.com/en-us/w/diagnostic_tools/default.aspx#top

Item	URL	Description
Office 365 technical Blog and RSS Feed	http://community.office365.com/en-us/b/office_365_community_blog/default.aspx	Site to sign up for RSS feed to understand the latest changes to O365.  Important for Admins in the O365 tenant.
O365 Technology blog	http://blogs.office.com/office365updates/	Site to sign up for RSS feed to understand the latest changes to O365. Important for Admins in the O365 tenant.
O365 Portal	Go into your O365 Portal	Sign up for RSS feed from the Service Health dashboard
Software Requirements for O365 site	http://office.microsoft.com/en-us/office365-suite-help/software-requirements-for-office-365-for-business-HA102817357.aspx	Updates on the software requirements (browser, client and OS) for O365.
Service Descriptions site	http://technet.microsoft.com/en-us/library/jj819284.aspx	Service Descriptions for O365.  Important for Admins in the O365 tenant.
Evergreen Readiness deck	SDE Deliverable from Cloud Vantage contract.  (PowerPoint deck)	Quarterly deck created by the SDE by working directly with the Microsoft PG to provide a roadmap of the upcoming changes to O365.  Only available to Cloud Vantage customers.
Office 365 URL and IPs	http://technet.microsoft.com/en-us/library/hh373144.aspx	Site to sign up for a RSS feed to receive a updated list of URL and IPs that are used to connect to O365

Regards
Satishbabu Gunukula

http://www.sqlserver-expert.com

Download:Office 2016 for Mac Preview Guide

We have a downloadable guide for reviewers of the Office 2016 for Mac Preview.

The new and modern Microsoft Office 2016 for Mac Preview is the Office you know and love, thoughtfully designed for the Mac. It is powered by the cloud via Office 365, so you can access documents anytime, anywhere on any device. With the newly designed Ribbon, tools and formatting are organized just like in all the Office apps across platforms and devices. The modernized user experience—optimized for the Mac with full support for retina displays—allows you to enjoy working on your Mac Through seamless integration with Office 365, OneDrive, OneDrive for Business, and SharePoint, you can access your files across devices by signing in with your Office identity (your Microsoft account or your work or school email).

The Office 2016 for Mac Preview has many exciting features, including:

· Newly designed Ribbon organizes tools and formatting in a manner similar to Office for Windows.

· Modernized user experience is optimized for the Mac, with full support for retina displays.

· Seamless integration with Office 365, OneDrive, OneDrive for Business, and SharePoint means you can access your files across devices by signing in with your Office identity.

· Format object task pane delivers greater object manipulation capabilities.

Download the .PDF (26 pages, 8.7MB) here:

DOWNLOAD: Office 2016 for Mac Preview Guide http://1drv.ms/1PbWzgg

Regards,

Satishbabu Gunukula

http://www.sqlserver-expert.com

Download:Free eBook, “Microsoft Azure Essentials: Azure Machine Learning”

This fee e-Book "FREE e-Book: Microsoft Azure Essentials: Azure Machine Learning " by by Jeff Barnes . This is the third ebook in Microsoft Press’s free Microsoft Azure Essentials series.

This book covers following Topics

Introduction

Chapter 1 Introduction to the science of data

Chapter 2 Getting started with Azure Machine Learning

Chapter 3 Using Azure ML Studio

Chapter 4 Creating Azure Machine Learning client and server applications

Chapter 5 Regression analytics

Chapter 6 Cluster analytics

Chapter 7 The Azure ML Matchbox recommender

Chapter 8 Retraining Azure ML models

Download the e-book using below Link
http://aka.ms/AzureML_pdf

Regards
Satishbabu Gunukula
http://www.sqlserver-expert.com

Backup failed with the following error: "xp_create_subdir() returned error 161

Users might receive below error when executing backup.

Executed as user: NT Service\SQLAgent$SQLTEST. Microsoft (R) SQL Server Execute Package Utility Version 12.0.2000.8 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 1:50:45 PM Progress: 2015-05-07 13:50:46.22 Source: {2FEF4D33-99C5-4CC6-9ECC-85EDDACC8E9E} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Error: 2015-05-07 13:50:46.41 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "EXECUTE master.dbo.xp_create_subdir N'\\SQLbackup\db..." failed with the following error: "xp_create_subdir() returned error 161, 'The specified path is invalid.'". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error

Error: 2015-05-07 13:50:46.60 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "BACKUP DATABASE [master] TO DISK = N'\\ SQLbackup \db..." failed with the following error: "Cannot open backup device '\\SQLbackup\SQLTEST\\Full_Backup\master\master_backup_2015_05_07_135046_3323057.bak'. Operating system error 5(Access is denied.). BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

If you see highlighted messages there are two reasons error

1. failed with the following error: "xp_create_subdir() returned error 161

First check SQL server or SQL Server Agent service running using the local or service account and the account should have enough privileges on the backup folder

2. Cannot open backup device. Operating system error 5(Access is denied.)

Check whether the account have read/write privileges on the backup folder.

In my case I see that SQL Server Agent running using a local account and that account don’t have permission on the backup folder. I have changed the SQL Server Agent “Log on As” account to service account which has permission and restarted the service.

Regards
Satishbabu Gunukula
http://www.sqlserver-expert.com