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.
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.