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 - 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
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
A wall of identical lockers, each with its own padlock

Designing a Database for Multiple Customers

December 10, 2008
Pinal Dave
SQL Tips and Tricks
Database, Schema, SQL Server, SQL Server Security

A database for multiple customers can share tables, split schemas, or split databases; the choice balances isolation and operating cost.

Read More
Hands applying frosted film to a window so the room behind becomes unreadable

Keeping Personal Data Out of Test Databases

November 21, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, DBA, SQL Backup and Restore, SQL Server Security, Testing

Keeping personal data out of test databases requires synthetic records or masking during refresh, plus verification before access.

Read More
A covered serving dish passes through a small kitchen hatch toward a hand reaching from a dark room.

Encrypting Connections to SQL Server

November 3, 2008
Pinal Dave
SQL Tips and Tricks
SQL Connection, SQL Server, SQL Server Configuration, SQL Server Encryption, SQL Server Security

Encrypting connections to SQL Server requires a trusted certificate, careful Force Encryption rollout, and tests with real drivers.

Read More
Previous 1 … 42 43 44 45 46 47 48 … 57 Next
  • Books
  • Testimonials
  • Privacy Policy

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