DBInsight's Blog

Archive for SQL Server Tools

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

Design and Build a Data Warehouse in 65% Less Time

Recently DBInsight completed a major BI/Data Warehouse project in just 79 days, utilizing a new Data Warehouse development tool called Dimodelo Architect. DBInsight built a data warehouse for Legal Aid Queensland with 28 Dimension and 20 Facts in just 79 days. This included gathering requirements, installing and configuring an SQL Server 2012/SharePoint 2010 environment, developing […]

Continue Reading →

Posted in: Business Intelligence, SQL Server Tools

Leave a Comment (0) →

Preventative SQL Server Monitoring

This article (here) from LogicMonitor provides some interesting performance counters to review to isolate potential SQL Server performance issues. The performance counter charts are from the LogicMonitor monitoring tool, however, the same counters can be captured using your favourite performance counter capture tool. In this article’s case, the SQL Server Full Scans had significantly increased, […]

Continue Reading →

Posted in: Performance, SQL Server Monitoring, SQL Server Tools

Leave a Comment (0) →

Wait Statistics and FileIO Delta Capture Utilities Updated

Reviewing the deltas of Wait Statistics and Database File IO gives you a better indication of what is happening now on your SQL Server now and are not skewed by the historical accumulated values. The DBA utilities that captures the deltas of Wait Statistics and Database File IO statistics have been updated recently to cater […]

Continue Reading →

Posted in: Free tool of the week, SQL Server Monitoring, SQL Server Tools

Leave a Comment (0) →

Moving a SQL Cluster using Log Shipping

I recently had the requirement to configure log shipping in a SQL 2008 R2 Standard Edition environment. In my scenario, we needed to move a two node cluster to another floor but also attach it to a new SAN, have minimal downtime, no data loss and use the current server hardware. Database mirroring was not […]

Continue Reading →

Posted in: Database Backups, Log Shipping, PowerShell, SQL Server Tools

Leave a Comment (0) →

Log Shipping Lite with Powershell – Free tool of the week

Here’s an article (here) on the implementing a log shipping solution using Powershell scripts. This article is from SQL Server Central, so you will need to register on the site to log in. Anyway the article suggests this solution comes into play when you are constrained by Standard Editions of SQL Server 2008, 2012 Concerns […]

Continue Reading →

Posted in: Free tool of the week, SQL Server Tools

Leave a Comment (0) →