This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Accelerated Database Recovery

The Evolution of Accelerated Database Recovery in SQL Server 2022

November 14, 2023
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, Starting SQL

A look at the evolution of Accelerated Database Recovery in SQL Server 2022, with better version store cleanup and scalability for long transactions.

Read More
Artificial Intelligence in Data Pipelines.

TensorFlow – An Introduction

November 10, 2023
Pinal Dave
SQL Tips and Tricks
AI

TensorFlow is a powerful open-source machine learning library developed by the Google Brain team. Let us explore that in simple words.

Read More
langchain

LangChain – Harnessing the Power of Language Models

November 9, 2023
Pinal Dave
SQL Tips and Tricks
AI

At the heart of this transformative wave is LangChain, a dynamic framework designed to supercharge applications with the power of language models.

Read More
Gouache painting of a table with wooden pegs joined by thin threads and one vermilion peg at the centre

MATCH Clause in SQL Server Graph Tables: Query Relationships

October 25, 2023
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server 2017, SQL Server 2019

The MATCH clause finds rows in SQL Server graph tables by describing the path between them. The small graph runs one hop, two hops, a shared skill and a SHORTEST_PATH query, compares the plain join, and shows what the MATCH clause does not allow.

Read More
pivotunpivot

SQL SERVER – Exploring PIVOT and UNPIVOT

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

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

Read More
Securely storing passwords.

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
Previous 1 … 6 7 8 9 10 11 12 … 571 Next
  • Books
  • Testimonials
  • Privacy Policy

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