| Changes to SQL Server 2014 Always On Availability Groups | | By Michael Otey, mike.otey@penton.com AlwaysOn Availability Groups were first introduced with SQL Server 2012, and they are, without a doubt, one of the most compelling reasons to migrate to SQL Server 2012. AlwaysOn Availability Groups enable high availability and disaster recovery for multiple SQL Server databases without the need for a shared storage SAN. Replicas can be used to offload backups and reporting workloads from the primary SQL Server instance.
Related: New Features in SQL Server 2014
AlwaysOn Availability Groups provide high availability for multiple databases, and they can make use of multiple secondary replicas. Each secondary SQL Server replica has its own copy of the protected databases. AlwaysOn Availability Groups continuously synchronize transactions from the primary replica to each of the secondary replicas. This replication can be configured as synchronous or asynchronous to support local high availability or remote disaster recovery. More . . . | | | | ADVERTISEMENT | Do Your Reports Have Stale Data? Read more!
Sponsored by HiT Software, Inc., a BackOffice Associates LLC Company
If you are struggling to get fresh data into your reports or analytic systems, download free paper, "Tips for Real-time Data and Reporting"! Set up your systems to replicate and update data automatically between any major database or analytic system and SQL Server, on your schedule. No programming necessary. Easy to set up and maintain. READ PAPER "TIPS FOR REAL-TIME DATA AND REPORTING" | | | | Integrating MongoDB and Open Source Data Stores with Power Pivot | | By Mark Kromer | | Business users and analysts make up the majority of our target personas in the business intelligence world. And it's not unique to SQL Server BI professionals that Excel is a preferred tool for analysis, pivoting and charting. We talk a lot about Power Pivot (yes, I remembered to put a space in the name that time!) and Power View as ways to model the source data (Power Pivot) and present it as compelling data visualizations (Power View). Presenting your organization's complex data as a simple set of compelling reports and flows is central to your value in the role of BI professional. More . . . | | Truncating SQL Server Job History | | By Michael K. Campbell | | A maintenance task that many 'reluctant DBAs' commonly overlook is the need to keep historical information in the msdb database trimmed, or 'truncated' on a semi-regular basis. Otherwise, it IS possible for so much data to get 'crammed' into this database over time to the point where performance can actual degrade. A common example or scenario of this is when you keep too much backup history on tab and go to use SQL Server Management Studio (SSMS) to run a 'restore' operation and the dialog just seems to churn, and churn, and churn, and churn forever (as it's silently processing virtually every restore operation from the vast store of historical information it has on hand).) As such, I thought it would be worthwhile to point out a couple of key considerations and details associated with truncating SQL Server Job history. More . . . | | SQL Server High Availability Foundations | | Join renowned SQL Server expert Allan Hirt on October 21st for a new online training course that will help you achieve optimum uptime for your databases. In this one-day eLearning course, you'll learn the different options when it comes to SQL Server high availability. Register by October 14th and save 15%! | |  | Live Webcast: Modernizing protection for your diverse physical-virtual-cloud infrastructure
| | September 26: Join Windows IT Pro contributing editor and Security MVP Orin Thomas for an in-depth look at backup strategies for your organization. Learn about inadvertent methodologies that are costing you big and creating unnecessary complexities. Register today!
| The Essential Guide to Database Monitoring
| | A Database Administrator's ability to keep their database running as smoothly as possible is absolutely vital to a business's success. Therefore, added simplicity to their ability to troubleshoot effectively can make a DBA's life a lot easier. In this guide, learn key points to vastly improve the way you monitor your database.
| | MORE RESOURCES | | |  | New Webcast: Scheduling Jobs with SQL Agent
| | October 8, join SQL Server Pro's Senior Technical Director, Michael Otey, for an intensive training hour over how to create and secure SQL Server jobs with SQL Agent. Get vital tips for tracking the success and failure of your SQL Agent jobs. Plus, troubleshoot problems you might encounter along the way with Michael and find out how to easily meet today's workload automation challenges. Register now!
| | Virtual Trade Show: Smart Data Management with Private Cloud | | Join us October 30th, 2013, for this free event where experts Michael Otey and Rod Trent will discuss moving SQL Server into a private cloud, database server consolidation, and big data for SQL Server pros. | | MORE EVENTS | | | |
No comments:
Post a Comment