Archive for December, 2010

My Blog New home December 31st, 2010

Vinod Kumar

Welcome back to my new Blog space (Vinod Kumar)

WHY: If you are reading this post, you have surely landed into my new blog space. Yes, I did move away from my old location at SQLXML. Interestingly, the reasons were simple – I was the only person blogging on that space and I had to finally move away because even Bryant had moved away from that space to his very own domain.

With so much happening on the blog space, there is another change in the work I will be doing inside Microsoft from mid-Jan 2011. More about that in the next 15-20 days when things become clear and concrete. I thought with so many changes around, this change will also be a good thing to initiate.

WHERE: Least assured, you can be confident that I will find more time to blog, share and be active on this blog space. My domain of ExtremeExperts has been around for quite sometime and in some forms has been my Identity also since 2003. So I thought of going ahead with a sub-domain for my blogs. Makes it easy for my readers to remember just one Identity to reach me.reverse-migration

WHEN: Yes, there will changes on the blog from skins, plug-ins, format etc in the coming weeks as I get going with the tweaking process before I lock on something. I surely request your kind patience while the mayhem happens on my blog.

There are still some old linking on few posts which I plan to somehow change slowly but surely as and when I get hold of them. So keep sending those broken links to me and I will update them …

Yes, I am on WP hosting now guess quite a lot of you have also used the same. So are there interesting plugins I need to take a look at? Please feel free to recommend and give pointers. Will want to try and lock on things as fast as possible.

TODO: Please update all your bookmarks to point to this new location. Also update all your RSS / Atom feeds to this new location.

Continue reading...


Microsoft SQL CE 4.0 CTP 2 for Windows Desktop December 17th, 2010

Vinod Kumar

SQL Server Compact 4.0 CTP2 is the second CTP of the next generation of embedded databases from the Microsoft SQL Server family. Besides enhancing the existing desktop scenarios, SQL Server Compact 4.0 enables a new scenario whereby it can be used as a database for starter ASP.NET websites. SQL Server Compact supports simple deployment and can be xcopy deployed in the website’s bin folder.

SQL Server Compact 4.0 CTP2 significantly enhances the following features that were released earlier with the SQL Server Compact 4.0 CTP1 :

  • Installs as part of the Microsoft WebMatrix Beta. Microsoft WebMatrix which is an integrated suite of tools designed to make it easy for developers to build dynamic and secure ASP.Net Web applications. The websites can then be deployed in one-click to a third party website hosting service provider and SQL Server Compact is privately deployed along with the Website in the Bin folder.
  • Operates within the ASP.NET environment to provide the database functionality needed by the starter websites and it can also run in the medium trust environments on the web server.
  • Ability to write paging queries using the OFFSET and FETCH T-SQL Syntaxes
  • Better Support for private deployment by having a single private folder (“%ProgramFiles(x86)%\Microsoft SQL Server Compact Edition\v4.0\Private”) containing both the AMD64 and X86 binaries
  • Support for SqlCeConnection.GetSchema method to provide the metadata information of the database and its child objects.
  • Better encryption facility with the use of the latest Encryption Algorithms (AES-256 and SHA2)
  • Tested and certified to ensure that SQL Server Compact can handle the starter website load effectively and efficiently without any hangs, crashes, exceptions etc.

Post feedback and questions to SQL Server Compact MSDN Forum.
For tips and tricks visit SQL Server Compact blog.

Continue reading...


Contained Database (CDB) in SQL Server December 16th, 2010

Vinod Kumar

CDB was introduced with the next version of SQL Server – Denali release. Read couple of blog posts on the same make this security related feature even more interesting. More on these on the blog –

Contained Database Authentication: Introduction

Contained Database Authentication: Monitoring and controlling contained users

Contained Database Authentication: How to control which databases are allowed to authenticate users using logon triggers

Contained Database Authentication in depth

Worthy reads from the SQL Server Security Blog. There is more to come your way …

Continue reading...


Patterns & practices- Windows Phone 7 Developer Guide December 15th, 2010

Vinod Kumar

Windows® Phone 7 provides an exciting new opportunity for companies and developers to build applications that travel with users, are interactive and attractive, and are available whenever and wherever users want to work with them. By combining Windows Phone 7 applications with on-premises services and applications, or remote services and applications that run in the cloud (such as those using the Windows Azure™ technology platform), developers can create highly scalable, reliable, and powerful applications that extend the functionality beyond the traditional desktop or laptop; and into a truly portable and much more accessible environment.

This guide describes a scenario around a fictitious company named Tailspin that has decided to include Windows Phone 7 as a client device for their existing cloud-based application. Their Windows Azure-based application, Surveys, is described in detail in a previous book in this series, Developing Applications for the Cloud on the Microsoft Windows Azure Platform. For more information about that book, see the MSDN® page at (

In addition to describing the client application, its integration with the remote services, and the decisions made during its design and implementation, this book discusses related factors, such as the design patterns used, the capabilities and use of Windows Phone 7, and the ways that the application could be extended or modified for other scenarios.

After reading this book, you will be familiar with how to design and implement applications for Windows Phone 7 that take advantage of remote services to obtain and upload data while providing a great user experience. The guide includes :-


"Introducing Windows Phone 7" provides an overview of the platform to help you understand the requirements and advantages of creating applications for Windows Phone 7. It provides a high-level description of the possibilities, features, and requirements for building applications for Windows Phone, and it includes references to useful information about designing and developing these types of applications. It also includes a glossary of terms commonly used in mobile application development. It’s probably a good idea to read this chapter before moving on to the scenarios.

"Designing Windows Phone 7 Applications" discusses planning and designing applications for Windows Phone 7. It covers the run-time environment and life cycle events for your application, how to maximize performance on the phone, and considerations for the user interface, resource management, storage, connectivity, and more.

"The Tailspin Scenario" introduces you to the Tailspin company and the Surveys application. It describes the decisions that the developers at Tailspin made when designing their application, and it discusses how the Windows Phone 7 client interacts with their existing Windows Azure-based services.

"Building the Mobile Client" describes the steps that Tailspin took when building the mobile client application for Windows Phone 7 that enables users to register for and download surveys, complete the surveys, and upload the results to the cloud-based service. It includes details of the overall structure of the application, the way that the Model-View-ViewModel (MVVM) pattern is implemented, and the way that the application displays data and manages commands and navigation between the pages. The following chapters describe the individual features of the application development in more detail.

"Using Services on the Phone" discusses the way that the Windows Phone 7 client application stores and manipulates data, manages activation and deactivation, synchronizes data with the server application, and captures picture and sound data.

"Connecting with Services" describes how the client application running on Windows Phone 7 uses the services exposed by the Windows Azure platform. This includes user authentication, how the client application accesses services and downloads data, the data formats that the application uses, filtering data on the server, and the push notification capabilities.

"Interacting with Windows Marketplace" describes how you can distribute and sell your applications through Windows Marketplace, and the restrictions and conditions Windows Marketplace places on your applications and content.

The appendices include additional useful information related to the topics described in the rest of the chapters. The appendices cover getting started with the Windows Phone developer tools; testing your applications; information about the development environments (Silverlight and XNA® development platform); a reference section for programming device capabilities, such as location services, messaging features, and the camera; information about the Prism Library for Windows Phone 7; and an overview of data and file synchronization using emerging technologies such as Microsoft Sync Framework.

Click here to download this release.


Walking on the same lines, here are some great free online Training on Making Windows Phone 7 Apps & Games. Don’t forget to check all the goodness from Channel9 Smile.

Also another must have for Windows Phone 7 development will be the Free ebook: Programming Windows Phone 7, by Charles Petzold. Feel free to download the book with the code. Will assure you it will be worth it !!!

Continue reading...


SQL, MOSS and Remote Blob Storage (RBS) December 14th, 2010

Vinod Kumar

When users store more documents and larger media documents in SharePoint libraries, performance, scalability, and manageability challenges occur for SharePoint administrators. The Remote BLOB Storage (RBS) feature in SharePoint Server 2010 addresses these challenges. This paper explains the RBS feature as it applies to SharePoint Server 2010 and analyzes its performance impacts on key attributes of a SharePoint farm such as database size, database backup size, transaction response times, and backup/restore time.

Read more from the whitepaper directly.

Continue reading...