SQL, or Structured Query Language, is a cornerstone of data manipulation and analysis in the digital world. One of its less-discussed but incredibly potent features is the Self Join. This…
Mastering the SQL Self Join
Mastering the SQL Outer Join
In the vast and intricate world of database management, the concept of SQL (Structured Query Language) joins plays a pivotal role in effectively merging and manipulating data from different tables.…
SQL Performance Strategies
Efficient SQL performance is crucial for the smooth operation of any database-driven application. Slow queries can lead to longer load times, hampering user experience and reducing overall efficiency. This blog…
Mastering the SQL Left Join
SQL is a versatile language for managing and manipulating databases, and one of its most powerful features is the ability to join tables. The LEFT JOIN command in SQL is…
Mastering the SQL Inner Join
SQL, the language of databases, is a foundational tool in the arsenal of anyone working with data. Among its various commands, the INNER JOIN is critical in efficiently retrieving and…
SQL Execution Plan
What is one? An SQL Server execution plan helps investigate performance issues with queries. As Database professionals, we receive user complaints that systems run slowly. Query results that used to…
C# and handling SSL Certificate Problems
Image by Vectorportal.com, CC BY Background Throughout my career, virtually every project I have worked on has integrated with other systems. In the 'old days', the security of these systems…
Why is SQL slow?
Performance matters Ensuring your applications run quickly is vital in an age where users expect immediate results. Most modern computers are high-speed - smoking fast - even compared to machines…
Stop / Start a Site in IIS
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…
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…