Azure SQL Database subscriber account A single login account is created when a logical SQL instance is created, called the SQL Database Subscriber Account. This account connects using SQL Server ...

Make your database portable by using contained databases [!INCLUDE SQL Server ASDB, ASDBMI, ASDW] Use contained database users to authenticate [!INCLUDE ssNoVersion] and [!INCLUDE ssazure-sqldb] ...

During the last few articles, we have covered the basics of working with SQL server using the Server Management Objects (SMO) and PowerShell. We have covered things such as viewing the state of ...

I have worked with SQL Server for many years now, back to Sybase SQL Server days and there has always been confusion over Logins and Users.

Most SQL Server databases have a number of users viewing and accessing data, which makes security a major concern for the administrator. The smart administrator will take full advantage of SQL ...

How to Start SQL in Single-User Mode. Organizations can use SQL Server to reduce downtime, manage and secure databases, and discover patterns in mission-critical information to improve business ...

This post is authored by Amit Banerjee, Principal PM Manager, SQL Server and Bob Ward, Principal Architect, Microsoft SQL Server Data Services. SQL Server has provided enterprises the capability to ...

Today, we announced the general availability of SQL Server 2022, the most Azure-enabled release of SQL Server yet, with continued innovation across performance, security, and availability.