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…
Generate a C# class from a SQL Table
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…
SQL Disk Space Usage
How big? It isn't very often that you need to understand which tables take up most space within your database. Normally, knowing how much space the entire database consumes is…
Test SQL Connection without SSMS
Background You'll find yourself logged into a web or application server and need to test that you can access the SQL server at which you've unsuccessfully tried to point your…