Sudhir's SQL SERVER Blog

Mastering KnockoutJS details

2015-04-21T11:51:00.000+05:30

Hello Friends,

Book: Mastering KnockoutJS
Author: Timothy Moran
Publisher: Packt Publishing

Book contents

Chapter 1: Knockout Essentials, covers the environment setup and basic use of the Knockout library. It also covers data binding, observables, binding handlers, and extenders, and demonstrates a simple Knockout Contacts List application.

Chapter 2: Knockout Essentials, covers the environment setup and basic use of the Knockout library. It also covers data binding, observables, binding handlers, and extenders, and demonstrates a simple Knockout Contacts List application.

Chapter 3: Extending Knockout with Preprocessors and Providers, teaches you how to use node and binding preprocessors and binding providers to customize Knockout's syntax. It also explores the Knockout Punches library.

Chapter 4: Application Development with Components and Modules, explains how to use RequireJS Asynchronous Module Definitions (AMDs) with Knockout to create organized, modular viewmodels. It also teaches you how to use the new Knockout components

Chapter 5: Durandal – the Knockout Framework, explores the basics of the Knockout-based Durandal framework. This chapter covers composition, routing, modal dialogs, and custom widgets.

Chapter 6: Advanced Durandal, continues looking at the use of the Durandal framework. This chapter covers events, advanced composition, nested routers, custom dialogs, and the observable plugin.

Chapter 7: Best Practices, takes a deep dive into the inner workings of Knockout. It includes dependency detection and the publish/subscribe implementation, observable inheritance, the template engine, and a complete Knockout utility (ko.utils) reference.

Chapter 8: Plugins and Other Knockout Libraries, gives you an overview of the recommended patterns and practices for Knockout developers.

Chapter 9: Under the Hood, covers several popular Knockout plugins, including Knockout validation, Knockout mapping, and the new Knockout-ES5 plugin.

Some interesting facts: Knockout is a library designed for Model-View-ViewModel (MVVM) development. This pattern, a descendant of Martin Fowler's Presentation model, encourages the separation of User Interface (UI) from the business logic of the domain model. To facilitate this separation, Knockout provides the three necessary components for implementing this pattern, namely, a declarative syntax for the view (the data-bind HTML attribute), a mechanism to notify changes from the viewmodel (the observable object), and a data binder to mediate between the two (Knockout's binding handler).

Click here to read/download the book.

Initial review of "SQL Server 2014 Development Essentials" Book

2014-10-22T00:33:00.000+05:30

Hello friends,

Today I would like to give an initial review of "SQL Server 2014 Development Essentials" by Basit Farooq published by Packt Publishing. This book covers both basics and advance topics of SQL Server 2014.

Following are the 6 chapters of the book:

Microsoft Database Design Principles
Understanding DDL and DCL statements in SQL Server
Data Retrieval using T-SQL statements
Data Modification using SQL Server T-SQL statements
Understanding Advanced Database programming objects and Error handling
Performance basics

The author starts the book with basics of database, like database design principles, relationships, normalization & basic architecture of SQL Server like Pages, Extents and Transaction Log architecture.

Next is understanding how to write queries. Here he starts by explaining concepts about SQL, T-SQL, DDL, DML & DDL statments. Then he explains about various system databases and various database recovery models. He then deep dives into the world of writing different statements and explain it with the help of various examples like creating database, modify database, create, modify, drop table object. Then explains about DCL statements using various examples.

In data retrieval, he explains how to write queries using T-SQL to retrieve data and how to apply various techniques to retrieve data like Group by, Order by etc. Then he explains about adding, updating & deleting data using delete, Insert or update statements. I would like to highlight that he has tried to include as many examples to ensure people can practice it & understand the concepts easily.

Next he goes on to explain about various database objects like Views, Stored Procedures, Triggers and also give an insight & purpose of each object.

Performance is something, which is very critical for any developer or DBA as that is always an area people don't have in-depth knowledge. The author has put extra efforts to set a strong base for anyone who want to learn about basics of Performance Tuning, how to start it & what to have in hand to start practicing it. Then he goes on to explain about Indexes & what are the performance impacts of various indexes, basics of checking performance of any query & what can be done to know if there is scope to further fine tune query or not.

Overall I would like to say that this is a small & nice book as compared to various large books available in market, this book touch upon a lot of critical areas deeply and ensure that the basics are set correctly before a developer or DBA start looking at advance topics.

I will post more details about the book later after it's published. In order to preview the book, click here.

Happy Learning
Sudhir

SQL SERVER 2014 CTP1

2013-06-27T23:00:00.003+05:30

Hi,

SQL Server 2014 CTP1 is here. SQL Server 2014 delivers mission critical performance across all workloads with in-memory built-in, faster insights from any data with familiar tools, and a platform for hybrid cloud.

Microsoft SQL Server 2014 builds on the mission-critical capabilities delivered in the prior release by providing breakthrough performance, availability and manageability for your mission critical applications. SQL Server 2014 delivers new in-memory capabilities built into the core database for OLTP and data warehousing, which complement our existing in-memory data warehousing and BI capabilities for the most comprehensive in-memory database solution in the market.

SQL Server 2014 also provides new disaster recovery and backup solutions with Windows Azure, enabling customers to use their existing skills with the on-premises product offerings to take advantage of Microsoft’s global datacenters. In addition, SQL Server 2014 takes advantage of new Windows Server 2012 and Windows Server 2012 R2 capabilities to give you unparalleled scalability for your database application in a physical or virtual environment.

Click here to download SQL SERVER 2014 CTP1

Will come back with more information.

Enjoy

Transparent Data Encryption Inside and Out In SQL 2012 Webinar

2013-01-03T12:22:00.004+05:30

Guys,

If you are keen to know more about TDE (Transaction Data Encryption) then watch this webinar from Pragmatic.

Speaker: Bradley Ball

Security is a very important part of your job and in how data is utilized. We have many tools to make data more secure, and starting in SQL 2008 we were able to add Transparent Data Encryption to that list. Find out What it does and What it doesn’t do, How it effects Read-Only Filegroups, Performance, Compression (Backup and Row/Page), What the X.509 Encryption Standard is and Why you should be careful of what you store and where, and other Advance Features as well as some tips on how to manage it.

Sudhir's SQL SERVER Blog

Mastering KnockoutJS details

Initial review of "SQL Server 2014 Development Essentials" Book

SQL SERVER 2014 CTP1

Transparent Data Encryption Inside and Out In SQL 2012 Webinar

How to manage Big Data, Tips and Tricks Webinar

Test Driven Development (TDD) in C# using NUnit Webinar

Performance Tips and Tricks with SQL Server, real cases with developers Webinar

Performance Tuning SSIS Webinar

SQL Server 2012 SSIS: New and Improved Features Webinar

Master Data Services in SQL Server 2012 Webinar

Introduction to PowerPivot webinar

Introduction to Master Data Services Webinar

Introduction to Design Patterns Webinar

SQL Server Internals and Architecture Webinar

Introduction to PowerPivot Webinar

SQL Server Data Compression Webinar

SSIS 2012 Administration Webinar

Optimizing SQL Server 2012 Webinar

Getting Started with SSRS 2012 Webinar

Using the Change Data Capture in SQL Server 2012 Webinar

Intro to SSIS for Newbies and Beginners: Building Your First Package Webinar

Creating your first Control Flow Task in SSIS Webinar

Introduction to Parameters in SSIS 2012 Webinar

Page and Row Compression Internals in SQL 2012 Webinar

Storage Performance for SQL Server Databases Webinar