Review Minimum SQL Server Security Practices

In this tip we look at different things you should consider when developing your database systems to ensure you are also thinking about security best practices as well.

Owning Schemas

CLR Strict Security

Schema Owners

Security, Compliance, Data Ethics, and Breaking the “Not My Job” Mindset

Security, compliance, and data ethics are related concepts that everyone who works with software should know about, from the help desk to the C-level office… but almost everyone thinks that worrying about these things is someone else’s problem.

Granting CONTROL permission on a database

Setting Permissions to Drop a Database

Learn which permissions are required to drop a database and see a test to show that these apply.

Detecting Data Breaches

Data breaches make the news on an almost daily basis. There is no turning back, however, as we are firmly entrenched in this digital way of life. Brian Kelley discusses some of the reasons data breaches occur and what we can do to prevent them.

Enable FIPS 140-2 Compliance in SQL Server

What is FIPS? How do I use it? What is going to break if I do use it?

Introduction to Azure Cosmos DB Security

When analyzing security-related challenges, it is important to note that they encompass several distinct but interrelated technologies. In addition, when dealing with data services, it is also necessary to distinguish between the data plane, facilitating access to the underlying content and the management plane, which allows for delegation of administrative tasks. In this article, Marcin Policht explores how these concepts apply to the Azure Cosmos DB offering.