One of the benefits of using Azure-based Platform-as-a-Service and Software-as-a-Service offerings, is considerably quicker access to newly developed capabilities. In this article Marcin Policht focuses on row-level security, included in both Azure SQL Database V12 and SQL Server 2016 Community Technology Preview 2 (CTP2).
Learn how to find who has changed permissions from the default trace
Filegroups are a feature of SQL Server that most people don't use, but they can help you to better manage your databases as your data requirements grow larger and larger.
This technical article will cover in depth SQL Server 2014 Data Files on Azure Blob storage service, starting from step-by-step configuration
There is a world of difference between technology originating in or designed for the cloud and technology that predates but can run in the cloud.
Uncovering how the data 'works' in a business is harder than you might think. You can't get this knowledge second-hand from the IT department. You have to speak to the business at large. However, many people are fearful of the 'bod from IT' and the change that their IT initiatives will bring.
I have heard the new Power BI Desktop can screen scrape data off websites; how does that process work?
Today we have a guest editorial from Andy Warren that looks at the way some companies look to hire new workers.
Observing an index seek utilizing a composite index within SQL execution plan might be more than meets the eye – you should look again.
Measures such as using special characters and numbers within a password are of little use to security if passwords are then stored in an insecure way. Sergey Gigoyan explains how to encrypt and store passwords in a SQL Server database.
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Comments posted to this topic are about the item Managing Incidents and Fighting Fires
Comments posted to this topic are about the item Backing Up a DMK
Comments posted to this topic are about the item The Quiet Part
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers