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.
If you are a developer of SSIS packages then this article (here) will give you a good run down on the SSIS package deployment improvements in SQL Server 2012. These improvements will definitely make your life easier in deploying SSIS packages to multiple servers and environments.
The SQL Server 2012 Performance Dashboard is a free tool from Microsoft and assists in viewing the health and status of your SQL Server instance. It even works on SQL Server 2008. You can download it from (here).
Well not quite yet but the CTP1 (here) is out so you can download it and have a play. Some big changes are on the way including the In-Memory OLTP engine, ability create to Asynchronous Availability Groups to the Azure
The Self-Service Business Intelligence (BI) paradigm has be around since SQL Server 2008, and now SQL Server 2012 and Excel 2013 have provided even more enhancements and sweeteners for BI enthusiasts.
I’ve been following a number of threads featuring Self-Service BI vs. Corporate BI discussions. Some BI proponents are suggesting that Corporate BI is dead and that Self-Service BI, driven by the enhanced front-end products like of Excel 2013, PowerView, PowerPivot, are now making Corporate BI redundant.
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
Traditional monitoring tools find it difficult to securely monitor the On-premise and Cloud based SQL Servers. The DBAs typically need to run multiple monitoring tools that are not integrated and are disparate in functionality and reporting. In addition, monitoring infrastructure needs to be deployed into multiple sites and DBAs need to be trained to support multiple monitoring tools.
The trend that I’m seeing with my customers is that there is now a willingness to consider the Cloud for the deployment of mainstream database applications, especially if it’s a green fields project. In fact, some of my customers have already made the move and have deployed multiple SQL Servers in Amazon AWS and have
Following on from my backup performance post, the next challenge was trying to restore a backup on the mirrored server within a reasonable time. In this case, a reasonable time was 3 to 4 hours as opposed to 12+ hours. Again the issue we faced on AWS was the 39 MB/sec throughput limit per high