DBInsight's Blog

Migrating Database Mirroring to an Availability Group – No 2

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 node in a remote […]

Continue Reading →

Posted in: Availability Group, High Availability

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

Tuning Dynamic AX Master Resource Planning Process

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. Looking under the covers I could see that a large blocking chain would develop just after […]

Continue Reading →

Posted in: Dynamic AX, Performance, SQL Server Monitoring

Leave a Comment (0) →

Cloud Application Design Paradigm Shift

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 machines running in the […]

Continue Reading →

Posted in: AWS, Azure, Cloud, Trends

Leave a Comment (0) →

Protect Your SQL Server Backups in the Cloud

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. There is that chance, a […]

Continue Reading →

Posted in: AWS, Cloud, Database Backups, SQL Security

Leave a Comment (0) →

Host vs VM Guest Performance Counters, which is right?

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. The first article Virtualization resource consumption counters lie to you […]

Continue Reading →

Posted in: Performance, SQL Server Monitoring, VMware

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) →
Page 3 of 7 12345...»