Problem: You are building a web application, and are trying to figure out how to best model the particular database schema you need for the application. Solution: One great resource I found recently on the web that I recommend checking out is a really nice library of free database models . You can browse...

Problem: You are building a web application, and are trying to figure out how to best model the particular database schema you need for the application. Solution: One great resource I found recently on the web that I recommend checking out is a really nice library of free database models . You can browse...

Problem: You are building a web application, and are trying to figure out how to best model the particular database schema you need for the application. Solution: One great resource I found recently on the web that I recommend checking out is a really nice library of free database models . You can browse...

Shared servers usually have many databases belonging to different customers, and MS SQL Server Management Studio (SSMS) will display all those databases when used by a valid login to connect to SQL Server 2005. If you seek to change that default behavior, you can do so with a SQL Server 2005 configuration...

Scenario: You finish building a great ASP.NET application, have everything testing and working right on your local system, are taking full advantage of the new ASP.NET 2.0 Membership, Role and Profile features, and are ready to publish it to a remote hosting environment and share it with the world. Copying...

These days I was working on a web app dealing with large amount of data . When it comes to display these data we use GridView and enable pagination in one click. First thing to know is by default ASP.NET 2.0 GridView default paging is very poor in terms of performance because it first gets all data from...

Last month I posted about the new (free) Database Publishing Wizard that is designed to make it much, much easier to upload and deploy SQL Express and SQL Server databases in a web hoster environment. In my first Database Publishing post , I walked through how you can use the Database Publishing Wizard...

Last month I posted about the new (free) Database Publishing Wizard that is designed to make it much, much easier to upload and deploy SQL Express and SQL Server databases in a web hoster environment. In my first Database Publishing post , I walked through how you can use the Database Publishing Wizard...

These days I was working on a web app dealing with large amount of data . When it comes to display these data we use GridView and enable pagination in one click. First thing to know is by default ASP.NET 2.0 GridView default paging is very poor in terms of performance because it first gets all data from...

Scenario: You finish building a great ASP.NET application, have everything tested and working right on your local system, are taking full advantage of the new ASP.NET 2.0 Membership, Role and Profile features, and are ready to publish it to a remote hosting environment and share it with the world. Copying...