Tuesday, April 21, 2015

Mastering KnockoutJS details

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.

Wednesday, October 22, 2014

Initial review of "SQL Server 2014 Development Essentials" Book

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:
  1. Microsoft Database Design Principles
  2. Understanding DDL and DCL statements in SQL Server
  3. Data Retrieval using T-SQL statements
  4. Data Modification using SQL Server T-SQL statements
  5. Understanding Advanced Database programming objects and Error handling
  6. 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


Thursday, June 27, 2013

SQL SERVER 2014 CTP1

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

Thursday, January 3, 2013

Transparent Data Encryption Inside and Out In SQL 2012 Webinar

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.


Happy Learning

Sudhir

How to manage Big Data, Tips and Tricks Webinar

Guys,

Do you have big data to manage in your database, then watch this webinar to ensure you take care of big data properly.

Speaker: Jorge Segarra

In this session join Jorge Segarra as he dives into Big Data: What it means, if you’ve got it and how to handle it. Jorge will Explore how data is growing in the enterprise, review challenges and current best practices for handling large data volumes in BI, look at industry solutions that help enable massively parallel processing, and help you understand how to take your organization’s data to the next level.


Happy Learning

Sudhir

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

Guys,

This will be interesting. If you are keen to know about Test Driven Development (TDD) in C# using NUNIT. Then this is the webinar for you.

Speaker: Mark Brown

We will provide an introduction to the practice of test driven development, how it compares to unit testing, and what it does not cover. We will build an example using test driven development to illustrate its use. We will identify other types of testing and the tools used for them.


Happy Learning

Sudhir

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

Guys,

Watch this webinar on "Performance Tips and Tricks with SQL Server, real cases with developers" This got real case scenarios & various options that can be used on a daily basis.

Speaker: Nabeel Derhem

Application developers don't care much about how SQL Server executes their queries as long as they get what they want. This session introduces common real case scenarios where developers end up with troublesome queries and bad performance. Explanation is linked to a discussion of alternative effective ways to handle such scenarios.


Happy Learning

Sudhir

Performance Tuning SSIS Webinar

Hi,

To understand various options to improve performance of a SSIS package, watch this webinar from Pragmatic work.

Speaker: Shawn Harrison


SSIS is a powerful ETL tool, but by nature ETL developers are always looking for better performance. In this hour long presentation Shawn will cover many basic options and features that you can use to performance tune any SSIS package. Who wouldn’t want better package performance?


Happy learning

Sudhir

SQL Server 2012 SSIS: New and Improved Features Webinar

Guys,

Watch this webinar to find out what's new in SSIS in SQL Server 2012.

Speaker: Anish Sana

With SQL server 2012 release around the corner, there’s been a hype around the new features that comes with this awesome release. For this webinar we’ll be touching on some of the new features in SQL Server 2012 SSIS and how that will improve on development as well as look into the enhancements made to existing features from the previous versions.


Happy Learning

Sudhir

Master Data Services in SQL Server 2012 Webinar

Guys,

Another webinar on Master Data Services in SQL Server 2012 by pragmatics.

Speaker: Arie Jones

Most DBAs at one time or another have been taught the importance of master data management(MDM), which is comprised of a set of processes and tools in order to keep your non-transactional data in a consistent state. However, with today’s fast paced environment and tightening budgets most DBAs lack the resources to properly implement it. With the upcoming release of SQL Server 2012, Microsoft has taken their second swipe at providing a tool known as Master Data Services(MDS) to aid the DBA in this endeavor. In this session, you will learn the how Master Data Services is implemented in SQL Server 2012, setting up models, working through the Excel plug-in, and utilizing DQS and business rules to help with that dirty data. This session will definitely be an eye opener for some that were on the fence with the first release and those that are coming into the platform with a fresh set of eyes!


Happy Learning

Sudhir

Introduction to PowerPivot webinar

Guys,

Powerpivot / Self Service BI is an excellent tool for BI purpose. Here is a webinar on "Introduction to PowerPivot" from Pragmatic Works.

Speaker:  Brian Knight

In this session, you’ll learn how to use PowerPivot to create self-service analytics in your organization. You’ll see how Office 2010 and SQL Server 2008 R2 will help your users answer their own questions and bring together datasets that may be heterogeneous like a SQL Server table and data feed from a website. Then, you’ll see how to take that data and create a striking report for your end users and collaborate with the data in SharePoint.


Happy Learning

Sudhir

Introduction to Master Data Services Webinar

Guys,

It's been long since Microsoft introduced MDS. To understand the basics of it, we can watch webinar on "Introduction to Master Data Services" by Pragmatic works.

Speaker: Jose Chinchilla

In this session, Jose will do an overview of Master Data Services and how it can be leveraged with SSIS and SharePoint 2010 to accomplish a Master Data Management framework. Jose will cover concepts like models, entities, attributes and attribute collections, explicit and derived hierarchies, subscription views and business rules. Jose will also demo how to load an MDS entity with SSIS and how to kick start a workflow process in SharePoint 2010 when a business rule is not met.


Happy Learning

Sudhir

Introduction to Design Patterns Webinar

Guys,

To understand basics of Design Patterns, we can watch webinar on "Introduction to Design Patterns" from Pragmatic works.

Speaker: Ben Evans

What is a design pattern? Why would I need it? Well in this session these topics will be covered as we explore a few of the common patterns and why you should know about them.


Happy Learning

Sudhir

SQL Server Internals and Architecture Webinar

Guys,

This is one of the best webinars if you are keen to know about "SQL Server Internals and Architecture"

Speaker: Kevin Kline

This fast paced session will take you through many aspects of the internal operations of SQL Server. if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like:What’s different about 32- and 64-bit systems? What are the various areas of memory inside of SQL Server? How are queries handled behind the scenes? What does SQL Server do with procedural code, like functions, procedures, and triggers? What happens during checkpoints? Lazywrites? How are IOs handled with regards to transaction logs and database? What happens when transaction logs and databases grow or shrinks?

Click here to watch it.

Happy Learning

Sudhir

Introduction to PowerPivot Webinar

Guys,

Watch this webinar on "Introduction to PowerPivot" from Pragmatics.

Speaker: Devin Knight

Come join Devin as he explores the new PowerPivot technology, how to configure and get it up and running and build exciting reports in a very short amount of time. This will be an all demo session and lots of fun!


Click here to watch it.

Happy Learning

Sudhir

SQL Server Data Compression Webinar

Guys,

To understand SQL Server Data Compression, watch this webinar from Pragmatic Work.

Speaker: Kathi Kellenberger

SQL Server data compression was introduced with 2008. Of course, compression can save you storage space, but many DBAs do not know that you can get a performance boost from compression as well. By attending this webinar, you will learn about the two levels of compression, how to estimate the benefits of compression, and how to implement it.


Happy Learning

Sudhir

SSIS 2012 Administration Webinar

Guys,

Another webinar on "SSIS 2012 Administration" from Pragmatic works.

Speaker: Mike Davis

In this session you will Learn how to deploy, secure, execute and monitor SSIS packages in the new SSIS 2012. Learn how to use the new SSIS catalog and understand the new SSISDB. Afterwards you will have a thorough understanding of SSIS administration in SQL 2012.


Happy Learning

Sudhir

Optimizing SQL Server 2012 Webinar

Guys,

Another webinar on "Optimizing SQL Server 2012" by Pragmatic Works.

Speaker: Gareth Swanepoel

An "accidental DBA" is a SQL Server administrator who has been thrust into the task without having the experience or know how required to keep SQL running at peak performance. This is not their fault and is purely due to the fact that they have not been exposed to it before. If you are a DBA and find yourself wondering how hardware changes affect performance or have questions relating to the performance implications of partitioning or compression, then this session is for you. I will be exploring topics such as Memory configuration, CPU options and IO considerations.


Happy Learning

Sudhir

Getting Started with SSRS 2012 Webinar

Guys,

Here is another webinar on "Getting Started with SSRS 2012" by Pragmatic works.

Speaker: Chris Albrektson

In this session Chris will give an introduction to reporting with Microsoft SQL Server Reporting Services (SSRS) 2012. You’ll learn everything you will need to know to get started when creating your first reports using the latest release of SSRS. During this session we will also discuss and review the latest features and updates that have been included such as Power View, Data Alerts, Rendering Formats, and SharePoint integration.


Happy Learning

Sudhir

Using the Change Data Capture in SQL Server 2012 Webinar

Guys,

Here is another webinar from Pragmatic Works on "Using the Change Data Capture in SQL Server 2012"

Speaker: Shawn Harrison

Do you have problems keeping data in sync? Do wish there was an easy way to consistently insert, update and delete data between source tables? Well, this webinar is for you. In this session, Shawn will explain the Change Data Capture and demonstrate how it’s used. Come see how little effort you will have to put forth when keeping your data in tune!


Click here to watch it.

Happy Learning

Sudhir