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.

Number Security

by Steve Jones

SQLServerCentral.com

Editorial

Numbers are both very useful and also susceptible to all sorts of attacks when their domain is limited. Steve Jones looks at some issues occurring in today's world.

Removing Email from msdb Database

by Additional Articles

Database Journal

msdb

Is your msdb database growing bigger every day? If so you might want to consider purging some of the history records. Greg Larsen explains.

Identify Servers and the Databases Mounted in SharePoint

by Tushar Kanti

SQLServerCentral.com

Sharepoint

Identify the Database Server which is used to mount the database in Sharepoint 2010

The 2016 Salary Survey Results

by Site Owners

SQLServerCentral.com

Salary Survey

Get the data and look through our salary survey results.

The Salary Range

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones starts the year looking at salaries for developers and DBAs.

Triggers: Threat or Menace?

by Additional Articles

SimpleTalk

Triggers

Triggers are generally over-used in SQL Server. They are only rarely necessary, can cause performance issues, and are tricky to maintain If you use them, it is best to keep them simple, and have only one operation per trigger. Joe Celko describes a feature of SQL that 'gets complicated fast'.

Technology Guilt

by Steve Jones

SQLServerCentral.com

Editorial

Technology has made many advances in the world, but it has also eliminated many jobs. This Friday's poll asks how you feel about that as a technology worker.