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

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