June 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

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
Maximizing SQL Server Security

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
sqldm

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
Instance Hiding

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
csv import

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
Pythagorean Triples

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
dynamic data masking

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

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

Go to mobile version