June 2022 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
  • Training
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
DBCC FLUSHAUTHCACHE

SQL SERVER – Getting Started with DBCC FLUSHAUTHCACHE on SQL Azure

June 25, 2019
Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Login, SQL Scripts, SQL Server, SQL Server Security

First thing first – the command DBCC FLUSHAUTHCACHE only is supported on SQL Azure. The behavior of change of password is a bit different on SQL Azure.

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

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

Go to mobile version