DBInsight’s Blogs

Heartbleed SSL Bug – DBAs Should Be Aware
Posted by Rob Risetto on September 01, 2015

Whilst this bug is not directly related to SQL Server I thought DBAs should be aware of it since there are a lot of web servers out there accessing SQL Server back ends. I found this article Everything you need to know about the Heartbleed SSL bug by Troy Hunt to be one of the best in explaining the bug’s ins and outs.

Continue Reading

Reasons to Upgrade to SQL Server 2014
Posted by Rob Risetto on August 28, 2015

As you know SQL Server 2014 was released this month so the question is why would you consider upgrading to SQL Server 2014?  If you have a budget to implement the Enterprise Edition then you probably have more of a case to upgrade now, though items 3, 9 and 10 below may provide enough performance benefit to also consider

Continue Reading

Migrating Database Mirroring to an Availability Group – No 2
Posted by Rob Risetto on August 09, 2015

Flowing on from my previous article Migrating Database Mirroring to an Availability Group I thought it might be worth posting the high level steps that worked for me in converting a SQL Server 2008 R2/Windows 2008 R2 Enterprise Database Mirroring implementation into a two node Availability Group environment with the second

Continue Reading

Monthly DBA Maintenance Tasks for SQL Server
Posted by Rob Risetto on July 22, 2015

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.

Continue Reading

Tuning Dynamic AX Master Resource Planning Process
Posted by Rob Risetto on July 06, 2015

Recently a client of mine was experiencing performance issues with the daily Master Resource Planning (MRP) process run, in particular, not only would it run for extended periods but it would also stop other users from performing their tasks.

Continue Reading

Is the DBA Role Dead! Not By a Long Shot!
Posted by Rob Risetto on June 19, 2015

The following article from SQL Magazine (The DBA is Alive and Well—Here’s Why) provides a couple of opinions as to why the DBA role is not dead, I would like to add my two cents worth to this discussion.

Continue Reading

Cloud Application Design Paradigm Shift
Posted by Rob Risetto on June 01, 2015

I recently read the SQL Server Blog article Data-intensive Applications in the Cloud Computing World by Mark Souza, General Manager, Windows Azure Customer Advisory Team and it really drove home the concept that moving applications into the Cloud is not just about moving an application and related database to respective virtual

Continue Reading

Protect Your SQL Server Backups in the Cloud
Posted by Rob Risetto on May 20, 2015

Consider the following situation, you create a database backup on a AWS virtual machine EBS disk and then move the backup file to Blob storage e.g. S3. However, you have switch on the Encryption option for your S3 storage. Is your database backup file fully protected? Yes, well, sort of.

Continue Reading

Host vs VM Guest Performance Counters, which is right?
Posted by Rob Risetto on May 02, 2015

I thought it would useful to highlight to readers that there can be differences in what a VM Guest performance counters show verses similar counters presented by the VMware performance charts. The following articles provide an insight into some of the discrepancies you may face.

Continue Reading

Design and Build a Data Warehouse in 65{2ec0bbd3bfdf207d2f0779c26660c3798ccadae611e41b6dbc787103c4a85cdd} Less Time
Posted by Rob Risetto on April 19, 2015

Recently DBInsight completed a major BI/Data Warehouse project in just 79 days, utilizing a new Data Warehouse development tool called Dimodelo Architect.

Continue Reading