Browse by Tags

All Tags » SQL Server (RSS)

What’s new in SQL Server ‘Denali’ Management Studio. by Jalpesh P. Vadgama

Before sometime Microsoft has launched SQL Server Denali CTP a new version of SQL Server. I have downloaded it and install it on my machine. I have found variety of new features in SQL Server. Today I am going to explore some of the new features in SQL...

Installing SQL Server 2011(Denali) CTP Step by Step Overview by Jalpesh P. Vadgama

Today I have downloaded the SQL Server 2011 CTP and I am very excited about the new features provided by it. I am going to post new features of the SQL Server 2011(Denali) CTP in future post. Today I am going to post about how install SQL Server 2011...

TSQL Quiz 2011 on beyondrelational.com by Jalpesh P. Vadgama

One of the my friend Jacob Sebastian running a SQL Server TSQL quiz on his site beyondrelational.com. This is a great opportunity to learn TSQL and win great price Like Apple IPad and other lots of cool stuff. So if you are expert and if you learning...

GUID Vs Int data type as primary key by Jalpesh P. Vadgama

Recently one of my friend ask me when I should go for GUID and When I should go for Int as primary key in table. So decided to write a blog post for it. Here are advantages and disadvantage of the GUID and INT. INT Data Type: Advantages: Its required...

Binding A Custom Entity Class to stored procedure using Linq-To-SQL by Jalpesh P. Vadgama

I have already written several post about Linq its a great ORM that we can use in various way. The purpose of this post to demonstrate How we can bind custom entity to stored procedure result with use of Linq-To-SQL. Let’s go through it and you will realize...

Visual Studio –>Add Database –> Named pipe Provider Error for SQL Server by Jalpesh P. Vadgama

Recently I have been working on a article for my blog for that I just tried to add a database file on my solution with visual studio and I have received following error. An error has occurred while establishing a connection to the server. (provider: Named...

TSQL Challenges on beyondrelational.com by Jalpesh P. Vadgama

My friend and Guide Jacob Sebastian who is an Microsoft SQL Server MVP running a very popular series of TSQL on his site beyondrelational.com. If you know something about SQL Server then this challenge is for you. And if you are master of SQL then this...

Reboot require check fails while installing SQL Server 2008 R2 Express by Jalpesh P. Vadgama

Before some days I was installing SQL Server 2008 R2 Express edition on my machine and every time when it runs checks for required settings It was failing giving error reboot required. I have rebooted my machine several time and result was same. After...

Zip operator in Linq with .NET 4.0 by Jalpesh P. Vadgama

Microsoft .NET framework 4.0 is having many features that make developers life very easy. Its also provides some enhancement to Linq also. I just found a great operator called Zip which merge the sequence of two entities. Here is the explanation of Zip...

ASP.NET 4.0- CompressionEnabled Property in session state 4.0 by Jalpesh P. Vadgama

Hello Guys, This blog has been quite for few days. Because i was busy with some personal and professional work both and that’s why i am not able to work on writing blog posts which i have discovered in last few days. Here is one features of asp.net 4...
Filed under: ,
More Posts Next page »