What are Web Forms Web Forms was the first Dot Net ASP.Net Web Framework. The technology was the easiest way for existing Microsoft Platform developers to move to the web.…
Web Forms Page / Control Events and Sequence
SQL Joins
Background There are many ways to join tables and views in an SQL server. This diagram is a great quick reference.
SQL Suggested Indexes
How SQL access data Whenever SQL Server executes a query, it builds an execution plan to find the data and return it to the requesting process. I have another post…
Determine where SQL files are
SQL Files A typical SQL Server Database comprises two physical files on the disks: an 'mdf' file and a 'ldf' file. The 'mdf' file contains the database scheme, tables, stored…
Shrink an SQL database
Size does matter As you use a database, the log files increase in size. When you back up your database, SQL frees the space in the log file - it…
Fix a SQL Database
A true story Several years ago, before we moved our Production and Development systems over to Kubernetes running on Azure, we used a well-known hosting provider in the UK. Initially,…
Enable SQL Database Diagrams
The Code SQL Database Diagrams are invaluable in understanding the schema. I use them all of the time. Occasionally, I create the database tables and relationships from the diagram designer…
Update SQL Statistics on things
Background As our customer base has grown, so has the size of those customers and, with them, the amount of data we hold within our databases. We have a solution…
Another way in SQL to Delete Duplicate Records
Using a CTE to delete duplicates Some of my other posts show how to find and delete duplicate records from SQL Server. This is another way to delete duplicate records…
SQL Records Per Table
Why you need to know There are lots of reasons why you might want to know the number of records in your tables. Database maintenance is one; user and business…