Sometimes, when working with SQL, you might need to do something special with odd and even rows in your table. This can be a bit tricky.
The Locks, Blocks, and Deadlocks of SQL Server: Unraveling the Knots
SQL Server is no exception. However, it often leads to three common phenomena – locks, blocks, and deadlocks. SQL Diagnostic Manager SQL Server
SQL SERVER – A Comparison of CHARINDEX vs LIKE
In this post, we’ll explore a comparison between the use of CHARINDEX and LIKE in the WHERE clause, supported by real-world statistics.
Mastering PostgreSQL: An Essential Learning Pathway
Mastering PostgreSQL: An Essential Learning Pathway. PostgreSQL, is widely acclaimed as the world’s most advanced open-source database.
SQL SERVER – Modern Explicit JOIN Syntax – A Brief Note
Over time, SQL has evolved and offers two distinct styles for performing JOIN operations: the old-style comma-separated join and the more modern explicit JOIN syntax.
SQL SERVER – Stripping HTML Tags from Text
In this blog post, we’ll explore a method for stripping these HTML tags from your text data using SQL Server. Let us explore the post.
Gherkin Scenarios: 3 Examples to Follow and 6 to Avoid
The quality of your Gherkin scenarios can make or break your BDD efforts. I’d like to share some insights many software developers overlook.