Contents
Can a SSRs database be hosted in azure?
This article outlines the spectrum of options available for migrating your solutions based on the SQL Server Reporting Services (SSRS) to Microsoft cloud, with focus on the newly-introduced support for hosting SSRS databases in Azure SQL Managed Instance.
How does Azure hybrid benefit work for SQL Server?
Azure Hybrid Benefit allows the use of SQL Server licenses with Software Assurance (“Qualified License”) on Azure virtual machines. With Azure Hybrid Benefit, customers aren’t charged for the use of a SQL Server license on a VM. But they must still pay for the cost of the underlying cloud compute (that is, the base rate), storage, and backups.
How to configure integrated Windows Authentication with SSRS?
Once the library is installed, it gives access to a new Microsoft Azure SQL Database connection type in SSRS data source as show below: If you are already confident with Kerberos delegation with your SQL Server environment, configuring Kerberos delegation on ADFS didn’t raise special difficulties.
What kind of license is eligible for Azure hybrid benefit?
Only SQL Server core-based licensing with Software Assurance or subscription licenses are eligible for Azure Hybrid Benefit.
Should you run SSAS / SSIS / SSRs on the SQL Server?
Should you run SSAS/SSIS/SSRS on the SQL Server? When you’re building a new SQL Server, you’re going to see a few intriguing checkboxes during setup. It’s all free, right? Check everything! The services are all free, right?
Why do you need to run SSIs on azure VM?
In the SQL PASS Summit of 2016, I presented a session about “Running SSIS on Azure VM – Do more with less money” and it was well received based on the session feedback. Therefore, I am extracting some key content from my SQL PASS presentation and sharing it on this blog so that more SSIS users can benefit from it. Why running SSIS on Azure VM?
Is it OK to run SSIs and SQL Server at same time?
If you’re using SQL Server as a data warehouse platform for a traditional BI stack (meaning no real-time requirements), it’s usually OK to put SQL Server, SSIS and SSAS on the same box. During the night, the ETL (or ELT) runs and SQL Server and SSIS are busy, but SSAS is doing nothing until it is refresh time.