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.
2019-03-14
2,987 reads
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.
2019-01-28
2,859 reads
The problem of ransomware seems to be increasing. Major organizations are being hit and their servers are being affected. K. Brian Kelley explains some of the basic things you can do to reduce your expose to ransomeware.
2017-09-13
4,202 reads
2017-09-06
218 reads
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.
2017-01-05
7,712 reads
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.
2015-04-15
6,516 reads
I'm bad about remembering error coding when I try and answer a question quickly. Glad it helped.
2005-05-24
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 […]
2005-05-16
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 […]
2005-02-14
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 […]
2005-02-11
1 reads
By kleegeek
We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...
By Steve Jones
Today’s coping tip is to connect with someone from a different generation. This tip...
By Arun Sirpal
This blog post is not about which User Interface is better, Classic or Snowsight...
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...
I'm using this query to check if I have any unused indexes.. One of...
Hi, I am new to Powershell script and i have to create a power...
Ask SSC