Fortune cookies contain uplifting messages that bring a smile after a good meal. Did you know they likely originated in America, not China?
SQL SERVER – Fibonacci Series with T-SQL
What’s fascinating about the Fibonacci series is its ubiquitous presence in nature, from the arrangement of leaves on a stem to the shape of a hurricane.
SQL SERVER – How to Convert Month Number to Month Name
Let us learn How to Convert Month Number to Month Name. WE will see three methods in this blog post.
SQL SERVER – Escape Single Quotes
In this post, I’ll cover a few methods you can use to escape single quotes properly in SQL Server. The most popular is double single quotes.
SQL Puzzle – Retrieve the Unique Evens Under 10
In that spirit, let me walk through a bite-sized SQL puzzle that helps reinforce some key concepts. Let us see Retrieve the Unique Evens Under 10 puzzle.
Python – Why I Prefer Jupyter Notebook
As a developer who frequently works on Python projects, I’ve come to prefer Jupyter Notebook for various reasons.
SQL SERVER – Exploring 3 Overutilized Features
Potentially leading to less efficient implementations or missed opportunities for optimization. In this blog post, we’ll explore three such Overutilized features.
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.