All posts by Alex Volok
Azure Data Factory and REST APIs – Dealing with oauth2 authentication
In this first post I am going to discuss how to apply oauth2 authentication to ingest REST APIs data. OAUTH2 became a standard de facto in cloud and SaaS services, it used widely by Twitter, Microsoft Azure, Amazon. My example is based on EXACT Online API. The end-target of the blog series is to setup […]
Azure Data Lake Gen2 and SQL Server Integration Services
How it used to be “Azure Data Lake Generation 2” (or ADLS gen2) is the newest cloud data lake offering from a Microsoft. It supposes to bring the best of two worlds together: excelent performance and redundancy of a blob storage and secure filesystem capabilities of a data lake. However, for some time the ADLS […]
Automated Refresh of Databases on Development Servers
Databases that have to be copied from a production server It happens that databases in testing and especially acceptance environments needed to be refreshed by restoring backups from a production environment. The backup restore is seems like a trivial operation that can be done via SQL Server Management Studio wizard or via prepared T-SQL scripts.However, […]
How To Simplify Database Snapshots Creation in SQL Server
Database Snapshots is a powerful feature that can be used for quick reverts of the database to the state as it was in when a given database snapshot was created, as well as data and schema comparison between a source database and a snapshot. While this feature was shipped in SQL Server 2005 it was available […]
Helpful SQL Server trace flags
SQL Server can be configured in various ways. It can be done via well-documented commands like ALTER SERVER or via system stored procedure SP_CONFIGURE. However, there is another way and sometimes it brings changes to behavior that cannot be achieved using other knobs – the name of it is a trace flag. Trace flags are special switches that […]