SQL Server security

Technical Article

Introduction to SQL Server Security — Part 4

  • DatabaseWeekly

The sa account is the most powerful account in a SQL Server instance, and most DBAs disable it. There are several other built-in accounts that you may not think about that often. Robert Sheldon continues his SQL Server security series with an article about built-in accounts.

You rated this post out of 5. Change rating

2019-05-08

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.

2019-01-28

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.

2017-01-05

7,712 reads

Blogs

A First Look at Redgate’s Subsetter

By

I have been a proponent of subsetting databases in dev/test for a long time....

Azure SQL MI License free?

By

A common setup when leveraging the cloud is to use the cloud for Disaster...

Foreign Keys in SQL Data Generator

By

A customer recently asked about using FKs in SQL Data Generator, and I decided...

Read the latest Blogs

Forums

If anyone used tools like Gee-Pee-Tee for writing T-SQL (MS SQL server)?

By VAI

If anyone used artificial intel like Gee-Pee-Tee for writing T-SQL (MS SQL server) code...

Syntax Problem

By charliedurnin@gmail.com

I think that I am almost there but I am getting one red squiggle...

Excel Source [24]] Error: System.Exception: SqlTruncateException:

By yrstruly

Please assist. I am using SSIS to read data from an Excel sheet into...

Visit the forum

Question of the Day

Query Execution Modes

What are the two distinct processing modes that the SQL Server Database Engine can use to process T-SQL statements?

See possible answers