DBInsight's Blog

Press Release: Relational Database Services (SQLRDS) Now Available

DBInsight today has announced the release of their new SQL Server Relational Database Services (SQLRDS) for cloud based and on-premise SQL Server environments. SQLRDS implements a best practice framework for database administration, management and monitoring that prevents data loss and maximises your SQL Server’s performance and system uptime. SQLRDS is squarely aimed at the AWS […]

Continue Reading →

Posted in: AWS, Azure, Cloud, DBA, News

Leave a Comment (0) →

VMware Snapshot Kills Availability Group Cluster

Recently I was requested to investigate the Cluster failures underlying a SQL Server 2012 Always On Availability Group. The topology was a two node Windows 2012 cluster with a file share tie breaker as part of the Majority Node and File share Quorum model. The cluster servers were VMware 5.1 Guests and SQL Server 2012 […]

Continue Reading →

Posted in: Availability Group, Cluster, High Availability, VMware

Leave a Comment (2) →

SQL Server 2014 Licensing Fine Print Shockers – Part 2

As a follow up to the May 2014 article SQL Server 2014 Licensing Fine Print Shockers (here), Microsoft have indicated that MSDN subscriptions licensing would be allowed on “Dedicated” AWS EC2 instances, so in this case you don’t have to use production licensing for a dev/test SQL Server on a EC2 instance. Note when you […]

Continue Reading →

Posted in: AWS, SQL Licensing

Leave a Comment (0) →

SQL Server Backup to/Restore from AWS S3 Storage

The use of AWS S3 storage to store SQL Server backups makes sense, firstly it is significantly cheaper than EBS, secondly you can encrypt what’s stored and thirdly you can manage backup file retention and lifecycle using inbuilt functionality. Whether you decide to backup to local EBS disk first for performance then copy to S3 […]

Continue Reading →

Posted in: AWS, Cloud, Database Backups, DBA, SQL Server Tools

Leave a Comment (0) →

Why are Business Intelligence Projects So Different?

Have you ever wondered why BI projects are so different to the traditional IT development projects? I found this article 8 Ways that Business Intelligence Projects are Different (here) by Analytics8 that succinctly outlines the differences and what to watch out for when taking on a BI project. In summary, some of the core differences […]

Continue Reading →

Posted in: Business Intelligence

Leave a Comment (0) →

Which Windows Version/Edition to Use for Availability Groups

In this SQL Server Pro article Save Thousands in Licensing Costs for SQL Server AlwaysOn Availability Groups Michael Campbell makes a case on why Windows 2012 Standard edition provides the best bang for buck in supporting your AlwaysOn Availability Group implementation. Interestingly he also highlights some reasons why he thinks the older Windows version, Windows […]

Continue Reading →

Posted in: Availability Group, High Availability

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