(Paul White) This post is part of a series of articles about row goals. You can find the other parts here:
Tag: sql server
Adaptive Joins
(Grant Fritchey) I was surprised to find out that a lot people hadn’t heard about the new join type, Adaptive join. So, I figured I could do a quick overview.
Migrating data On-Premises to Azure with the new Azure Database Migration Service (VPN Site-to-Site)
(André César Rodrigues) Recently Microsoft announced the Public Preview Azure Database Migration Service (Azure DMS), a new way to migrate your data from a SQL Server database or from other sources to Azure:
SQL SERVER – What is Forwarded Records and How to Fix Them?
(Pinal Dave) During the early year of my career, one of the most popular questions I used to receive was – What is Forwarded Record? I used to find this question very valid as many people yet did not know what is the forwarded record.
Azure SQL Database – Allow Azure Services to Access Server
(blobeater) When you create a “logical” Azure SQL Server (I say logical because we are not really physically creating anything) there is a setting that is ticked ON by default which is called “Allow Azure services to access server”.
Power BI Licensing – Cost Forecast Guide
(Jason Thomas) The other day, one of my enterprise customers asked me if there were any guides or documentation to forecast the cost for Power BI service licensing (Pro and Premium) for 3 years based on user growth.
Install and Configure SQL Server 2017 Availability Groups on Linux – Part 3
(Edwin Sarmiento) In a previous tip on Installing SQL Server vNext CTP1 on Red Hat Linux 7.2, we have read about how we can now install SQL Server 2017 on a Linux operating system. We would like to evaluate running SQL Server 2017 Availability Groups on Linux. How do we go about building the Linux e
Filtering Data Loaded Into A Workspace Database In Analysis Services Tabular 2017 And Azure Analysis Services
(Chris Webb) The first mistake that all new Analysis Services Tabular developers make is this one: they create a new project in SSDT, they connect to their source database, they select the tables they want to work with, they click Import, and they then realise that trying to load a fact table with s
Stop / Cancel ongoing Azure SQL DB scale operation
(Yochanan Rachamim) if you want to cancel updating database pricing tier. this can be due to mistake, or long running scale operation.
SQL SERVER – What is Tail-Log Backups?
(Pinal Dave) A prevalent question since many years often resurfaces in my mailbox. I am writing this blog here so in the future, I can direct users to this blog posts when they ask about Tail-Log Backups.
