Learn how to leverage Azure Active Directory when connecting to Azure SQL Database from applications or services in a non-interactive manner, by relying on token-based authentication.
2016-12-06
4,560 reads
Tim Radney of SQLskills discusses strategy and some available tools for helping migrate your databases to Azure SQL Database.
2016-11-28
2,879 reads
Marcin Policht focuses on the specifics of using Azure Active Directory to authenticate to Azure SQL Database.
2016-11-10
5,620 reads
Active Geo-location is powerful magic for ensuring the high availability of a Azure SQL database, and for disaster-recovery. In choosing the best options, you need to accurately understand the value that the business places on the service you're running, long it will take for a secondary replica to be in synch with the primary replica, the importance of spreading the location of replicas widely, and the maximum tolerable unscheduled downtime. Just clicking all the options could prove to be expensive.
2016-10-27
3,361 reads
One of the challenges when considering migrating your on-premises SQL Server databases to Azure SQL Database is its lack of support for Active Directory-integrated authentication. With the advent of Azure SQL Database V12, the authentication capabilities have been expanded, allowing for more flexibility that leverages Azure Active Directory. In this article, Marcin Policht provides an overview of this functionality.
2016-10-10
3,995 reads
So you've decided to use Azure SQL Database. You head for the portal and are suddenly faced with a number of questions. Sure, the choices you make have a number of repercussions, but what are they? Murilo Miranda provides a simple guide to get started.
2016-09-08
3,876 reads
Daniel Calbimonte shows how to create an Azure SQL Database with the AdventureworksLT data, and how to import the information into a SQL Server Analysis Services Tabular Model Database.
2016-08-26
5,872 reads
This article will help you to schedule jobs in Azure SQL.
2016-08-01
14,198 reads
As announced on June 1, 2016, SQL Server 2016 has reached its general availability. This means that you finally have the option to implement some of its new features in the production environment. While we still have to wait for their full support in Azure SQL Database V12, it is likely that their preview stage will be concluded soon. In this article, we will focus on Temporal tables, which is one example of these new features.
2016-08-01
4,507 reads
In this article, we will compare a traditional SQL Server Enterprise Edition with an Azure SQL Database and see the differences.
2016-07-26
15,156 reads
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Comments posted to this topic are about the item SSRS Reminded Me of the...
I have a need to execute a stored procedure and return the results to...
Title pretty much says it all - can this be done? I've tried several...
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers