May 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
match

SQL SERVER – Exploring SQL Graph Pattern Matching with MATCH

October 25, 2023
Pinal Dave
SQL Tips and Tricks
Geography Data Type

One of the powerful features of SQL Graph is the ability to search and traverse these graph pattern relationships easily using the MATCH clause.

Read More
pivotunpivot

SQL SERVER – Exploring PIVOT and UNPIVOT

October 24, 2023
Pinal Dave
SQL Tips and Tricks
PIVOT, Query Rewrite, UNPIVOT

The SQL Server PIVOT and UNPIVOT operators are powerful tools that provide an easy way to transform your data in SQL.

Read More

Function in the WHERE Clause – SQL in Sixty Seconds 201

October 23, 2023
Pinal Dave
SQL Video
SQL Function, SQL in Sixty Seconds, SQL Index

Few even asked me to build a video on this topic. Hence, I decided to make a Function in the WHERE Clause – SQL in Sixty Seconds 201.

Read More

SQL SERVER – Best Practices for Securely Storing Passwords

October 20, 2023
Pinal Dave
SQL Tips and Tricks
SQL Password, SQL Server Security

This post will explore industry-standard techniques to securely store passwords. Let us learn about Best Practices for Securely Storing Passwords.

Read More
secure passwords

SQL SERVER – Generating Secure Passwords

October 19, 2023
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Password, SQL Server Security

We’ll explore industry guidelines for complex passwords and implement them in an SQL Server stored procedure to generate secure passwords.

Read More
login experience

SQL SERVER – Login Experience with DEFAULT_DATABASE and MUST_CHANGE

October 18, 2023
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Server Security

We will look at how these two options can streamline things for users when they connect and change passwords. Let us discuss the login experience.

Read More
Index Operations

SQL SERVER – Ins and Outs of Online Index Operations

October 17, 2023
Pinal Dave
SQL Tips and Tricks
Clustered Index, SQL Index

I recently talked about Ins and Outs of Online Index Operations with my clients during the Comprehensive Database Performance Health Check.

Read More
Previous 1 … 7 8 9 10 11 12 13 … 827 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version