Sept 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • 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
All Articles rounding-600x432

SQL SERVER – Banker’s Rounding

August 15, 2023
Pinal Dave
SQL Tips and Tricks
Mathematical Function, SQL Function

Also known as unbiased rounding or round half to even, banker’s rounding follows a set of rules that ensures numbers are rounded.

Read More
All Articles manager-600x433

SQL SERVER – Making Recursive Parent-Child Queries Efficient

August 14, 2023
Pinal Dave
SQL Performance
Challenge, Recursive, SQL Joins

One puzzle is finding out how many employees each manager is responsible for in a company. Let us Make Recursive Parent-Child Queries Efficient.

Read More
All Articles MySQLAdministration-600x399

MySQL Administration – Video Course

August 11, 2023
Pinal Dave
SQLAuthority News
MySQL, Pluralsight

I’m thrilled to announce the launch of my 52nd course on Pluralsight – “MySQL Administration.” We dive into optimizing MySQL performance.

Read More
All Articles ihvsbd-600x345

Maximizing SQL Server Security: Instance Hiding vs SQL Browser Disable

August 10, 2023
Pinal Dave
SQL Tips and Tricks
SQL Browser, SQL Instance, SQL Server Security

Let us learn more today in this blog about Maximizing SQL Server Security: Instance Hiding vs SQL Browser Disable.

Read More
All Articles sqldm-600x423

Making the Most of Historical Data: Preventing Future SQL Server Issues

August 9, 2023
Pinal Dave
SQL Tips and Tricks
Idera

The key to predicting future troubles often lies in the past – specifically, historical data. We’ll explore the importance of historical data.

Read More
All Articles instance-600x338

SQL SERVER – What is Instance Hiding? How to do it?

August 8, 2023
Pinal Dave
SQL Tips and Tricks
SQL Server Configuration, SQL Server Security

In this blog post, I’ll share a real-life success story of how instance hiding significantly strengthened SQL Server security for one of my clients.

Read More
All Articles csvimports-600x344

SQL SERVER – Troubleshooting Common CSV Import Issues

August 7, 2023
Pinal Dave
SQL Tips and Tricks
Bulk Insert, CSV

Let us explore Troubleshooting Common CSV Import Issues. Importing data from CSV files into SQL Server is a common task.

Read More
All Articles unusedindexes-600x596

MySQL – Identifying Unused Indexes in Databases

August 4, 2023
Pinal Dave
SQL Performance
Information Schema, MySQL, SQL Index

This article will focus on how you can identify unused indexes in your MySQL database, which could potentially slow performance.

Read More
All Articles pytha-600x418

SQL SERVER – Stored Procedures to Check for Pythagorean Triples

August 3, 2023
Pinal Dave
SQL Tips and Tricks
Mathematical Function, SQL Function

I wanted to share another useful programming technique for learning math – using stored procedures to check for Pythagorean triples.

Read More
All Articles dynamicdatamasking-600x435

SQL SERVER – Introduction to Dynamic Data Masking

August 2, 2023
Pinal Dave
SQL Tips and Tricks
Data Masking, SQL Server Security

In this blog post, we’ll explore the concept of dynamic data masking, a powerful feature available in Microsoft SQL Server 2016 and later.

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

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