DBInsight's Blog

Cloud Based Monitoring – the TCO is Compelling

These days organisations are more comfortable and adept at deploying critical systems to the Cloud, however, the same support challenges faced in on-premise environments are now being encountered in the Cloud. One important challenge that needs to be met in the Cloud is how to maximise system uptime and avoid the unexpected at the same […]

Continue Reading →

Posted in: AWS, Azure, Cloud, DBA, SQL Server Monitoring

Leave a Comment (0) →

Licensing Active/Passive SQL Server Configurations in the Cloud

Considering a SQL Server active/passive configuration in the Cloud? If so, be prepared to fork out more in SQL Server licensing if deploying to shared third party server providers like Azure and AWS. First of all you will need software assurance to be able to assign a BYO SQL Server license to a VM running […]

Continue Reading →

Posted in: Availability Group, AWS, Azure, Cloud, High Availability

Leave a Comment (0) →

SQL Server Failover between AWS and Azure using SQL 2014 Standard Edition

In Part 1 of this series I described how to create a three node, multi-site SQL Server 2014 cluster across two AWS servers and an Azure VM using SIOS DataKeeper Cluster Edition to mirror the clustered data disk. On the positive side the article presented a neat and robust HA/DR solution for AWS cloud implementations, […]

Continue Reading →

Posted in: AWS, Azure, Cloud, Cluster, High Availability

Leave a Comment (0) →

SQL Server Failover between AWS and Azure – Part 1

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. What if you could seamlessly failover between Cloud providers and eliminate the “all eggs in […]

Continue Reading →

Posted in: AWS, Azure, Cloud, Cluster, High Availability

Leave a Comment (4) →

Announcement – SQLRDS by DBInsight Now on the AWS Marketplace

The SQL Server Relational Database Services (SQLRDS) by DBInsight has now been released on the Amazon Web Services Marketplace site. The AWS Marketplace link is here and the SQLRDS official site is www.sqlrds.com SQLRDS by DBInsight maximises your uptime, security and performance of your SQL Server, and if Murphy’s Law does strike then DBInsight will […]

Continue Reading →

Posted in: AWS, Azure, Company News

Leave a Comment (0) →

BI Corner – Analytics Wars, Excel\Power Pivot vs Tableau

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 Lifetime of Report […]

Continue Reading →

Posted in: Business Intelligence, Power BI

Leave a Comment (0) →

Transactional Replication Performance and Virtual Log File Counts

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. Initially I thought that either the Log Reader or Distribution agent had a connectivity […]

Continue Reading →

Posted in: Performance, Replication

Leave a Comment (0) →

Transactional Replication Identity Column Hell

Recently I re-created 80+ Transactional Replication publications with Updateable Subscriptions as part of a data centre move. The data centre move process included a custom log shipping process to create and maintain the 80 “publication to be” databases in the new data centre server, at cut over the original SQL Server transactional replication to other […]

Continue Reading →

Posted in: Replication

Leave a Comment (0) →

Transactional Replication VS Availability Groups for Read Only Workloads

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 :- You don’t have to replicate everything when using TR, you can select tables, columns or even data subsets. You can also eliminate […]

Continue Reading →

Posted in: Replication

Leave a Comment (3) →

Use Power BI to Forecast Server Capacity

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 … Power BI is a cloud-based service that works with Excel to provide a […]

Continue Reading →

Posted in: Business Intelligence, Capacity Planning, DBA, Power BI

Leave a Comment (0) →
Page 1 of 7 12345...»