Browse by Tags
All Tags »
SQL Server (
RSS)
One of the classic problems with database applications is refreshing stale data. In a nutshell, Query Notification allows you to cache data and be notified when the data has been changed in SQL Server. Upon notification, you can then refresh your cache or take whatever action you need to. In the following screen cast I will examine the capabilities of the notification services using the SqlDependency class. You can download the sample code from here . You can download the screen cast from here .
What are Connection pools should be by now a common knowledge. If by any case you still need a definition, read the following lines, otherwise jump to the next paragraph. Opening a database connection is a resource intensive and time consuming operation. Connection pooling increases the performance of Web applications by reusing active database connections instead of creating a new connection with every request. Connection pool manager maintains a pool of open database connections. When a new connection...
On a project that I lead, I had to supply with an installation exe. The project is an ASP.NET with Win Services and SQL2005 as the back-end storage. So, part of the installation is the database. I had two options to create the database in the installation process: Use a *.bak file. Use SQL scripts. The good thing about scripts is the fact that you can automate it within SQL Server; however the automation does not include the data. In order to add data I must write a SQL script with insert statements...
