May 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
login experience

SQL SERVER – Login Experience with DEFAULT_DATABASE and MUST_CHANGE

October 18, 2023
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Server Security

We will look at how these two options can streamline things for users when they connect and change passwords. Let us discuss the login experience.

Read More
errorfix

SQL SERVER – Fix Error – Cannot execute as the database principal because the principal “dbo” does not exist

October 21, 2021
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Scripts, SQL Server, SQL Server Security

One of my clients recently sent me an email with the following error. The error was visible in the error log and was about the database principal. 

Read More
change password

SQL SERVER – Change Password at the First Login

April 19, 2021
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Scripts, SQL Server, SQL Server Security

Just like many other databases and applications, SQL Server also supports the feature to change password at the first login.

Read More
empty password

SQL SERVER – Creating System Admin (SA) Login With Empty Password – Bad Practice

June 26, 2020
Pinal Dave
SQL Tips and Tricks
Bad Practice, SQL Login, SQL Scripts, SQL Server, SQL Server Security

I realized that their DBAs are logging into their server with a blank or empty password. This is an extremely Bad Practice. Let us discuss it today. 

Read More
jobs

SQL SERVER – Query to List All Jobs with Owners

January 30, 2020
Pinal Dave
SQL Tips and Tricks
SQL Jobs, SQL Login, SQL Scripts, SQL Server, SQL Server Agent, SQL Server Security

During the engagement suddenly a Jr. DBA asked me if I have a query that will list all the jobs in their system with the Job’s owner.

Read More
admin rename

Can Admin Rename SA Account in SQL Server? – Interview Question of the Week #256

December 22, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL Login, SQL Scripts, SQL Server, SQL Server Security

Question: Can Admin Rename SA Account in SQL Server?

Answer: Yes, of course. The syntax for to rename SA account is very simple:

Read More
public

SQL SERVER – Security Risk of Public Role – Very Little

August 28, 2019
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Scripts, SQL Server, SQL Server Security

During the Comprehensive Database Performance Health Check, I do receive questions about pretty much anything like Public Database Role. 

Read More
1 2 3 4 … 9 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version