SQL Server 2005 gathers a lot of useful data that you can use to identify areas where database performance can be improved. Here's what you need to improve performance.
MSDN Magazine January 2008
View Complete Post
I dont know whether I am posting this question in the right forum, please move it if needed. I have a windows application that shows data from a SQL table. I cannot use DataGridView in the application, I have a custom form to display the data. I need
a datastructure to hold the table data and I display it using my custom windows form. Which data structure should I use to automatically sync data between windows application and SQL Server? I don't want to manually write Update queries. Any help would
I need some guidence, how can I achive this and what is the best and fast way to do so?
I want to create an application for users, where users can go and select any given Stored Proc (link), then Pass parameters accordingly and export result directly to Excel 2007. it will be simple data extraction web application to export big chuck of data from SQL server 2008. No gridview please since the result set will be around million rows.
did anyone has developed similar application or project? or guide me or provide any link will be helpful.
Thank you :)
I was rummaging the internet learning aspx and came across the concept of: Microsoft Application Block for Data Access in .NET
It seems great of course. The articles are all early 2003-5 such as
So the question is - is this tech still relevant and should I be using it?
Hi, I am using a IIS 7.5 on Windows 7. I have a simple application that uses System.Net.WebRequest to POST data to another URL (in fact, the server side URL is on my local computer and it is hosted in IIS 7.5).
1. The problem is the server does not save data from client although on the client side codes when I debug and I see the OK message return from the code line
response.StatusDescription; // this has value of "OK"
2. How can I debug the server code side where to receive the request from client side who posts the data ?
The following is the codes for client who posts data using System.Net.WebRequest, and codes for server side who received posted data to save to database.
Client side codes: // also run on my local computer
public string PostIntegrationXml(XmlDocument xmlSubmitDoc)
Learn how to use the AtomPub protocol to pump up your blogs. Chris Sells includes a practical demonstration of mapping so you can expose a standard AtomPub service from a Web site and use Windows Live Writer to provide a rich editing experience against the service.
MSDN Magazine August 2010
Building an NHibernate-based desktop application isn't any harder than building a web application, and in many cases NHibernate simplifies elements of session handling and concurrency.
MSDN Magazine December 2009