Adhoc testing of .NET RIA Services
Server and Port: here ASP . NET Web Dev Server. ClientBin directory ... dataservice.axd – you can find the registration of the handler in web.config... Read More......(read more)...
Adhoc testing of .NET RIA Services
Suddenly my Silverlight 3 application breaks during development process. Cause I have installed Visual Studio 2010 a few hours before, I was sure: must be something with 2010. After uninstall and reinstall SP1 everything worked fine, except .NET RIA services :-( So back to structured trouble shoot......
Data Tutorial 2 - Building our Master Page and Site Navigation Structure: ASP Alliance
In this article, Scott examines how to build a master page and site navigation structure using ASP.NET 2.0 in a series of step-by-step demonstrations. Read More......(read more)...
SQL SERVER Difference Between Candidate Keys and Primary Key
IntroductionNot long ago, I had an interesting and extended debate with one of my friends regarding which column should be primary key in a table. The debate instigated an in-depth discussion about candidate keys and primary keys. My present article revolves around the two types of keys.Let us firs......
Data Enhancements in .NET 4 / Visual Studio 2010 Beta 2
On Wednesday we are releasing .NET 4 / Visual Studio 2010 Beta 2 to the public and it brings many cool enhancements to the ASP.NET data controls and Entity Framework. I’m going to drill into a few features of these data related features and you can read more about all the changes to ASP.NET 4......
How to use InsertQuery property ? in ASP.NET
I know how to use the AccessDataSource1.InsertCommand ="Insert into tbl_1(Thing, Color) VALUES (" &tbx1.text &"," &tbx2.text &");" Read More......(read more)...
SQL SERVER Introduction to Business Intelligence Important Terms & Definitions
What is Business IntelligenceBusiness intelligence (BI) is a broad category of application programs and technologies for gathering, storing, analyzing, and providing access to data from various data sources, thus providing enterprise users with reliable and timely information and analysis for impro......
The Microsoft Ajax Library and Visual Studio Beta 2
Visual Studio 2010 Beta 2 was released this week and one of the first things that I hope you notice is that it no longer contains the latest version of ASP.NET AJAX. What happened? Where did AJAX go? Just like Sting and The Police , just like Phil Collins and Genesis , just like Greg Page and the W......
The Minutes On 9 - Channel 9 Video Interviews with the ASP.NET 4 Team
Who loves you? Not only is Visual Studio 2010 Beta 2 now available for everyone to download (not just subscribers) but I've got 11 short video interviews with the ASP.NET 4 team up on Channel 9. I was up in Redmond just last week and made sure to stop by the offices of as many ASP.NET developer......
Using SqlBulkCopy To Perform Efficient Bulk SQL Operations
Over the years I've worked on a number of projects that have shared a common requirement - the ability for users to quickly import large amounts of data into a back end SQL
Server database. One such project was a web application used by teachers and other staff members. The software was initially......
Visual Studio 2010 Beta 2 - Web Tools Overview
Visual Studio 2010 Beta 2 has officially shipped! If you haven’t already, download a copy from here . What New with Visual Studio If you are new to Visual Studio 2010 please check out all our previous blogs to get a understanding of all the changes we made for Beta 1 including this intro blog on be......
VS10 Beta 2 From an ASP.NET MVC Perspective
You probably don’t need me to tell you that Visual Studio 2010 Beta 2 has been released as it’s been blogged to death all over the place. Definitely check out the many blog posts out there if you want more details on what’s included. This post will focus more on what Visual Studio 2010 means to ASP......
ASP.NET 4 Beta 2 - New Version, New Docs, New MSDN Site !
We’ve been BUSY ! ASP.NET 4.0 and Visual Studio 2010 Beta 2 was released to MSDN Subscribers earlier this week. General availability is scheduled for tomorrow ! Read the announcement [ HERE ] with an overview about the new SKUs and features or go straight to the download [ HERE ]. Check out the new......
Need Help Migrating to SQL Azure?
Migrating an existing SQL Server database to SQL Azure is a compelling story, but its not a trivial task unless you start with the SQL Azure migration wizard put together by my team mates George and Wade. They just updated the wizard to support SQL Azure CTP 2. Details at: http://blog.wadewegner.......
SQLAuthority News PASS 2009 Sessions on Query Optimization and Performance Tuning
PASS Summit 2009 is now only 10 days away and I am very excited for the same. I can not wait to attend the summit as this is the most awaited conference of SQL Server in world. Everybody will be there and there will be something for everybody. My core expertise is in Query Optimization [...]...Did ......
VS 2010 and .NET 4.0 Beta 2
I’m happy to announce that today we shipped the Beta 2 release of Visual Studio 2010 and .NET 4.0. MSDN subscribers can download Beta 2 immediately. We will be opening up Beta 2 for everyone to download starting this Wednesday. VS 2010 and .NET Improvements VS 2010 and .NET 4 bri......
.NET Hang Case study: The danger of locking on strings
I had an interesting case today where an asp.net app was stuck in a true deadlock. In other words two threads were both waiting for resources that the other thread owned. The scenario in these cases usually goes something like this: FunctionA (locks on ResourceA) and calls FunctionB where it ......
ASP.NET 4 and Visual Studio 2010 beta 2 are here!
The ASP.NET and Web tools for Visual Studio teams have been cranking away on this release all year long and we’re excited to launch Beta 2 today! MSDN subscribers can download it today …it will be available for everyone on Wednesday. There are a ton of new features in this release, this......
How to render the same template on the server and client with minimal redundancy
Last week, I wrote a post about how the new Microsoft Ajax Library Preview 6 made it a lot easier to write unobtrusive and imperative data-driven applications . Because for the previous preview, I had written a cool little class browser using a declarative style, I thought it would be nice to rewri......
SQL SERVER Change Collation of Database Column T-SQL Script Consolidating Collations Extention Script
This document is created by Brian Cidern, he has written this excellent extension to SQL Expert who SQL SERVER Change Collation of Database Column T-SQL Script. His scripts are not only extremely helpful to achieve the task of consolidating collations in quick script. His script not only works p......
SQLAuthority News Whitepaper Auditing in SQL Server 2008
With SQL Server Audit, SQL Server 2008 introduces an important new feature that provides a true auditing solution for enterprise customers. While SQL Trace can be used to satisfy many auditing needs, SQL Server Audit offers a number of attractive advantages that may help DBAs more easily achieve th......
Hanselminutes Podcast 184: Preview of ASP.NET 4 with Scott Hunter
My one-hundred-and-eighty-forth podcast is up . Scott's in Seattle this week and catches Microsoft Program Manager (and one of 1000 Scott's) Scott Hunter who shares insights in the history and future of ASP.NET 4. What's coming in VS2010? Subscribe: Download: MP3 Full Show Do also remem......
Announcing Microsoft Ajax Library (Preview 6) and the Microsoft Ajax Minifier
The ASP.NET team today released a significant new update of the Microsoft Ajax Library (Preview 6). This update includes a bunch of new capabilities and improvements to our client-side AJAX library, and can be used with any version of ASP.NET (including ASP.NET 2.0, 3.5 and 4.0), and can be u......
ASP.NET MVC 1.0 Scripts Available on Microsoft CDN
A little while ago, Scott Guthrie announced the launch of the Microsoft Ajax CDN . In his post he talked about how ASP.NET 4 will have support for the CDN as well as the list of scripts that are included. The good news today is due to the hard work of Stephen Walther and the ASP.NET Ajax team , the......
Microsoft Ajax Library Preview 6
The ASP.NET team has been cranking away on more AJAX goodness…this time with a significant update to the Microsoft Ajax Library – Preview 6. This update includes updates to our client-side AJAX library that can be used with any type of Web application as well as deep support within ASP.NET fo......
SQL SERVER Recently Executed T-SQL Query
About a year ago, I wrote blog post about SQL SERVER 2005 Last Ran Query Recently Ran Query. Since, then I have received many question regarding how this is better than fn_get_sql() or DBCC INPUTBUFFER.The Short Answer in is both of them will be deprecated. Please refer to following update query......
Using the New Microsoft Ajax Minifier
Last night, Scott Guthrie announced that the ASP.net team published a free tool that enables you to improve the performance of your Ajax applications by reducing the size of its JavaScript files. The new tool is named the Microsoft Ajax Minifier. You can read Scott Guthrie’s announcement here: http......
Entirely unobtrusive and imperative templates with Microsoft Ajax Library Preview 6
Today is the release of the sixth preview of Microsoft Ajax Library. Don’t get fooled by the somewhat silly and long name: this is a major release in many ways. The scripts have been majorly refactored since preview 5. Check out the other posts out there (links at the bottom of this post) to see j......
SQL SERVER Enable Automatic Statistic Update on Database
In one of the recent projects, I found out that despite putting good indexes and optimizing the query, I could not achieve an optimized performance and I still received an unoptimized response from the SQL Server. On examination, I figured out that the culprit was statistics. The database that I wa......
Creating a Filtering User Interface With jQuery In a Web Forms Application: Part 2
Creating a Filtering User Interface With jQuery In a Web Forms Application: Part 1 looked at
how to use jQuery in an ASP.NET Web Forms application to build a collapsible filtering user interface. When the page is loaded into the user's browser the filtering
interface is collapsed. Clicking the f......
SQLAuthority News First Editorial T-SQL Challenges Beginners
I would like to welcome all of you to very first editorial for T-SQL Challenges for Beginners. T-SQL Challenges began with the aim to help community to come out of regular mind set of just reading articles online. There is plenty of reading material available online, but there are very few that can......
Health Monitoring and ASP.NET MVC
Health monitoring has been available in ASP.NET since v 2.0, and the health monitoring features can give you information you cant find anywhere else. I was troubleshooting an MVC application recently and needed information about the application: When was the application starting? When was ......
SQL SERVER Comic Slow Query SQL Joke
Community TechDays at Ahmedabad was a great successful event. In fact, this can be considered the biggest event held in Ahmedabad thus far along with the community. I have posted a detail report of the same at SQLAuthority News Community TechDays in Ahmedabad A Successful Event. After the event, ......
URL Routing with ASP.NET 4 Web Forms (VS 2010 and .NET 4.0 Series)
[In addition to blogging, I have recently been using Twitter to-do quick posts and share links. You can follow me on Twitter at: www.twitter.com/scottgu (@scottgu is my twitter name)] This is the eighth in a series of blog posts I’m doing on the upcoming VS 2010 and .NET 4 release. Toda......
LINQ to SQL, Lazy Loading and Prefetching
LINQ to SQL by default loads related entities and entity sets by using Lazy Loading. Which means if you retrieve a list of entities in a query that references other entities these other entities are not actually loaded unless you physically access them. Lazy loading is quite useful in some scenario......
SQL SERVER Query Optimization Remove Bookmark Lookup Remove RID Lookup Remove Key Lookup Part 3
Earlier I have written two different articles on the subject Remove Bookmark Lookup. This article is as part 3 of original article. Please read first two articles here before continuing reading this article.SQL SERVER Query Optimization Remove Bookmark Lookup Remove RID Lookup Remove Key Lookup......
SQLAuthority News Accessing SQL Server Databases with PHP
The SQL Server 2005 Driver for PHP is a Microsoft-supported extension of PHP 5 that provides data access to SQL Server 2005 and SQL Server 2008. The extension provides a procedural interface for accessing data in all editions of SQL Server 2005 and SQL Server 2008. The SQL Server 2005 Driver for PH......
HTML now a data format
About a year ago, I asked the question on this blog whether HTML could and should be used as a data format: http://weblogs.asp.net/bleroy/archive/2008/11/26/should-html-be-considered-as-a-data-format.aspx After all, it actually already has semantic constructs appropriate for tabular data, for col......
SQL SERVER Download Logical Query Processing Poster
Earlier this year, I had written article on SQL SERVER Logical Query Processing Phases Order of Statement Execution and I had asked one question to readers. I got very good response for this question. Today, I am going to discuss about one of the errata I have made there. I had displayed the [.........
SQL SERVER Queries Waiting for Memory Allocation to Execute
In one of the recent projects, I was asked to create a report of queries that are waiting for memory allocation. The reason was that we were doubtful regarding whether the memory was sufficient for the application. The following query can be useful in similar case. Queries that do not have to wait ......
Creating a Filtering User Interface With jQuery In a Web Forms Application: Part 1
jQuery is a lightweight, cross-browser JavaScript library designed to ease JavaScript's most common tasks, including inspecting and manipulating the
Document Object Model (DOM) and making out of band HTTP requests to support AJAX functionality. In plain English, jQuery makes it easy to perform cli......
October's Toolbox Column Now Online
My Toolbox column in the October 2009 issue of MSDN Magazine is available online and includes the following reviews:
nukeationMachine - nukeationMachine is a Visual Studio Add In that streamlines implementing WPF, WinForms, and ASP.NET user interfaces. nukeationMachine includes 1,600 UI bits, wh......
SSIS Bulk Insert task that bit me in the butt...
I've been working on SSIS packages that extract data from production databases and put them into data warehouses, and recently I hit an issue using the Bulk Insert task that bit me real good.
When you create a Bulk Insert task in the control flow of your package, the properties you generally......
Ajax Control Toolkit: new controls, bug fixes
And we have a new release of Ajax Control Toolkit. I didn’t work on this one but there are some nice things in there nonetheless :) First, new controls! SeaDragon: I’ve blogged before about Seadragon, the JavaScript-only way to do Deep Zoom. It became a lot easier to use a few month ago when the......
Deleting All Records In a Table EXCEPT For the N Most Recently Added Records
I recently ran into a situation where I needed to delete all records from a table except for the 1,000 most recently added records. Specifically, I was working on a site that used Error Logging Modules And Handlers (ELMAH), a free, open source error logging library for ASP.NET applications. ELMAH d......
Passing Multiple Records to a Stored Procedure in SQL Server
There are so many different ways to work with data that it can make your head spin. Regardless of the technology, one thing I always try to do when working with databases is minimize the number of calls that are made. I use ORM frameworks a lot so I have to make sure that my code doesn’......
Using Microsoft's Chart Controls In An ASP.NET Application: Programmatically Generating Chart Images
The Microsoft Chart controls demos we have examined so far all use the Chart Web control to position the chart image on the web page and to configure a number of its stylistic
settings. For example, while the Plotting Chart Data article showed several demos illustrating the different
ways to sp......
PROBLEM: CSS Styles No Longer Apply For Anonymous Users
I teach two ASP.NET courses as the University of California - San Diego Extension. In the second course students use forms-based authentication and ASP.NET's membership framework to create a web application that supports user accounts. Invariably, at least one student bumps into the following scena......
Announcing the WebsiteSpark Program
I’m excited to announce a new program – WebsiteSpark – that Microsoft is launching today. WebsiteSpark is designed for independent web developers and web development companies that build web applications and web sites on behalf of others. It enables you to get software, support and busi......
Using Microsoft's Chart Controls In An ASP.NET Application: Sorting and Filtering Chart Data
The Microsoft Chart controls make it easy to take data - such as sales numbers, website traffic statistics, and so on - and turn it into a chart, which can be saved to
an image file or displayed from a web page. In Plotting Chart Data we examined a myriad of ways to turn
data into a chart, incl......