Wriju's BLOG

.NET, Cloud and everything

SQL Server in Azure VM High Availability and Disaster Recovery

This is the most commonly asked question on SQL Server in Azure Virtual Machine. How to maintain SQL Server up and running all the time. Options are High Availability (Azure) 1. AlwaysOn Availability Groups (http://msdn.microsoft.com/en-us/library/azure/dn249504.aspx) 2. Database Mirroring (http://msdn.microsoft.com/en-us/library/azure/jj870961.aspx) Disaster Recovery (Azure) 1. AlwaysOn Availability Groups (http://msdn.microsoft.com/en-us/library/azure/dn690122.aspx) 2. Database Mirroring (http://msdn.microsoft.com/en-us/library/azure/jj870960.aspx) 3. Backup and Restore… Read more

Windows 8 App : SQL Blogs

Let me introduce my another venture to the Windows Store apps. This is dedicated to SQL Server. Collection of blogs about SQL Server Download link http://apps.microsoft.com/windows/app/sql-blogs/fe64c671-9b80-4bcb-b96c-9746a2f8d477 Please install and share your feedback via setting charm Win+C and choose “setting” then “Rate and Review” Your wish is the next release.   Namoskar!!!… Read more

SQL Server Performance Tips

SQL Server Performance Series – Part 1 – Introduction to Performance Tuning http://www.msteched.com/2010/Europe/DAT340 SQL Server Performance Series – Part 2 – Server and Database Tuning http://www.msteched.com/2010/Europe/DAT341 SQL Server Performance Series – Part 3 – Query and Index Tuning http://www.msteched.com/2010/Europe/DAT342 Namoskar!!!… Read more

Generate Dummy Test Data using Data Generation Plan

Most of the time we struggle to get some dummy data for various types of testing. Data Generation Plan in Visual Studio 2010 helps to achieve it. It not only fills the tables based on the number of rows selected by us it also takes care of the relationship if any. One thing to remember… Read more

Comparing Two SQL Server Schema using Visual Studio 2010

When you have two SQL Sever Databases and need to find the differences, Visual Studio comes really handy. Under Visual Studio 2010’s menu Data > Schema Compare. Once you choose New Schema Comparison   Then you choose your databases. After you choose it you can also set the Schema Compare Settings. Once you press OK…. Read more

SQL Server 2008 R2 Management Studio designer was not allowing me to add primary key to a column of an empty table

What the heck!!! Then finally Amar did help me to get it done. Simple “option”. Life has too many “options”. Tools > Options You need to just uncheck the option “Prevent saving changes that require table re-creation” Namoskar!!!… Read more

ADO.NET and Data Articles by John Papa

Many of you might be following John Papa’s article on Data and related topics. Myself have came across many of his and are still following. I would like to share a list of articles by him published in MSDN Magazine and available online for you. Data Points: Designing an Entity Data Model With the Entity… Read more

LINQ to SQL vs. ADO.NET – A Comparison

ADO.NET is our contemporary data access component and now we have written many applications. Now there has been a lot of talk on LINQ to SQL. So we are little skeptical about this component and trying to find some relation between existing ADO.NET technology.   Purpose of this post is to give some quick brief… Read more

LINQ to Entity : Querying data using ADO.NET Entity Framework

ADO.NET Entity Framework have evolved since we have released it first time. Now with the Visual Studio 2008 if you install the .NET Framework 3.5 SP1 and Visual Studio 2008 SP1 you will get the fully functional version of ADO.NET Entity Framework. This is post Beta 3 release. To create a .edmx file you have… Read more

LINQ to SQL: Making it N-Tier

You can create your application use LINQ to SQL and make it N-Tier. Go ahead and watch out the MSDN Documents N-Tier and Remote Applications with LINQ to SQL LINQ to SQL N-Tier with ASP.NET LINQ to SQL N-Tier with Web Services LINQ to SQL with Tightly-Coupled Client-Server Applications Implementing Business Logic (LINQ to SQL)… Read more

LINQ to SQL : FAQ Answer By Matt Warren

Wonderful composition of FAQ is available at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2769747&SiteID=1 by Matt Warren.   Q: How do I get default values from the database when inserting new entities? A: LINQ to SQL does not support using default values from the database.  The values in the entity at the time SubmitChanges is called are used instead.  You can… Read more