[EN] X-MASS in Frisko – Time for SharePoint books…

It’s about five weeks for X-MASS 2012. As usual I thinking more about some cool gifts for myself for this special occasion – You know: buying, receiving, wrapping and forgotting… till early morning of 25th Dec when we should be surprise as always…  Because I live in small country somewhere between Germany and Russia, and delivery is not simple process I must think and order all of this stuff in advance. This time I’m more focused for SharePoint 2013 books, because of my friends: Penelope Coventry {TWITTER | BLOG} Sahil Malik {TWITTER | BLOG} and Steve Fox {TWITTER | BLOG} new books. My list of book, which should expanding my library very soon are below:


BY Penelope Coventry:

Book about developing aplications, using MDS (not Master Data Services >> it’s Minimal Download Strategy), colors, styles, themes, documents versioning (docs, list, webparts),  external connections and more new functions in SharePoint 2013.


Paperback: 200 pages | Publisher: Microsoft Press (March 22, 2013)
Language: English | ISBN-13: 978-0735675520 | Price: 12,77 USD

LINK: Amazon


BY Sahil Malik:

Many developers tried, trying and will try to build right developer machine. many years of experience of Sahil will help You. Yust read thiss book, the build Your own virtual machine. and use Kindle.



Print Length: 81 pages | Publisher: Winsmarts, LLC (October 27, 2012)
Language: English | ASIN: B009Y4QZT8 | Price: 6,89 USD

LINK: Amazon


BY Sahil Malik:

Another one new publication by Sahil. And another one for Kinde. This time about Planet of the Apps. One of the biggest difference between SharePoint 2010 and 2013 are Apps. Azure Apps, Hosted Apps, SharePoint Apps and more.




Print Length: 109 pages | Publisher: www.winsmarts.com; 1 edition (October 8, 2012)
Language: English | ASIN: B009NOIGSM | Price: 8,04 USD

LINK: Amazon


BY Stephen Cawood:

Short guide for most important features in SharePoint 2013: taxonomy, wikis, blogs, social networks and customization, fast creating sites, my sites and more.



Paperback: 304 pages | Publisher: McGraw-Hill Osborne Media; 2 edition (April 5, 2013)
Language: English | ISBN-10: 007180983X | Price: 12:91 USD

LINK: Amazon


BY Amanda Perran:

Beginning, but from right way: from experts point of view. Guide how use in business purposes lists, libraries, workflows, reports, forms, permissions, social features with examples from real-world case scenario.



Paperback: 600 pages | Publisher: Wrox; 1 edition (February 26, 2013)
Language: English | ISBN-10: 1118495896 | Price: 21,09 USD

LINK: Amazon


BY Steve Fox:

For developers, or advanced admins. With many words about building, packaging, deploying Apps. Some words abour Azure and SharePoint, about security, managed and unmanaged Apps



Paperback: 504 pages | Publisher: Wrox; 1 edition (February 26, 2013)
Language: English | ISBN-10: 1118495845 | Price: 24,22 USD

LINK: Amazon


BY Reza Alirezaei:

Another one book for developers, but this time for advance level. With implementation of Application Life Cycle Management, Windows Azure, testing, best practices and cases.



Paperback: 840 pages | Publisher: Wrox; 1 edition (February 26, 2013)
Language: English | ISBN-10: 1118495829 | Price: 26:36 USD

LINK: Amazon


BY Stacia Misner:

Deep Dive into Business Intelligence. BI Lifecycle, DAX Language, PowerPivot, Visio Services, lot of information about dashboards and reports, scorecards and KPI, indicators and triggers. Co-existence of SharePoint 2013 and SQL Server 2012.


Paperback: 400 pages | Publisher: Microsoft Press (March 22, 2013)
Language: English | ISBN-10: 0735675430 | Price: 23,09 USD

LINK: Amazon


In short sumary: Seven physical books, 145 USD and almost 3000 pages. Unfortunatelly just two Kindle’s editions available before xmass, but… Everything what tigers like the best…

Post Scriptum:

If the World will collapse at 122112 this post doesn’t matter…

If not… Spring 2013 will be awesome, reading, reading and more reading…

[EN] Putting my fingers… into MDX

I am very proud and happy to announce new interesting book about SQL Server 2012. This book is very special for me, because – in indirect way – I can say that it’s my second book. OK it’s still not my own book, but I had chance to putting my fingers inside this book.

Member of SQL Family from Dallas, my new friend Ashim Mazumder {LinkedIN} wrote very practical book about MDX language and functions in SQL Server 2012. 390 pages has divided for ten chapters:
Chapter 01: Introduxion to MDX
Chapter 02: Set Functions
Chapter 03: Navigation Functions
Chapter 04: Time Functions
Chapter 05: String Functions
Chapter 06: Numeric Functions
Chapter 07: Statistical Functions
Chapter 08: MDX Scripting Statements
Chapter 09: MDX Data Definition And Manipulation Statements
Chapter 10: MDX Performance Tuning And Best Practices

This book was published few days ago (exactly on 4th September) by eGurus (Irving, Texas) and on the publisher page we can read a short annoucement:

This book is for anybody who wants to learn MDX language. We have assumed that you have got some relational database design and SQL language experience, and know basic concepts of SQL, Server Analysis Services (SSAS). Throughout the book, we used practice database “Adventure works”, which is very popular among users of Microsoft SQL Server environment. Inside this book you will find:
• More than 350 MDX queries.
• MDX functions are explained with simple examples.
• Some topics like “All Level” explained in detail with various examples.
• Detail analysis of each component of queries.
• MDX query architecture explained in detail with examples.
• Contains simplified definition of functions with examples and their possible values.
• Explains how to improve performance of MDX queries and best practices.
This book is an important and valuable reference for those interested in learning and improving their MDX skill.

I should received few copies nin next weeks, so probally You will can get  fresh copy on one of my future sessions at SQL Community Events. In the meantime – or if You will not have a chance to meet me – You can buythis book at Amazon (HERE).

[EN] SQL Server 2012 Pocket Consultant by O’Reilly

BOOKLET__SQLSRV2012PocketAdminGuideMicrosoft Press has published (by O’Reilly of course) new small book about SQL Server – this time for SQL Server 2012 of course. Some basic information: the general author (as almost always) is William R. Stanek; publisher (of course) is Microsoft Press, book size: 592 pages, ISBN:978-0-7356-6376-3 | ISBN 10:0-7356-6376-9. Book is available in print and digital formats, and is not expensive (about 32 USD).

But what You can find inside this book? Lets see it:

PART 1: Microsoft SQL Server 2012 Essentials
Chapter 1 Managing Your SQL Servers
(Using SQL Server Management Studio, Managing SQL Server Groups, Managing Servers, Using Windows PowerShell for SQL Server Management, Starting, Stopping, and Configuring SQL Server Agent, Starting, Stopping, and Configuring MSDTC, Managing SQL Server Startup, Managing Server Activity)
Chapter 2 Managing SQL Server Services and Clients
(Managing SQL Server Component Feature Access, Managing the Network and SQL Server Native Client Configuration, Understanding the Services Configuration, Configuring SQL Server Services)
PART 2: Microsoft SQL Server 2012 Management and Security
Chapter 3 Implementing Policy-Based Management
(Introducing Policy-Based Management, Working with Policy-Based Management, Configuring Central Management Servers, Managing Policies Throughout the Enterprise)
Chapter 4 Configuring and Tuning Your SQL Servers
(Accessing SQL Server Configuration Data, Techniques for Managing SQL Server Configuration Options, Configuring SQL Server with Stored Procedures)
Chapter 5 Tuning and Linking Your SQL Servers
(SQL Server Management Studio Essentials, Working with Linked Servers and Distributed Data, Configuring Authentication and Auditing, Tuning Memory Usage, Configuring Processors and Parallel Processing, Configuring Threading, Priority, and Fibers, Configuring User and Remote Connections, Managing Server Settings, Managing Database Settings, Managing Linked Servers, Troubleshooting Configuration Problems,)
Chapter 6 Database Administration Essentials
(Database Files and Logs, Database Administration Basics, Creating Databases, Altering Databases and Their Options, Managing Database and Log Size,Manipulating Databases, Tips and Techniques)
Chapter 7 Implementing SQL Server 2012 Security
(Overview of SQL Server 2012 Security, SQL Server 2012 Authentication Modes, Special-Purpose Logins and Users, Permissions, Roles, Managing Server Logins, Configuring Server Roles, Controlling Database Access and Administration, Managing Database Permissions)
PART 3: Microsoft SQL Server 2012 Data Management
Chapter 8 Manipulating Schemas, Tables, and Views
(Working with Schemas, Getting Started with Tables, Table Essentials, Working with Tables, Managing Table Values, Using Views)

Chapter 9 Using Indexes, Constraints, and Partitions
(Creating and Managing Indexes, Working with Columnstore Indexes, Column Constraints and Rules, Creating Partitioned Tables and Indexes, Compressing Tables, Indexes, and Partitions)
PART 4: Microsoft SQL Server 2012 Optimization, Maintenance, and Recovery
Chapter 10 Automating and Maintaining SQL Server 2012
(Database Automation and Maintenance, Using Database Mail, Using SQL Server Agent, Managing Alerts, Managing Operators, Scheduling Jobs, Automating Routine Server-to-Server Administration Tasks, Multiserver Administration, Database Maintenance)
Chapter 11 SQL Server 2012 Backup and Recovery
(Creating a Backup and Recovery Plan, Selecting Backup Devices and Media, Using Backup Strategies, Creating a Backup Device, Performing Backups, Restoring a Database, Restoring the master Database)
Chapter 12 SQL Server 2012 Profiling and Monitoring
(Monitoring Server Performance and Activity, Working with Replication Monitor, Working with the Event Logs, Monitoring SQL Server Performance, Configuring a Management Data Warehouse, Solving Performance Problems with Profiler)

More information and ORDER BASKET You can find HERE.