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
SQL SERVER - Huge Transaction Log in Snapshot Replication!

SQL SERVER – Huge Transaction Log in Snapshot Replication!

April 7, 2016
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, Transaction Log

The log kept growing and sys.databases showed REPLICATION as the reuse wait. Here is how I found why the transaction log in snapshot replication was not reused.

Read More
MySQL - Different Methods to Know Current User

MySQL – Different Methods to Know Current User

April 4, 2016
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Scripts

Why check the current user in MySQL? For audits, permissions and custom logic. Here are the methods, from user() and current_user() to mysql.user.

Read More
A sealed envelope, brass lock and two different key impressions suggest preserved evidence of a change

SQL SERVER – Who Changed the Password of SQL Login? – Interview Question of the Week #065

April 3, 2016
Pinal Dave
SQL Interview Questions and Answers
SQL Login, SQL Password, SQL Scripts, SQL Server, SQL Server Security

Who changed the password of your SQL Login? It is a real world question every DBA faces one day. Bookmark this post, here is how to find the answer.

Read More
SQL SERVER - FIX: Could not connect because the maximum number of 1 user connections has already been reached

SQL SERVER – FIX: Could not connect because the maximum number of 1 user connections has already been reached

April 2, 2016
Pinal Dave
SQL Tips and Tricks
SQL Connection, SQL Error Messages, SQL Scripts, SQL Server

A client changed one setting, restarted and nobody could connect: the maximum number of 1 user connections has already been reached. Here is how we got in.

Read More
SQL SERVER - Finding If Status of Bulk Logging Enabled or Not From Logs

SQL SERVER – Finding If Status of Bulk Logging Enabled or Not From Logs

March 31, 2016
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Log, SQL Scripts, SQL Server

A friend’s SSIS jobs switch a database to Bulk-Logged and back again. Here is how to find which of his log backups ran with Bulk Logging Enabled.

Read More
SQL SERVER - How to Query Active Directory Data Using ADSI / LDAP Linked Server

SQL SERVER – How to Query Active Directory Data Using ADSI / LDAP Linked Server

March 30, 2016
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server

A client wanted the email address and phone number of every user from Active Directory. Here is how to query Active Directory data with an ADSI linked server.

Read More
SQL SERVER - How to Add Multiple New Columns to Table with Default Values?

SQL SERVER – How to Add Multiple New Columns to Table with Default Values?

March 29, 2016
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Table Operation

A reader asked how to add several columns with default values to an existing table. Here is a simple example to add multiple new columns with defaults.

Read More
Previous 1 … 151 152 153 154 155 156 157 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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