Content with Tag: SQL Server
Clinical Data Registry Data Entry System
The client provides a service to help its hospital clients collect data to be sent to national health care registries covering heart catheterization lab procedu ...
Damage Claim Processing System
The client is a national provider of utility location services. In some locations, damage still occurs to utility lines even after they have been located, in wh ...
Index defragmentation query
I'm not sure where I got this, but I've had several cases in which I had to defragment the indexes in a database. This script goes through the indexes in the da ...
New Blazor/.NET 6 powered website
One of the best ways to learn new technologies is to come up with an idea and just build something. In my case, I wanted to learn the new Blazor technology from ...
Reconnecting orphaned users
If you are restoring a SQL Server database that has user IDs in it between machines, the user IDs from the source machine won't match the destination machine. A ...