SQL Server security

External Article

Introduction to SQL Server Security — Part 3

  • Article

SQL Server supports partially contained databases. This gives you the option of adding database users with a password inside the database. This makes the database easier to move to another instance or participate in an Always On Availability Group. In this article, Robert Sheldon explains how to work with users in contained databases.


2,987 reads

External Article

Introduction to SQL Server Security — Part 1

  • Article

Security is often considered the most important of a database administrator's responsibilities. SQL Server has many powerful features for security and protecting data, but planning and effort are required to properly implement them. In this article, the first of a series, Robert Sheldon reviews the many components available to secure and protect SQL Server databases.


2,859 reads

External Article

Questions About SQL Server Security and Access Control You Were Too Shy to Ask

  • Article

For many developers, database security and Access control is just something that gets in the way of development work. However, several recent security breaches have had devastating consequences and have caused a change in attitude about the value to any organisation of having database applications that meet industry standards for access control and security. The problem, however is in admitting that you have a problem and finding answers to those problems you are just too shy to ask in public.


7,712 reads

Stairway to SQL Server Security

Stairway to SQL Server Security Level 8: Data Encryption

  • Stairway Step

This stairway level will explore data protection through encryption, both when the data is in motion across the network or in memory and at rest in a table. You’ll learn about the encryption key hierarchy and the various kinds of keys you can use to encrypt data, as well as how you can manage the keys or let SQL Server do it for you.

5 (1)


6,516 reads

Technical Article

Installing SQL on a Remote Server

  • Topic

I need to install SQL on a machine to which I do not have physical access.  The machine is housed in a colocation facility some 2 hours away.  It's running 2003 Server Web edition and I'm trying to install SQL 2000 Enterprise.  When I connect via Remote Desktop and try to launch the setup, Installshield […]


Technical Article

RE: Recommendations for a Query Analyzer replacement

  • Reply

I have been using ApexSQL Edit for several months. It has some very handy additions that make writing sql easier (such as intellisense). There are still times that I use QA, but they are usually when I must generate standard INSERT/DELETE or UPDATE sql for a table, procedure or function and then I copy/paste that […]


Technical Article

Auditing logins

  • Topic

We have a system which uses a common sql server authenticated login for access by everyone (may the vendor be eaten by small sharp-toothed animals).  I'd like to be able to track the host and the application of every login from sysprocesses.  I can probably run profiler to save the information I need, but is […]


1 reads


Hyperconverged storage tuning tip for SQL Server


We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...

Daily Coping 25 Nov 2022


Today’s coping tip is to connect with someone from a different generation. This tip...

Snowflake Classic UI vs Snowsight


This blog post is not about which User Interface is better, Classic or Snowsight...

Read the latest Blogs


Can someone explain where non - clustered index is stored?

By yourjobismine

I am learning non-clustered and clustered indexing. When reading this article https://www.sqlshack.com/what-is-the-difference-between-clustered-and-non-clustered-indexes-in-sql-server/#:~:text=Clustered%20indexes%20only%20sort%20tables,involve%20any%20extra%20lookup%20step. came across this...

Null value when checking unused indexes

By Bruin

I'm using this query to check if I have any unused indexes.. One of...

Retrieve Password from CyberArk using powershell

By Alone

Hi, I am new to Powershell script and i have to create a power...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers