DotNetShoutout

ashishgilhotra

Name:	ashishgilhotra
Score:	1,695.33
Last Seen:	619 days, 4 hours, 40 minutes ago
Member Since:	7 April, 2010

6
Shouts

Shout it

View Call Hierarchy window in Visual Studio 2010

published 754 days, 3 hours, 38 minutes ago posted by

dhara 756 days, 11 hours, 18 minutes ago

Visual studio 2010 Ultimate is great IDE(Integrated Development Environment) and I am loving more and more whenever I found some thing new. While doing some Code and Review and other stuff with Visual Studio 2010 I have found one of most interesting feature in Visual Studio 2010 called “Called Hierarchy... (more)

category: Web Dev | clicked: 0 | 1 comment | | source: beyondrelational.com

tags: .NET, Visual Studio 2010, ASP.NET

6
Shouts

Shout it

Pin features while debugging in Visual Studio 2010

published 754 days, 3 hours, 38 minutes ago posted by

dhara 756 days, 11 hours, 17 minutes ago

Visual Studio 2010 is one of most awesome tool to debug Microsoft.NET related code. I have found one more interesting feature with the Visual studio 2010. That is called Pin Data Tip feature. This features can be very useful when you are debugging the code with loops. Normally when you debug with the... (more)

category: Web Dev | clicked: 0 | 1 comment | | source: beyondrelational.com

tags: .NET, Visual Studio 2010, ASP.NET

6
Shouts

Shout it

Creating a simple Context Sensitive Help for ASP.NET Controls using jQuery

published 756 days, 9 hours, 17 minutes ago posted by

dhara 757 days, 9 hours, 27 minutes ago

In this blog post I am going to explain how we can create a simple Context Sensitive Help for ASP.NET Controls using jQuery . This has been done based on the selection of a controls in a ASP.NET Web Form. On control selection / focus jQuery Loads a HTML Content from a remote file, then it’s apply... (more)

category: Web Dev | clicked: 16 | comment | | source: beyondrelational.com

tags: .NET, jQuery, ASP.NET

6
Shouts

Shout it

Adding labels to breakpoint in visual studio 2010

published 756 days, 9 hours, 17 minutes ago posted by

dhara 757 days, 9 hours, 28 minutes ago

With visual studio 2010 Microsoft has given a new features called to add/edit label in break point. This features comes very handy when you are having very large code to debug and You are having so many break points to debug. So, You can add the label to various break point and then use this label to... (more)

category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com

tags: .NET, Visual Studio 2010, ASP.NET

5
Shouts

Shout it

Ways to get top records from table using TOP clause in SQL Server

published 756 days, 9 hours, 17 minutes ago posted by

dhara 757 days, 9 hours, 29 minutes ago

We confused sometimes during write the code logic for SQL queries when we required some of top records from tables to implement in logic. This is very basic thing for the development and here i am going to demonstrate some of the options to get top records using TOP clause from table in various ways... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL

6
Shouts

Shout it

Historical Debugging (Intellitrace) on Visual Studio 2010 Ultimate Part-2

posted by

dhara 758 days, 11 hours, 27 minutes ago

In the first post I have explained how historical debugging will going to work and how we can enable the historical debugging. In this blog post I am going to take one real time scenario and then we will see the How historical debugging will work. Here I have selected the second option for Intellitrace ... (more)

category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com

| flag as spam

tags: .NET, Visual Studio 2010, ASP.NET

6
Shouts

Shout it

Windows Azure for Developers Task 6: Hosting ASP.Net Application in New Silverlight based Azure Portal

posted by

dhara 758 days, 11 hours, 27 minutes ago

Windows Azure Portal is now all new. It is made in Silverlight. Almost all information is on one page and almost all operation can be performed from same page. Properties Windows for Deployment, Role Instances, and Hosting Service provide extensive operation. Configuring OS to SWAP VIP can be performed... (more)

category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com

| flag as spam

tags: .NET, Windows Azure, Silvelight, ASP.NET

6
Shouts

Shout it

Track Changes and Advance Scroll Mode in Visual Studio 2010

posted by

dhara 758 days, 11 hours, 28 minutes ago

In the recent update of Visual Studio 2010 productivity power tool there are few new interesting features introduced. You can download the Productivity tool from http://bit.ly/9nybU6 . There are certain new features like Quick Find which allows you find and advance find dialog option with in code editor... (more)

category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com

| flag as spam

tags: .NET, Visual Studio 2010, ASP.NET

6
Shouts

Shout it

T-SQL Worst Practices – a compilation from Jacob’s session at Tech-Ed 2011 – Part 03 – Practices that contribute to execution errors

published 759 days, 36 minutes ago posted by

dhara 759 days, 10 hours, 41 minutes ago

This is in continuation to yesterday’s post on T-SQL worst practices that affect the performance of the results returned/processed. What have I done? T-SQL Worst Practices I am attempting to summarize all of the worst T-SQL practices that Jacob demonstrated at Tech-Ed 2011 (India). The summarization... (more)

category: Data | clicked: 1 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL

6
Shouts

Shout it

SPARSE Column - New feature of SQL Server 2008

published 759 days, 36 minutes ago posted by

dhara 759 days, 10 hours, 52 minutes ago

Recently during migration from SQL server 2005 to SQL Server 2008, I have utilized one more feature of SQL server 2008 and that is SPARSE column. It is used to reduce storage data in tables, mostly when tables having 20-30 % NULL values. It is really amazing feature and we can reduce storage space as... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL

6
Shouts

Shout it

Historical Debugging (Intellitrace) on Visual Studio 2010 Ultimate Part-1

published 759 days, 36 minutes ago posted by

dhara 759 days, 10 hours, 58 minutes ago

Visual studio 2010 Ultimate comes with one of most interesting function Historical Debugging which will change the way you debug. Let’s see what is Historical Debugging and How its works. How historical Debugging works? As as developer you have already faced some situations like Your tester reports a... (more)

category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com

tags: .NET, Visual Studio 2010, ASP.NET

6
Shouts

Shout it

Checking whether page is secure or not in ASP.NET or JavaScript

published 762 days, 5 hours, 40 minutes ago posted by

dhara 762 days, 12 hours, 33 minutes ago

Recently in one the project we require to check whether page is secure or not as we are going to open a new popup window from that page and that why we need to pass https protocol if we have that page secure. I have search lots of things on internet and I have found following ways of finding whether... (more)

category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com

tags: .NET, JavaScript, ASP.NET

5
Shouts

Shout it

T-SQL Worst Practices – a compilation from Jacob’s session at Tech-Ed 2011 – Part 02 – Practices that affect performance

published 762 days, 5 hours, 40 minutes ago posted by

dhara 762 days, 12 hours, 34 minutes ago

This is in continuation to yesterday’s post on T-SQL worst practices that affect the accuracy of the results returned/processed What have I done? T-SQL Worst Practices I am attempting to summarize all of the worst T-SQL practices that Jacob demonstrated at Tech-Ed 2011 (India). The summarization has... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL

6
Shouts

Shout it

SQL Server: High Logical Reads for Strange Worktable

published 762 days, 5 hours, 40 minutes ago posted by

dhara 762 days, 12 hours, 34 minutes ago

Few days back, on production database server, I found that logical reads value for a specific store procedure is much high then our expectations (benchmarks). I simply took the execution statement and executed with SET STATISTICS IO ON so I can get, which part is forcing more logical reads and got following... (more)

category: Data | clicked: 6 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL

6
Shouts

Shout it

Is ALTER TABLE ALTER COLUMN NOT NULL to NULL always expensive?

published 762 days, 5 hours, 40 minutes ago posted by

dhara 763 days, 10 hours, 58 minutes ago

Introduction In the past week this topic came up in 3 different occasions and it seems there is lot of confusion around this topic. In this post I will try to delve into some details and a demo to show that it’s NOT true. The confusion here is, the operation has to touch each and every row of the table... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL

6
Shouts

Shout it

Working with Ranking Functions - SQL Server 2005

published 762 days, 5 hours, 40 minutes ago posted by

dhara 763 days, 11 hours, 1 minute ago

I have learn so many times about ranking functions but never got chance to used with them. But during development some of the stored procedures, i have get the best chance to practically use. With ranking function , it really reduce the code complexity and also i enjoyed more while utilized them in stored... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL

6
Shouts

Shout it

Binding XML File to Data Grid in Silverlight

published 762 days, 5 hours, 40 minutes ago posted by

dhara 763 days, 11 hours, 2 minutes ago

It is a common scenario when we need to bind or display data from XML File to Silverlight Data Grid. In this article, I have tried to demonstrate this with simple steps. What all we are going to do is Download content of XML file as string using WebClient class. Parse XML file using LINQ to XML. Bind... (more)

category: Web Dev | clicked: 11 | comment | | source: beyondrelational.com

tags: .NET, Silverlight, data grid, XML, ASP.NET

5
Shouts

Shout it

T-SQL Worst Practices – a compilation from Jacob’s session at Tech-Ed 2011 – Part 01 – Practices that affect accuracy

published 763 days, 17 hours, 43 minutes ago posted by

dhara 764 days, 11 hours, 36 minutes ago

Last month, all the techies in India had a great time at the Tech-Ed 2011 (India). Out of the many sessions being conducted in parallel, one of the T-SQL programming sessions, there was one session from the renowned SQL Server MVP – Jacob Sebastian, which I found to be very interesting and different... (more)

category: Data | clicked: 1 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL

6
Shouts

Shout it

TSQL Challenge 53 - Finding empty and non-empty intervals among many start-end intervals

published 757 days, 20 hours, 47 minutes ago posted by

dhara 764 days, 11 hours, 38 minutes ago

A SQL Server instance is set up to log the session start time and end time into a table. Given this table, your job is to find all time intervals in which no one is logged in. For the intervals separated by these empty intervals show the maximum number of simultaneous users. Want to... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, tsql challenges, TSQL

6
Shouts

Shout it

Alias names - SQL Server Vs Oracle

published 763 days, 17 hours, 43 minutes ago posted by

dhara 764 days, 11 hours, 37 minutes ago

Alias name can be used in such cases like more than a table is used in the select statement, naming a derived column or table, etc. However the usage seems to be different among the RDBMSs. Consider the following examples which are valid in SQL Server select t.* from table1 as t select sum(t.amt) as... (more)

category: Data | clicked: 0 | comment | | source: beyondrelational.com

tags: SQL Server, TSQL

Welcome!

ashishgilhotra

View Call Hierarchy window in Visual Studio 2010

Pin features while debugging in Visual Studio 2010

Creating a simple Context Sensitive Help for ASP.NET Controls using jQuery

Adding labels to breakpoint in visual studio 2010

Ways to get top records from table using TOP clause in SQL Server

Historical Debugging (Intellitrace) on Visual Studio 2010 Ultimate Part-2

Windows Azure for Developers Task 6: Hosting ASP.Net Application in New Silverlight based Azure Portal

Track Changes and Advance Scroll Mode in Visual Studio 2010

T-SQL Worst Practices – a compilation from Jacob’s session at Tech-Ed 2011 – Part 03 – Practices that contribute to execution errors

SPARSE Column - New feature of SQL Server 2008

Historical Debugging (Intellitrace) on Visual Studio 2010 Ultimate Part-1

Checking whether page is secure or not in ASP.NET or JavaScript

T-SQL Worst Practices – a compilation from Jacob’s session at Tech-Ed 2011 – Part 02 – Practices that affect performance

SQL Server: High Logical Reads for Strange Worktable

Is ALTER TABLE ALTER COLUMN NOT NULL to NULL always expensive?

Working with Ranking Functions - SQL Server 2005

Binding XML File to Data Grid in Silverlight

T-SQL Worst Practices – a compilation from Jacob’s session at Tech-Ed 2011 – Part 01 – Practices that affect accuracy

TSQL Challenge 53 - Finding empty and non-empty intervals among many start-end intervals

Alias names - SQL Server Vs Oracle

Open ID Login

Standard Login

Forgot Password?

Sign up