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
Convert Month

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
escape quotes

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
sql puzzle

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
jupyter notebook

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
Overutilized

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
underutilized

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
Revoke Permissions

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
Previous 1 … 4 5 6 7 8 9 10 … 827 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version