Background For the last 20 years, my day job has been developing Web Applications on the Microsoft ASP.Net platform. These applications have always been run on IIS, and stopping and…
Stop / Start a Site in IIS
Regex for Passwords
Useful but awful Regex patterns, whether you love them or hate them, they are helpful. They enable the developer to define patterns for data validation, ease the extraction of sections…
Generate a C# class from a SQL Table
Background Most of the systems I have worked on are Database First applications. Either the team or SQL experts define the database first - or it has existed for years…
Used Identity Fields in SQL
What are identity fields? Like most database systems, SQL Server can define numeric fields as Identity fields. This means the database server automatically sets the numeric field value to the…
Who is using my database
Background Whenever users report that a system is slow, there can be many reasons. It can also be several different problems causing the system to be slow. However, more often…
Delete Obj/Bin folders in a Visual Studio solution
Background Most non-trivial applications have a lot of files of source code. Unless the application uses an interpreted language, those files are compiled into other types like executables and DLLs.…
Find duplicate records in a table and remove them
Why duplicates? It is surprisingly easy to inadvertently create duplicate records in a table. More often than not, it is because we either didn't check for an existing record or…
SQL Number of records per table
Do you know? There are lots of reasons why you might want to know how many records there are in your database tables. One of the most common is because…
List IIS AppPool processes
The problem How do you view the app pool processes running in IIS? The Answer Run the following command from an Admin Console Window: - c:\windows\System32\inetsrv\appcmd.exe list wp It will…
Check for SQL Index Fragmentation
Your database is like a machine. Much like your car, your database needs maintenance to ensure it runs smoothly. The indexes slowly become fragmented as you insert, delete, and update…