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
Dedicated Administrator Connection

SQL SERVER – Adjust Memory with Dedicated Administrator Connection (DAC)

October 15, 2021
Pinal Dave
SQL Tips and Tricks
SQL Connection, SQL Server Security

the services did not start at all. Let us learn today how to Adjust Memory with a Dedicated Administrator Connection (DAC).

Read More
Renaming distributor_admin

SQL SERVER – Renaming distributor_admin Bad Idea

October 14, 2021
Pinal Dave
SQL Tips and Tricks
SQL Replication, SQL Server, SQL Server Security

A client of Health Check, recently send me an email after reading best practices. Why Renaming distributor_admin Bad Idea.

Read More
An old cast iron mincer clamped to a farmhouse kitchen table, a bowl waiting beneath it.

CLR Integration in SQL Server: When It Still Makes Sense

October 6, 2021
Pinal Dave
SQL Tips and Tricks
CLR, SQL Server, SQL Server Configuration, SQL Server Security

Review CLR integration uses, inventory existing assemblies, preserve strict security, and compare SQL Server 2025 built-in alternatives.

Read More
Drop Permission

SQL SERVER – Deny Drop Permission for a Table

September 6, 2021
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Security, SQL Trigger

Lots of people asked me to write a follow-up blog post where we can deny drop permission for a table from the SQL Server Security Standpoint.

Read More
Changing Password

SQL SERVER – Unlocking User Without Changing Password

June 9, 2021
Pinal Dave
SQL Tips and Tricks
SQL Password, SQL Scripts, SQL Server, SQL Server Security

If know the answer, I like to answer them. Today we are going to discuss Unlocking User Without Changing Password. Let us learn.

Read More
Slowloris

Slowloris DDoS Attack Mitigation

May 24, 2021
Pinal Dave
SQL Tips and Tricks
Pluralsight, SQL Server Security

Slowloris is one of the very popular tools for DDoS attacks and today we will be talking about Slowloris DDoS Attack Mitigation at Pluralsight.

Read More
A crowd of seagulls mobbing the hatch of a small beach kiosk while a hand pulls the shutter halfway down.

Logon Storms: Protecting SQL Server From Connection Floods

April 28, 2021
Pinal Dave
SQL Tips and Tricks
DBA, SQL Connection, SQL Login, SQL Server Security, SQL Trigger

Diagnose SQL Server logon storms, control connection growth, test a limited logon trigger, and preserve administrator recovery access.

Read More
Previous 1 2 3 4 5 6 7 … 55 Next
  • Books
  • Testimonials
  • Privacy Policy

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