Let us see a script that will help check if a Column Exists in a Table. One of the common tasks that developers deal with when working on database-related projects
Unit of Measure Conversions: One Table for Kilograms, Pounds and Boxes
Adding kilograms, pounds and boxes gives a number that means nothing. Convert each product to one base unit and find the rows that cannot convert.
SQL SERVER – Scripts to Retrieve Column Names
Understanding how to retrieve column names from a table is one of the fundamental operations you should be familiar with.
SQL SERVER – Transaction Logs: The Good, The Bad, and The Ugly
Providing a comprehensive understanding of their role and potential issues. Let us learn about Transaction Logs: The Good, The Bad, and The Ugly.
Webinar – Mastering SQL Query Performance: A Deep Dive into Index Tuning and Analysis
The webinar topic is Mastering SQL Query Performance: A Deep Dive into Index Tuning and Analysis. I will be hosting this webinar.
SQL SERVER – Unique Indexes on Nullable Columns
As the server allows only one null value in a column if a unique constraint is applied. Let us learn about Unique Indexes on Nullable Columns.
The Pigeonhole Principle: Bridging Mathematics and SQL
The other day I was reading Wikipedia, and I ended up on the Pigeonhole Principle. I find it very intriguing about this and I decide to blog