[EN] Free Book about Claims & Access Control for SharePoint & Azure

BOOKLET__A Guide to Claims-Based Identity and Access Control, Second Edition - Book DownloadFew days ago Microsft has published for free download, in PDF format – very important and interesting book: A Guide to Claims-Based Identity and Access Control – Authentication and Autorization for Services and the Web. The book has been writen by six authors: Dominic Baler, Vittorio Bertocci, Keith Brown, Scott Densmore, Eugenio Pace and Matias Woloski in very famous series Patterns & Practices.

This book is in medium size (19 MB and about 411 pages). But You can find  alot of informations inside. Lets look for the list of chapters:

  • An Introduction to Claims
  • Claims-Based Architectures
  • Claims-based Single Sign-on for the Web and Windows Azure
  • Federated Identity for Web Applications
  • Federated Identity with Windows Azure Access Control Service
  • Federated Identity with Multiple Partners
  • Federated Identity with Multiple Partners and Windows Azure Access Control Service
  • Claims Enabling Web Services
  • Securing REST Services
  • Accessing Rest Services from a Windows Phone Device
  • Claims-Based Single Sign-On for Microsoft SharePoint 2010
  • Federated Identity for Sharepoint Applications

and appendixes:
A – using fedutil
B – message sequences
C – industry standards
D – certificates
E – windows azure appfabric access control service (acs)
F – sharepoint 2010 authentication architecture and considerations

In the same time whe you will reading this book, you can go to CodePlex site when you find more stuff for this book {THNX Ziemek} – go directly HERE (for CodePlex) and HERE (for downloading book).

[EN] St.Nicolas Gift for SharePoint Maniacs

BOOKLET__the-sharepoint-2010-handbook-vol-1If You are not SharePoint Maniacs…  You can still back to right way. We are full of forgiveness. But If Your friend, brother, sister, mother, father,  lover, boy- or girl-friend, husband or wife is SharePoint Oriented Person and You like or love She or He… don’t wait. Just order one of the new SharePoint book prepared by worldwide experts in this technology.

The SharePoint 2010 Handbook: A Collection of Short Chapters for Delivering Successful SharePoint Projects (Volume 1)

It is new SharePoint oriented books has been written by thirteen great authors, which delivered fantastic advices for SharePoint administrators, users, architects, passionates. What You can find inside (basen on my SharePoint Friend Veronique Palmer’s blog post):

SharePoint Server-based Data Storage and Data Access
by Paul Beck {LINKEDIN | BLOG | TWITTER}
SharePoint Adoption
by Veronique Palmer  {LINKEDIN | BLOG | TWITTER}
Social SharePoint
by Jasper Oosterveld  {LINKEDIN | BLOG | TWITTER}
The Art of SharePoint Success
by Symon Garfield {LINKEDIN | BLOG | TWITTER}
Creating Dashboards using Business Connectivity Services, SharePoint Designer and other related technologies
by Giles Hamson  {LINKEDIN | BLOG | TWITTER}
SharePoint 2010 Automated Code Deployment
by Suzanne George  {LINKEDIN | BLOG | TWITTER}
Exploring Different Options for Implementing SharePoint Solutions
by Rene Modery  {LINKEDIN | BLOG | TWITTER}
SharePoint Security and Authentication Notes
by Conrad Grobler {LINKEDIN}
InfoPath 2010 – What is new?
by Ashraf Islam {LINKEDIN}
Governance in SharePoint
by John Stover  {LINKEDIN | BLOG | TWITTER}
SharePoint Test Environments
by Justin Meadows  {LINKEDIN}
Building Business Intelligence Solutions with SharePoint 2010
by Mark Macrae  {LINKEDIN | BLOG | TWITTER}
Structuring a SharePoint 2010 Practice
by John Timney  {LINKEDIN | BLOG}

Interesting, right? Exciting? Of course! You can order this 448 pages (!!) book at Amazon.com in really awesome price: $15.63.

Post Scriptum: Psst… It’s Volume One

[EN] REVIEW: SQL In A Nutshell 3rd edition

Authors: Kevin E. Kline, Daniel Kline, Brand Hunt
Pages: 592
Publication Year: 2009
Level: Intermediate / Advance
Review by Tobiasz Janusz Koprowski "Anorak" originally for wss.pl

BOOKLET__SQLinaNutshell_KevinK.KlineKevin Kline has already accustomed us to its flagship “products” which is a kind of guide to the most popular versions of SQL. Kevin, based on his many years of experience in working with databases using SQL, but the not only Microsoft databases, allowing the reader to a broader view on this issue. In a statement made in November 2008 the third edition of the book "SQL in a nutshell, quick start guide" the author devotes to describing both primary and a bit more advanced syntax, commands, and aspects of databases: Microsoft SQL Server 2008, Oracle 11g, MySQL 5.1, and PostgreSQL 8.3. It may be recalled that the first edition appeared in 2001, while the second edition in 2004.
 
Based on the latest ANSI standard syntax (ANSI SQL2003) in a concise and understandable manner, the author also describes the same model of a relational database (RDBMS), and introduces us to the world of basic, yet essential concepts. In addition to the syntax of each is given, whether and how they are supported: supported, supported with limitations, supported by a variant, not supported.
 
In this book you will find among others:

  • Brief history of the model, relational databases, including current and previous SQL standards;
  • Basic concepts necessary to understand relational databases and SQL;
    Alphabetic collection of SQL statements, in accordance with ANSI SQL2003;
  • The implementation of each command in the various types of databases: MySQL, Oracle, PostgreSQL, SQL Server;
  • Alphabetical collection of references to the ANSI SQL2003 features, along with descriptions of applications;
  • Description of functions specific to the platform and at the same time unique in the implementation.

At nearly six hundred pages consist of four chapters and the appendix:
Chapter One – The History and edit SQL implementations (the relational model, the standard ANSI SQL standards for history and "dialects" of the variety of that language);
Chapter Two – Fundamental concepts (a description of the different types of databases, categories, syntax, description and specific SQL2003 standard for platform-specific differences, limitations);
Chapter Three – SQL commands (arranged alphabetically, containing detailed descriptions and references to the ANSI standard, and descriptions of the differences in implementation for various platforms)
Chapter Four – functions in SQL (also, with arranged alphabetically, and containing references to the differences in implementations on several different platforms);
Appendix – contains an ordered tabulated set of keywords, both common to all environments, as well as broken a keyword for a standard SQL2003, MySQL, Oracle, PostgreSQL, SQL Server.

One of the hundreds examples The DROP Statements (full explanation  you’ll find on pages 224-254) with variations in any kind of SQL are below:

MySQL
        DROP { {DATABASE | SCHEMA} | FUNCTION | INDEX [ONLINE | OFFLINE] | PROCEDURE | [TEMPORARY] | TABLE | TRIGGER | VIEW }
        [IF EXIST] object_name[,…]
        [ RESTRICT | CASCADE ]

Oracle
        DROP { DATABASE | FUNCTION | INDEX | PROCEDURE | ROLE | TABLE | TRIGGER | TYPE [BODY] | VIEW }
        object_name

PostgreSQL
        DROP { DATABASE | DOMAIN | FUNCTION | INDEX | ROLE | SCHEMA | TABLE | TRIGGER | TYPE | VIEW }
        [IF EXIST]
        object_name
        [ CASCADE | RESTRICT ]

SQLServer
        DROP { DATABASE | FUNCTION | INDEX | PROCEDURE | ROLE | SCHEMA | TABLE | TRIGGER | TYPE | VIEW } object_name

In my opinion this book can be recommended strongly both SQL beginners supporters (regardless of the variety) and experienced administrators, especially if you need to somehow combine business and work on such as Microsoft SQL Server and Oracle.

KEEP THIS BOOK ON YOUR DESK ANYTIME AND ANYWHERE