Apr 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

SQL SERVER – T-SQL Fortune Cookies

November 27, 2023
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL View

Fortune cookies contain uplifting messages that bring a smile after a good meal. Did you know they likely originated in America, not China?

Read More
All Articles FibonacciSeries-600x722

SQL SERVER – Fibonacci Series with T-SQL

November 24, 2023
Pinal Dave
SQL Tips and Tricks
CTE, Mathematical Function, SQL Function

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.

Read More
All Articles datecals-600x600

SQL SERVER – How to Convert Month Number to Month Name

November 23, 2023
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function

Let us learn How to Convert Month Number to Month Name. WE will see three methods in this blog post.

Read More
All Articles escapequotes-600x600

SQL SERVER – Escape Single Quotes

November 22, 2023
Pinal Dave
SQL Tips and Tricks
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.

Read More
All Articles sqlpuzzle-600x600

SQL Puzzle – Retrieve the Unique Evens Under 10

November 21, 2023
Pinal Dave
SQL Puzzle
SQL Distinct

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.

Read More
All Articles jupyternotebook-600x728

Python – Why I Prefer Jupyter Notebook

November 20, 2023
Pinal Dave
SQL Tips and Tricks
Jupyter Notebook, Python

As a developer who frequently works on Python projects, I’ve come to prefer Jupyter Notebook for various reasons.

Read More
All Articles Overutilized-600x600

SQL SERVER – Exploring 3 Overutilized Features

November 17, 2023
Pinal Dave
SQL Tips and Tricks
Query Hint, SQL Cursor

Potentially leading to less efficient implementations or missed opportunities for optimization. In this blog post, we’ll explore three such Overutilized features.

Read More
All Articles underutilized-600x600

SQL SERVER – Exploring 3 Underutilized Features

November 16, 2023
Pinal Dave
SQL Tips and Tricks
Compression, Policy Management, SQL Audit

This blog post will explore three underused features that can significantly enhance your SQL Server experience. Let us discuss 3 Underutilized Features.

Read More
All Articles RevokePermissions-600x694

SQL SERVER – Understanding Grant, Deny, and Revoke Permissions

November 15, 2023
Pinal Dave
SQL Tips and Tricks
SQL Server Security

These aspects are the fundamental building blocks of SQL Server security management. Let us understand Grant, Deny, and Revoke Permissions.

Read More
All Articles Accelerated_Database_Recovery-600x463

The Evolution of Accelerated Database Recovery in SQL Server 2022

November 14, 2023
Pinal Dave
SQL Tips and Tricks
Accelerated Database Recovery, SQL Backup, Starting SQL

At its core, Accelerated Database Recovery is a revolutionary SQL Server feature that dramatically boosts database availability.

Read More
Previous 1 2 3 4 5 6 7 8 … 579 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com