Part of my pattern during development is to: 1. Create a new table 2. Create the stored procs to get data and save data This second step is tedious and lends itself to automation. So I created the stored proc createSPFromTable that takes the name of a table and creates a simple save store proc. […]
Generate Save Stored Proc from Table Read More »
Part of my pattern during development is to: 1. Create a new table 2. Create the stored procs to get data and save data 3. Create the data access layer methods that call the stored procs. This is a little tedious, so I created a SQL stored proc called createDALFromSP to generate a data access
Generate Data Access Layer Methods From Stored Procs Read More »
In a previous post, I had a system to only log the start and end of an outage condition. To report on the outages, we need to first look at the table where the exceptions get logged: Copy Text Copied Use a different Browser CREATE TABLE [dbo].[Exceptions]( [ExTime] [datetime] NULL
Reporting when Logging only the start and end of an outage condition Read More »
We found an issue with some of the older scripts having SET ANSI_NULLS OFF and this causes problems. The ANSI_NULLS ON setting is a database option that determines how NULL comparisons are handled. Under ANSI_NULLS ON, two NULL values will never be equal to each other because the two separate values are unknown. With ANSI_NULLS
SET ANSI_NULLS OFF Read More »
We have anasp.net page that auto refreshes every 8 seconds using Copy Text Copied Use a different Browser <meta http-equiv="refresh" content="8"> This page would pull data from a linked server, and whenever that link or the target server were down, it would fill up our error log with an entry every 8 seconds until it
Log only the start and end of an outage condition Read More »
In one of our ASP.NET applications, we wanted to change where the AppSettings were stored from a config file to a database table. Since this is a very large application (over 670 .cs files), the first requirement was that the majority of the changes needed to be done with a search and replace. In the
Moving AppSettings to a Database Table. Read More »
Our experience with the Visual Source Safe to Subversion conversion. BACKGROUND Visual Source Safe In general Visual Source Safe is known to have problems when the database gets large, if there are a lot of users, or if it is used over a network. On Microsoft’s site they have the following warnings: (http://support.microsoft.com/kb/q133054/) Many factors
Visual Source Safe to Subversion Conversion Read More »
We had a problem where our users would timeout for apparently no reason. I monitored the SQL Server for a while and found that every once in a while there would be a lot of blocking going on. So I need to find the cause of this and fix it. If there was blocking going
Unexplained SQL Server Timeouts and Intermittent Blocking Read More »
In one of the systems I work on, we have the problem of needing to track the different time zones that our users are in. In doing this, we need to account for daylight saving time.I see code like this used in many places: Copy Text Copied Use a different Browser select … dbo.fn_convertFromUTC(@StartUTC, @timeZone)
Time Zones and Performance Read More »
Machine.config is used for machine-specific items – thus the name. It never gets moved from machine to machine. So that is where you put your connection strings. Doing this, you will never have the horror of realizing your QA team has been hammering against your production data because someone forgot to account for the web.config
Where to put the connection string Read More »
