Microsoft Virtual PC 2007 - Performance(syedarizvi.blogspot.com)

submitted by ahmer75(120) 2 years, 4 months ago

Microsoft provides free download for Virtual PC which is a helpful asset when developing applications in team environment as it provides an exclusive environment to develop/debug code without interfering other developers. read more...

add a comment |category: Tips & Tricks |Views: 3

tags: Tips another

Dynamics - Virtual Machine Num Lock (syedarizvi.blogspot.com)

submitted by ahmer75(120) 2 years, 11 months ago

Microsoft provides free download for Dynamics CRM 4.0 virtual demo machine. Microsoft Dynamics is a business management offering for financial, customer relationship management and supply chain. read more...

add a comment |category: Tips & Tricks |Views: 9

tags: Dynamics CRM Tips another

Free SharePoint Designer 2007 Training(syedarizvi.blogspot.com)

submitted by ahmer75(120) 3 years ago

Microsoft made SharePoint Designer 2007 a free download as of April 1, 2009. SharePoint Designer 2007 is based on Miscrosoft FrontPage 2003 with more emphasis towards SharePoint enabled web-sites. read more...

add a comment |category: ASP.NET |Views: 31

tags: MOSS2007 ASP.NET another

Silverlight 2.0 - Using Silverlight DataGrid to consume ASMX Web Servi(syedarizvi.blogspot.com)

submitted by ahmer75(120) 3 years, 6 months ago

Microsoft released Silverlight 2.0 on October 13, 2008. Silverlight 2 provides cross-browser rich UI experience which developers can use to author media rich applications using .NET language (C#, Visual Basic etc) of their choice. The article will demonstrate working of Silverlight 2.0 enabled UI by creating an ASP.NET web-form with Silverlight DataGrid control consuming ASMX Web Service. read more...

add a comment |category: Silverlight |Views: 224

tags: LINQToXML LinqToSql Silverlight2 ASMX SQL another

ASP.NET/LINQ to SQL - Building UI Layer(syedarizvi.blogspot.com)

submitted by ahmer75(120) 3 years, 6 months ago

LINQ stands for Language Integrated Query which was introduced with .NET 3.5. LINQ provides the ability to write query as a first-class language construct using modern programming languages like C# and Visual Basic. This article will demonstrate working of LINQ to SQL enabled UI by creating an ASP.NET web-form with GridView control bound to the newly introduced LinqDataSource control. read more...

add a comment |category: Linq |Views: 64

tags: LINQ LinqToSql SQL Database ASP.NET another

.NET/SQL Server 2008 - Using Table-Valued Parameters with .NET(syedarizvi.blogspot.com)

submitted by ahmer75(120) 3 years, 7 months ago

With the release of SQL Server 2008, Microsoft introduced a new parameter type called 'Table-Valued Parameters', which provided the flexibility for the SQL developers to send multiple rows of data to a stored procedure/function or inline T-SQL code. Table-Valued parameters can be used to transfer multiple rows of data without requiring the developer to construct custom string parsing routines, temporary table or multiple parameters which for a complex stored procedure can become difficult to maintain. read more...

add a comment |category: ASP.NET |Views: 76

tags: ASP.NET SQL Database ADO.NET another

ASP.NET - Efficiently Importing DataTable(syedarizvi.blogspot.com)

submitted by ahmer75(120) 3 years, 7 months ago

ASP.NET developers often use DataTable to store data received from SQL stored procedure, web-service, data access layer (DAL) etc. read more...

add a comment |category: ASP.NET |Views: 54

tags: ASP.NET ADO.NET another

SQL Server - Get Nth Highest using ROW_NUMBER() Function(syedarizvi.blogspot.com)

submitted by ahmer75(120) 3 years, 8 months ago

ROW_NUMBER function was introduced in SQL Server 2005. ROW_NUMBER as the name suggests is used to calculate row numbers in the query result set. Prior to ROW_NUMBER developers relied on temporary tables and co-related sub-queries to accomplish the same, which often resulted in spaghetti code and overall bad query performance. read more...

add a comment |category: Database |Views: 88

tags: SQLServer SQL Database another

Only In A Database Can You Get 1000% + Improvement By Changing A Few L(blogs.lessthandot.com)

submitted by dnk2007(765) 3 years, 9 months ago

Only In A Database Can You Get 1000% + Improvement By Changing A Few Lines Of Code read more...

add a comment |category: Database |Views: 624

tags: Database another

MOSS 2007 - Data Caching Vs List Iteration(syedarizvi.blogspot.com)

submitted by ahmer75(120) 3 years, 9 months ago

MOSS developers most of the time need to retrieve data from SharePoint Lists. In one of the MOSS project I worked there were several provisioned .ASPX Pages which lacked in performance. The pages took more than usual time to render, on average a page displaying 1000+ List records (we are not discussing Pagination here) was taking approximately 2 minutes! Coming from ASP.NET/SQL background this was just unacceptable. read more...

add a comment |category: ASP.NET |Views: 48

tags: MOSS2007 ASP.NET MOSS another

SQL Server - Using EXCEPT Operator(syedarizvi.blogspot.com)

submitted by ahmer75(120) 3 years, 9 months ago

EXCEPT operator was introduced in SQL Server 2005. EXCEPT can be used to return distinct records from the left side of a query and which are not located on the right side. read more...

add a comment |category: Database |Views: 15

tags: SQLServer SQL Database another

SQL Server – Using INTERSECT Operator (syedarizvi.blogspot.com)

submitted by ahmer75(120) 3 years, 9 months ago

INTERSECT operator was introduced in SQL Server 2005. INTERSECT can be used to return distinct records from the left and right side of a query. <a href="http://syedarizvi.blogspot.com/2008/08/sql-server-using-intersect_07.html">Full story</a> read more...

add a comment |category: Database |Views: 21

tags: SQLServer SQL Database another

SQL Server – Power of CASE function (syedarizvi.blogspot.com)

submitted by ahmer75(120) 3 years, 9 months ago

Case statement can be used to introduce conditional logic. Case statement can be used to evaluate multiple statements and return one possible output. Case can be compared to Switch statement in modern programming languages like C#. read more...

add a comment |category: Database |Views: 21

tags: SQLServer SQL Database another

SQL Server - Common Table Expressions (CTE) (syedarizvi.blogspot.com)

submitted by ahmer75(120) 3 years, 9 months ago

Common Table Expressions (CTE) construct was introduced with Microsoft SQL Server 2005. CTE behaves like a derived table but unlike derived table which has statement level scope CTE offers a procedure level. read more...

add a comment |category: Database |Views: 19

tags: SQLServer SQL Database another