DBInsight's Blog

Archive for DBA

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) →

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) →

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) →

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) →

Monthly DBA Maintenance Tasks for SQL Server

This is Jason’s take on the monthly tasks for a SQL Server DBA (10 Monthly Maintenance Tasks for SQL Server). My recommendation is that these tasks should be automated where possible. For example,:- Verifying database backups can be easily automated using Powershell to pick up the latest backups and restore them on a test SQL […]

Continue Reading →

Posted in: DBA, PowerShell, SQL Server Tools

Leave a Comment (0) →