Connect to Azure SQL Database with PowerShell Core
The post describes how to use token-based authentication to run SQL queries against Azure SQL Database.… Read More Connect to Azure SQL Database with PowerShell Core
Category: SQL Server
Create Azure API App with AAD authentication and web jobs – Data source
This post describes data source for tutorial “Create Azure API App with AAD authentication and web jobs”. It includes Azure SQL server, database, and database project and model class library.… Read More Create Azure API App with AAD authentication and web jobs – Data source
Workshop at Azure Day 2017
Workshop named “Create Azure API App with AAD authentication and web jobs” that describes how to use and secure Data API App in Azure environment with AAD authentication will be presented at AzureDay-2017 conference.… Read More Workshop at Azure Day 2017
Find representatives of circilar references in T-SQL
If you deal with a table that has foreign key to itself, circular references may appear. The query that lists all rows with circular references is listed at the page. Sometimes it is necessary to list only representatives of each set of circular referenced rows. In the following query the first select statement orders representatives… Read More Find representatives of circilar references in T-SQL
Event 14518 of Forefront TMG 2010
Recently, I saw the following entry in Event log of the test external server: The reasons are obvious – we moved the virtual server with deployed Forefront TMG 2010 from subnet 192.168.1.x to the (test) subnet 192.168.2.x. Let the server, where Forefront TMG is deployed, is called TMGServer. Its first static IP-address is 192.168.1.2, and… Read More Event 14518 of Forefront TMG 2010
Исправление XML схемы в SQL Server
В SQL Server 2008 есть очень полезный тип XML. C помощью команды CREATE XML SCHEMA COLLECTION [XML_схема] AS … можно создать xml схему, и использовать тип XML(DOCUMENT [XML_схема]) для формирования “правильных” значений xml. Однако, xml схему уже нельзя изменить, если она используется; например, существует поле таблицы, параметр процедуры или функции созданного типа. В этом случае… Read More Исправление XML схемы в SQL Server
I.Reznykov's blog 