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
A plain blank certificate folder beside a small toolbox and notebook on a warm wooden desk.

Is a Certification Worth It, and What to Study Instead

December 29, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Decide whether a SQL Server certification supports your next role, then build practical study projects around recovery, security, and tuning.

Read More
SQL SERVER - Fix : Msg 15151, Level 16, State 1, Line 3 Cannot drop the login 'test', because it does not exist or you do not have permission

SQL SERVER – Fix : Msg 15151, Level 16, State 1, Line 3 Cannot drop the login ‘test’, because it does not exist or you do not have permission

December 28, 2008
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server Security

Msg 15151 said it cannot drop the login ‘test’, even for a sysadmin. The message was misleading: an open SSMS session for that login was blocking it.

Read More
SQL SERVER - Add Any User to SysAdmin Role - Add Users to System Roles

SQL SERVER – Add Any User to SysAdmin Role – Add Users to System Roles

December 27, 2008
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security

How to add any user to the SysAdmin role in SQL Server, with a short T-SQL script using sp_addsrvrolemember, or the same steps in Management Studio.

Read More
SQL SERVER - Fix : Error : Msg 15151, Level 16, State 1, Line 2 Cannot alter the login 'sa', because it does not exist or you do not have permission

SQL SERVER – Fix : Error : Msg 15151, Level 16, State 1, Line 2 Cannot alter the login ‘sa’, because it does not exist or you do not have permission

December 26, 2008
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server Security

Msg 15151, cannot alter the login ‘sa’, comes from missing rights. Only a member of the sysadmin role can change SA, so add the user to that role first.

Read More
SQL SERVER - DISABLE and ENABLE user SA

SQL SERVER – DISABLE and ENABLE user SA

December 24, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Security

You cannot modify the permissions of the SA user, but you can disable and enable user SA with ALTER LOGIN. Log in with Windows authentication first.

Read More
A wrapped parcel waits at the first of several prepared dispatch bays.

SQL SERVER – Find Next Running Time of Scheduled Job Using T-SQL

December 22, 2008
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Agent

A scheduled job has recorded scheduling metadata as well as its actual execution history. I check both before promising a next run.

Read More
Database column collation.

SQL SERVER – Change Collation of Database Column – T-SQL Script

December 20, 2008
Pinal Dave
SQL Performance
SQL Collation, SQL Scripts, SQL Server Security, SQL Utility

How to change collation of database column with ALTER TABLE ALTER COLUMN and COLLATE, then check it in sys.columns. A short test script shows each step.

Read More
Previous 1 … 293 294 295 296 297 298 299 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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