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.

Disable Guest

Questions About Data Breaches that You Were Too Shy to Ask

News reports about data breaches are common occurrences. Even the companies that exist to keep our data safe are not immune. William Brewer answers the question about data breaches that you may be too shy to ask.

Guest

Read Only access to all databases to a user in a SQL Server Instance

Script to grant a SQL a user read-only access to all the databases in Server instance except the system databases and
-- the Log shipped databases(if any : secondary :read-only)

Azure DWH part 12: Permissions, roles, logins and users

In this article we will show some common roles and queries related to Azure SQL Data Warehouse.

Fix Orphan Users for All databases

Fix orphan database users on all user databases.