These days organisations are more comfortable and adept at deploying critical systems to the Cloud, however, the same support challenges faced in on-premise
Note: SQL Server 2019 Licensing Guide supercedes the information in this post. (Post updated 1/09/2020)
Considering a SQL Server active/passive configuration in the Cloud?
If so, be prepared to fork out more in SQL Server licensing if
In Part 1 of this series I described how to create a three node, multi-site SQL Server 2014 cluster across two AWS servers
We have all heard the story about the online business whose AWS account got hacked and had all of its Cloud inventory destroyed, then there’s the occasional scenario where a Cloud provider is totally disabled by a “core” infrastructure fault.
The SQL Server Relational Database Services (SQLRDS) by DBInsight has now been released on the Amazon Web Services Marketplace site.
This article from Rob Collie, What is Power Pivot’s #1 Competitor, was not only interesting because it highlighted where standard Excel falls down in analytics and how Tableau has exploited this for their own marketing. It also particularly interesting with respects to the two comparison charts showing the Time Investment Required vs
Recently I came across a client that could not get their Transactional Replication data transfer to complete within a reasonable timeframe. Replication initialisation would work ok but from then on no data changes would make it through to the subscriber database.
Recently I re-created 80+ Transactional Replication publications with Updateable Subscriptions as part of a data centre move.
The Transactional Replication (TR) is still one of my favourite parts of SQL Server, and provides some distinctive advantages over Always On Availability Group (AG) Read Only secondaries. The TR advantages include :
Microsoft recently announced the Power View forecasting feature which is available when running Power View in HTML 5 format through their Power BI for Office 365 cloud offering. For those that don’t know, the Power BI for Office 365 official description is …