Tag Archives: #SANLess Clusters for SQL Server Environments

Announcing AWS Quick Start Deploymnent Templates for SIOS SQL Failover Cluster

AWS Quick Start Templates Deploy SQL High-Availability Failover Cluster in the Cloud

Many businesses are struggling to deploy a high-availability failover cluster for SQL Server and other important applications in the cloud. This is because you need shared storage to create a failover cluster. Shared storage is not available or practical in most public clouds. As a result, Many IT teams kept SQL on-premises. Their experts in IT network, storage, and server would take months to plan, order, install, and configure physical environments for HA failover clustering. Finally, they would spend spent thousands of dollars upgrading to SQL Server Enterprise edition to gain advanced clustering capabilities.

SANless Failover Clustering Enables Cost-Efficient SQL High Availability Protection in the Cloud

Today, SIOS DataKeeper Cluster Edition is the first HA/DR solution to combine fully automated, application-centric clustering and efficient data replication. By integrating seamlessly into Windows Server Failover Clustering (WSFC), it enables a WSFC to work in a cloud where shared storage is not possible. SIOS DataKeeper works by synchronizing local storage in real time using highly efficient block-level replication. In this way, creates a SANless cluster to protect your Windows applications in the cloud. You can use it to protect SQL Server Standard Edition without the need for costly upgrades to SQL Server Enterprise Edition.

Quick Start Templates Make Deploying a Failover Cluster in AWS Easy

Now companies can easily deploy a two-node high-availability failover cluster automatically using an AWS EC2 Quick Start deployment. System administrators and managers can simply purchase the SIOS Amazon Machine Images (AMIs) on AWS Marketplace. They can use the AMI to deploy a two-node SQL Server Standard Edition cluster in the AWS cloud using an AWS Quick Start template.

Quick Start templates are automated reference deployments for key workloads on AWS. Each Quick Start launches, configures and runs the AWS service required to deploy a specific workload on AWS. Importantly, the templates use AWS best practices for security and availability. As a result, Quick Starts eliminate manual steps with a single click – they are fast, low-cost, and customizable.

The SIOS AMIs on AWS Marketplace provide an easy, convenient way for customers to purchase SIOS DataKeeper software to protect business critical applications in AWS. You can use them to deploy a high availability cluster using cost efficient SQL Server Standard Edition in the cloud.

Customers can purchase SIOS DataKeeper through the AWS Marketplace at: https://aws.amazon.com/marketplace/seller-profile?id=3c91e2f7-fc8d-4cce-a8aa-1e37abcb4408

To learn more about the SIOS DataKeeper Quick Start for AWS Cloud, visit: https://aws.amazon.com/quickstart/architecture/sios-datakeeper/

To learn more about the SIOS DataKeeper Cluster Edition for High Availability in Cloud Deployments:

SAN and SANless Clusters Resources

August, 5 2015: SIOS Sponsors South Florida SQL Server User Group – Fort Lauderdale

SIOS is proud to sponsor the South Florida SQL Server User Group’s August 5th meeting in Fort Lauderdale. If you’re in the area, I highly recommend joining!

Register Now

August 5, 2015 at 6:00 PM
Location:
Microsoft (Map)
6750 North Andrews Ave. Suite #400
Ft. Lauderdale, FL
Cost:
This is a free event – Food and Drinks will also be provided at no cost.

This groups meeting registration is managed through meetup.com. If you are not a member of the group, just click the join group button. This group is open and everyone is welcome. You will need to be a member of the group to see additional meeting and group details.

July 25, 2015: SIOS is Proud to Sponsor SQLSaturday Manchester

Register Now for SQLSaturday Manchester (UK)
June 25, 2015
Location: Mechanics Institute in Manchester | 103 Princess Street, Manchester M1 6DD, UK (Map)
Cost: There may be a small fee to cover the cost of lunch, the event itself is free. Please contact the organizers for more information.

SIOS is proud to sponsor at SQLSaturday Manchester. Be sure to visit the SIOS table for your chance to learn more about our SAN and #SANLess solutions, enjoy some candy, and drop off your raffle ticket for your chance to enter our end of day raffle. There are a number of great tracks, so be sure to plan your schedule well in advance (schedule).

If you are interested in additional training, SQLSaturday Manchester is holding Pre-Cons on the 24th of July. Pre-cons are paid events that include a full additional day of training from Microsoft, Redgate, and other industry leaders and experts. Pre-Con session details can be found at http://manchesterpass.ddns.net

July 16, 2015: SIOS is Proud to Sponsor the Denver SQL Server User Group

SIOS is proud to sponsor the Denver SQL Server User Group’s July 16th meeting in Denver. If you’re in the area, I highly recommend joining. The topic and and speaker are currently being confirmed. That information will be posted as soon as it is made available.

Registration/More Info:
DenverSQL Meetup Group Denver.SQLPASS.org

July 16, 2015 at 5:30 PM
Location:
Microsoft (Map)
7595 Technology Way, Suite 400
Denver, CO 80237
Cost:
This is a free event – Food and Drinks will also be provided at no cost.

This groups meeting registration is managed through meetup.com. If you are not a member of the group, just click the join group button. This group is open and everyone is welcome. You will need to be a member of the group to see additional meeting and group details.

July 22, 2015: SIOS Sponsors South Florida SQL Server User Group – Miami (Updated)

Update: SSSFUG has moved this meeting from July 15th to July 22nd.

SIOS is proud to sponsor the South Florida SQL Server User Group’s July 22nd meeting in Miami. If you’re in the area, I highly recommend joining. Kevin Boles will be presenting “SQL Server Defaults SUCK!!” and we’ve included the abstract for you below the fold.

Register Now

July 22, 2015 at 6:00 PM
Location:
Carnival Cruise Lines (Map)
6750 North Andrews Ave. Suite #400
Ft. Lauderdale, FL
Cost:
This is a free event – Food and Drinks will also be provided at no cost.

This groups meeting registration is managed through meetup.com. If you are not a member of the group, just click the join group button. This group is open and everyone is welcome. You will need to be a member of the group to see additional meeting and group details.

Abstract: SQL Server Defaults Suck!!!

By Kevin Boles

If you just click next-next-next and think you have a good-to-go SQL Server THINK-AGAIN!! 🙂 There are umpteen things you just GOTTA change right out of the box if you want your potentially very expensive and always precious SQL Server resource to perform and behave optimally. This session will cover a laundry list from data and log file growth factors to Windows power settings and many useful items in between.

Unit Testing SQL Server

In the nearly 20 years I have been working with SQL Server, most of that as an independent consultant, I can count two hands the number of clients I have come across that had ANY database tests constructed. I can count on TWO FINGERS the number of them that had repeatable database tests. Even the most ardent Agile/Scrum/pick-your-new-and-shiny-development-mantra shops hardly ever do anything more than wave a magic wand at testing the database, because it can be REALLY HARD to do and do correctly. In this session we will cover examples of why repeatable database testing is CRITICALLY important and then examine both a free and a low-cost commercial product to ease the pain and improve developer efficiency.

Update — Clustering 101 Webinar Postponed — June 24, 2015: Live Clustering 101 Webinar: HA Implementation Without Disruption or Delay

Update: Due to severe weather and power outages, today’s SIOS Clusters 101 webinar is cancelled. We are sorry for the inconvenience and we will let you know when it is rescheduled.

In this month’s Clustering 101 webinar Dave Bermingham reviews strategies for implementing high availability and disaster protection for SQL Server without disrupting ongoing business operations. He will discuss real-world scenarios, key preparations, and the necessary steps for installing and configuring a SANLess Window Server Failover clustering quickly and efficiently. 

You can participate before the event by tweeting your questions to @SIOSTech using #Clustering101 and of course bring your own questions and comments.

Register Now

High Availability (HA) Implementation Without Disruption or Delay

Date: June 24, 2014 — To be Rescheduled
Time: 10:00a PDT / 1:00pm EDT

About Clustering 101 Series

Clustering 101 is a webinar series hosted by Microsoft MVP, Dave Bermingham focused on addressing the numerous facets of clustering for high availability, data replication and any combination there of. This series will air monthly, the fourth Wednesday of the month at 10:00a PST / 1:00p EST.

About Dave Bermingham

David Bermingham is recognized within the technology community as a high availability expert and has been honored by his peers by being elected to be a Microsoft MVP in clustering since 2010. David’s work as director, technical evangelist at SIOS Technology Corp., has him focused on Microsoft high availability and disaster recovery solutions as well as providing hands on support, training and professional services for cluster implementations. David holds numerous technical certifications and draws from more than twenty years of experience in IT, including work in the finance, healthcare and education fields, to help organizations design solutions to meet their high availability and disaster recovery needs. Learn more at www.us.sios.com

Press Release: Implementing a SANLess Cluster in Under an Hour Will be the Focus of the Next SIOS Webinar

SAN MATEO, CA – June 11, 2015 – SIOS Technology Corp. (www.us.sios.com), maker of SAN and #SANLess clustering software products, today announced that MS SQL Server MVP Kendal Van Dyke will be the featured presenter in a live webinar that will teach attendees how to implement a SANLess SQL Server clustered instance in less than an hour.

Titled, “Implementing a SANLess SQL Server Cluster in Under an Hour,” this webinar will be held on Thursday, June 18 at 10:00 AM PDT / 1:00 PM EDT. To register, please visit: http://us.sios.com/2015-06-webinar

In this webinar, Kendal Van Dyke will share how to migrate a replication distributor from a standalone instance to a clustered instance in under an hour. Drawing from real world experience, Kendal’s use case is a company that needed to implement a failover cluster to protect their SQL Server replication distributor and the applications that rely on it during a strict one-hour window and without causing disruption to ongoing business processes or slowing performance. Kendal will describe the customer’s HA needs, options and why a SIOS SANLess cluster was the solution of choice.

About the Speaker

Kendal Van Dyke is a principal consultant at UpSearch, a Microsoft Cloud and Database Platform Partner. Kendal is passionate about helping leaders use Microsoft’s SQL Server to solve complex problems that protect, unlock and optimize data’s value. Since 1999, Kendal has specialized in SQL Server database management solutions. He excels at disaster recovery, high availability planning/implementation and debugging/troubleshooting mission critical SQL Server environments. He currently serves the SQL Server community as founder and president of MagicPass, the Orlando, FL based chapter of the Professional Association for SQL Server (PASS). Since 2008, Kendal has operated a SQL Server focused blog at http://www.kendalvandyke.com/.

About SIOS Technology Corp.

SIOS Technology Corp. makes SAN and #SANLess software solutions that make clusters easy to use and easy to own. An essential part of any cluster solution, SIOS SAN and #SANLess software provides the flexibility to build Clusters Your Way™ to protect your choice of Windows or Linux environment in any configuration (or combination) of physical, virtual and cloud (public, private, and hybrid) without sacrificing performance or availability. The unique SIOS #SANLess clustering solution allows you to configure clusters with local storage, eliminating both the cost and the single-point-of-failure risk of traditional shared (SAN) storage.

Founded in 1999, SIOS Technology Corp. (www.us.sios.com) is headquartered in San Mateo, California, and has offices throughout the United States, United Kingdom and Japan.

# # #

SIOS, SIOS Technology, SIOS DataKeeper, SIOS Protection Suite, Clusters Your Way, and associated logos are registered trademarks or trademarks of SIOS Technology Corp. and/or its affiliates in the United States and/or other countries. All other trademarks are the property of their respective owners.

Contact:

Beth Winkowski
Winkowski Public Relations, LLC for SIOS
Phone: 978-649-7189
Email: bethwinkowski@US.SIOS.com

June 18, 2015: Live Webinar: Implementing a SANLess SQL Server Cluster in Under an Hour – Presented by MVP Kendal Van Dyke

Join Kendal Van Dyke as he shares how to migrate a replication distributor from a standalone instance to a clustered instance in under an hour.

Drawing from real world experience, Kendal’s use case is a company that needed to implement a failover cluster to protect their SQL Server replication distributor and the applications that rely on it during a strict one-hour window – and without causing disruption to ongoing business processes or slowing performance. Kendal describes the customer’s HA needs, options and why a SIOS SANLess cluster was the solution of choice.

Register Now, Space is Limited

Date: Tuesday June, 18th 2015
Time: 10:00a / 1:00p (Pacific/Eastern)
Hosted by: MSSQLTips.com

About Kendal Van Dyke

Kendal Van DykeKendal Van Dyke is a Principal Consultant at UpSearch, a Microsoft Cloud and Database Platform Partner. Kendal is passionate about helping leaders use Microsoft’s SQL Server to solve complex problems that protect, unlock and optimize data’s value.

Since 1999, Kendal has specialized in SQL Server database management solutions. He excels at disaster recovery, high availability planning/implementation and debugging/troubleshooting mission critical SQL Server environments. He currently serves the SQL Server community as Founder and President of MagicPass, the Orlando, FL based chapter of the Professional Association for SQL Server (PASS). Since 2008, Kendal has operated a SQL Server focused blog at http://www.kendalvandyke.com/.

Yes, You Can Have a SQL Server Cluster in VMware without Raw Device Mapping

As companies look to move SQL Server to VMware environments, they soon face the challenge of how to provide high availability protection. The problem is that Windows Server Failover Clustering requires shared storage, so in VMware environments you need to use Raw Device Mapping to give VMs direct access to the SAN. RDM limits your ability to use important VMware features such as vMotion, snapshots, and Virtual Consolidated Backup.

A simple solution is to add SANLess clustering software, such as SIOS DataKeeper Cluster Edition, to your WSFC. It uses efficient block level replication to synchronize local storage to appear to WSFC as a shared disk without the need for RDM. You get high availability protection without sacrificing VMware features, flexibility or performance.

I discussed this easy strategy and provided a brief demonstration in a recent webinar:

High Availability for SQL in VMware without Raw Device Mapping (On Demand Recording)

You may also be interested in viewing the following Clustering 101 webinar hosted by Microsoft Cluster MVP, Dave Bermingham:

Clustering 101 Webinar: VMware Guest Based High Availability Clusters – Ways to Protect SQL and Maintain Flexibility
(On Demand Recording)

Press Release: SIOS Technical Evangelist to Discuss Protecting Business Critical Applications in Cloud Environments at Cloud Expo

SAN MATEO, CA – June 4, 2015 – SIOS Technology Corp. (www.us.sios.com), maker of SAN and #SANLess clustering software products, today announced that SIOS Senior Technical Evangelist and Microsoft Clustering MVP, David Bermingham will present a session about protecting business critical applications in cloud environments at Cloud Expo taking place next week in New York, NY.

Titled, “Protecting mission critical applications in cloud environments,” David’s session is scheduled for Thursday, June 11 at 4:50 pm at the Javits Center, New York, NY. For more information about the Cloud Expo or to register, visit here.

Gartner predicts that the bulk of new IT spending by 2016 will be for cloud platforms and applications and that nearly half of large enterprises will have cloud deployments by the end of 2017. The benefits of the cloud may be clear for applications that can tolerate brief periods of downtime, but for critical applications like SQL Server, Oracle and SAP, companies need a strategy for HA and DR protection. By adding SANLess clustering software as an ingredient to Windows Server Failover Clustering, companies can provide HA and DR protection in a cloud where traditional shared-storage clusters may be impractical or impossible. Attendees at David’s session will learn the truths and myths of HA and DR in cloud deployments that can dramatically reduce data center costs and risks.

About the Speaker

David Bermingham is recognized as a high availability expert and has been honored by his peers by being elected to be a Microsoft MVP in Clustering since 2010. David’s work as Senior Technical Evangelist at SIOS Technology Corp. has him focused on helping enterprise companies provide high availability and disaster recovery solutions for their business critical applications.

About SIOS Technology Corp.

SIOS Technology Corp. makes SAN and #SANLess software solutions that make clusters easy to use and easy to own. An essential part of any cluster solution, SIOS SAN and #SANLess software provides the flexibility to build Clusters Your Way™ to protect your choice of Windows or Linux environment in any configuration (or combination) of physical, virtual and cloud (public, private, and hybrid) without sacrificing performance or availability. The unique SIOS #SANLess clustering solution allows you to configure clusters with local storage, eliminating both the cost and the single-point-of-failure risk of traditional shared (SAN) storage.

Founded in 1999, SIOS Technology Corp. (www.us.sios.com) is headquartered in San Mateo, California, and has offices throughout the United States, United Kingdom and Japan.

# # #

SIOS, SIOS Technology, SIOS DataKeeper, SIOS Protection Suite, Clusters Your Way, and associated logos are registered trademarks or trademarks of SIOS Technology Corp. and/or its affiliates in the United States and/or other countries. All other trademarks are the property of their respective owners.

Contact:

Beth Winkowski
Winkowski Public Relations, LLC for SIOS
Phone: 978-649-7189
Email: bethwinkowski@US.SIOS.com