I spent $0 out of pocket for 10 hotel nights in Germany


I took my very first solo trip to Europe last year. After some debate, I settled on Germany as my destination, since I speak some German and have always been intrigued by the country’s history and culture.

After securing my first long-haul lie-flat business-class seat on United Polaris for 60,000 Air Canada Aeroplan points plus $58.95 in taxes and fees, I began planning my hotel strategy.

As a big Hyatt fan who had tons of Chase Ultimate Rewards points at the time of booking, I knew the brand’s portfolio would be my go-to for each of my stays. I knew I wanted to cover multiple cities during my 10-day trip, so I focused on locations with at least one Hyatt property.

Thanks to my points stash, I managed to book stays for my entire time in Germany without paying a single cent out of pocket. In fact, with 87,500 points, I covered 10 nights in some convenient, enjoyable Hyatt properties. Here’s how I did it.

Frankfurt — Hyatt House Frankfurt Eschborn

Points cost: 12,000 points for a three-night stay

My first stop was Frankfurt. Frankfurt has two Hyatt properties, and while the Hyatt House Frankfurt Eschborn is not very conveniently placed relative to the city center, Frankfurt’s fantastic public transportation system makes it easy enough to get around.

I was able to walk from the transit station to the hotel, but it took me about fifteen minutes. If you have the budget, I’d strongly suggest using a ride-hailing service, especially if you have a train or plane to catch after your hotel stay.

The hotel itself was nice, but for a brand with “house” in the name, my room felt a bit cold and dark. It was sort of a jarring transition to move from the bright, comfortable lobby area to my accommodations.

The Hyatt House Frankfurt Eschborn’s lobby. OLIVIA MITTAK/THE POINTS GUY

The hotel was very clean and spacious, however, so I can overlook the bland design choices.

Reward your inbox with the TPG Daily newsletter

Join over 700,000 readers for breaking news, in-depth guides and exclusive deals from TPG’s experts

Breakfast was offered buffet-style. I don’t have any dietary restrictions, so I easily found plenty of options. Vegans and those with a gluten allergy may struggle, though.

Given the overall cost for a three-night stay, I recommend this property as long as you’re okay with its location.

Cologne — Lindner Hotel Cologne City Plaza

Points cost: 16,000 points for a two-night stay

The Lindner Hotel Cologne City Plaza was the complete opposite of the Hyatt House Frankfurt Eschborn as far as location; it was extremely conveniently placed, being just a short walk from transit.

The biggest standout for me at this hotel, which I enjoyed overall, was the shower. While it had the typical, sort of odd half-door setup that European hotels seem obsessed with, I loved the shower itself. It was very spacious with excellent, fine-tuned temperature.

The Cologne Cathedral. OLIVIA MITTAK/THE POINTS GUY

Breakfast on-site was very nice; I especially appreciated the smoothies they had on offer.

Since I had a late train out to my next city after this hotel stay, I was grateful for the spacious lobby, where I spent time relaxing as I waited for departure time.

The points cost for this hotel can definitely get a little pricey if you’re staying for several days, but I felt two nights were sufficient for Cologne. It’s enough time to see the Cologne Cathedral (which feels like stepping into a throne room from a fantasy book, by the way) and to do a brewery tour. I only recommend staying longer if you want to dive deep into Cologne’s beer scene.

Related: How I booked a Hyatt hotel for just 2,000 points per night this summer

Ulm — Me and All Hotel Ulm

Points cost: 19,500 points for a three-night stay

Out of all the cities I visited in Germany, Ulm surprised me the most. I wasn’t expecting to have much to do, but the city is very walkable and charming. If you’re interested in architecture, there’s plenty to look at around Ulm.

The biggest attraction here is the Ulm Minster, the second-tallest church in the world. I visited Germany at the time of the Christmas markets, so the Ulm Christmas Market was on full display right in front of the church.

Me and All Hotel Ulm is the only Hyatt property in Ulm, and it’s located right across the street from the train station. This made it incredibly convenient for me, since I traveled between each city on the Deutsche Bahn. My room was very comfortable, and I appreciated the amount of equipment available in the gym.

There’s also a great view of the Ulm Minster from the rooftop lounge where breakfast is served. Breakfast options were similar to those at the Hyatt House Frankfurt Eschborn. The food was great — especially the tiny donuts.

Related: I didn’t expect to love World of Hyatt, but here’s why I do

Munich — Andaz Munich Schwabinger Tor

Points cost: 40,000 points for a two-night stay

This was my splurge hotel to wrap up my trip. This is not only my favorite hotel I stayed in during my trip, but my favorite Hyatt property overall so far. The corner room I received definitely helped.

The bed was the most comfortable out of all the properties I stayed at, the breakfast was extensive and delicious, the bathroom was huge and the location was great. Transit was a stone’s throw away from the hotel.

My room at the Andaz Munich Schwabinger Tor. OLIVIA MITTAK/THE POINTS GUY

If I returned to only one city in Germany, it’d be Munich. I didn’t get to explore as much as I wanted to, since most of my time there consisted of day trips to the surrounding area. You could easily make a day trip out of Ulm if you’d prefer to stay in Munich.

The downside is that this is an expensive points hotel, but the welcome bonuses on Chase cards like the Chase Sapphire Reserve® (see rates and fees) can easily cover the cost of a three- or four-night stay.

How I earned my points

As I mentioned before, all of the points I used for these bookings came from my Chase Ultimate Rewards account. I earned those points through a combination of spending and welcome offers on these cards:

To learn more, check out our reviews of the Chase Freedom Flex, Chase Freedom Unlimited and Chase Sapphire Preferred.

A reminder before you book

Remember that Hyatt is overhauling its award chart this month. While it’s maintaining its award chart, award nights at many properties could get a lot more expensive. That may include the properties I’ve mentioned here.

If you’re planning a trip to Germany, I strongly recommend booking now. That’s especially true for a property like the Andaz Munich Schwabinger Tor, which is already fairly expensive before these changes.

Bottom line

Without points and miles, I wouldn’t have been able to even dream of spending 10 days in Germany. I even earned a free night thanks to Hyatt’s Brand Explorer perk, which awards one free night for every five brands you stay at. I’d previously stayed at a Hyatt Regency, so the four different brands I covered in Germany got me to that five-brand mark.

The money I saved from my hotel stays went to food, transit and activities instead, which I personally would much rather spend my money on. (Traveling across the world just to wind up stuck in a hotel because I blew my budget on accommodations isn’t my idea of fun.)

You don’t need to have hundreds of thousands of points to make meaningful redemptions — with just 87,500 points, I was able to book 10 nights worth of Hyatt properties.

Related: World of Hyatt wish list: 2 TPG Globalists on their dream program changes



Source link

Leave a Reply

Subscribe to Our Newsletter

Get our latest articles delivered straight to your inbox. No spam, we promise.

Recent Reviews


SQL Server Clustering – Table of Content

What is SQL Server Clustering?

SQL Server clustering is a term that describes a collection of two or more physical servers (nodes) connected by a local area network (LAN), each of which hosts a SQL server instance and has access to shared storage. When a server hosting the SQL Server instance fails, clustering SQL servers provide high availability and disaster prevention.

A hardware breakdown on a standalone server can bring your activities to a standstill. If a node fails, clustering allows you to instantly fail over to another node with minimal downtime, allowing your users to continue working while IT works to resolve the issue. You can quickly roll back operations once the primary server is fixed.

    Wish to make a career in the world of SQL Server DBA?  Then Start with HKR’S SQL Server DBA Online Training Course!

Why SQL Server Clustering?

SQL Server clustering can help reduce downtime when applying upgrades and security patches as compared to using a stand-alone server.

While SQL Server clustering increases availability and reduces downtime, it does not improve server or application performance. You must boost the computational power of the servers to improve performance.

SIOS SQL Server Clustering Solutions are introduced in this article, along with a high-level comparison of SIOS and Microsoft’s SQL clustering solutions.

SQL Server DBA Training

  • Master Your Craft
  • Lifetime LMS & Faculty Access
  • 24/7 online expert support
  • Real-world & Project Based Learning

Clustering Solutions for SQL Server SIOS

SIOS Technology Corp. provides high-availability clustering solutions to help you recover from infrastructure and application failures automatically. SIOS offers two options for ensuring SQL Server high availability:

  • SIOS DataKeeper Cluster Edition: It’s a Windows application that uses Microsoft Windows Server Failover Clustering (WSFC) to enable SQL Server clustering with or without shared storage (SANless). A SANless environment removes single points of failure, improves replication performance, protects non-SQL Server applications, and safeguards distributed transactions and system databases.
  • SIOS Linux Protection Suite: In a SAN or SANless environment, it protects business-critical applications and databases, including SQL Server, with a tightly integrated combination of failover clustering, continuous application monitoring, data replication, and configurable recovery rules.

Let’s take a closer look at each solution’s features and benefits.

SIOS DataKeeper Cluster Edition

Windows Server Failover Clustering (WSFC) is a high-availability component of the Windows Server platform. WSFC is often used to offer high availability for SQL Server applications. WSFC coordinates redundant computing resources and controls the recovery of SQL Server processes and data on a standby node in the event of a server or application failure. Unfortunately, there is no SAN accessible if you want to operate your SQL Server application in the cloud.

SIOS DataKeeper Cluster Edition enables you to simply construct a SANless WSFC for your SQL Server applications running in the cloud, in virtualized environments like VMware or Hyper-V, or on physical servers with only local storage to provide high availability and disaster recovery. SIOS cluster software synchronizes local storage via real-time (synchronous or asynchronous) block-level replication, while WSFC controls the software cluster. WSFC sees the synchronized storage as regular SAN-based storage. Hybrid cloud arrangements between an on-premises data center and the cloud can also be created for disaster recovery protection.

Microsoft has fully validated SIOS DataKeeper Cluster Edition software, which provides Enterprise-Class availability in any configuration across cloud regions and zones.

SIOS SANless clusters not only reduce the cost, complexity, and risk of a single point of failure associated with a SAN, but they also enable you to employ the latest in fast PCIe Flash and SSD storage for performance and protection in a single cost-effective solution.

Linux SIOS Protection Suite

The Linux SIOS Protection Suite consists of the following features:

  • SIOS LifeKeeper: It is a versatile failover clustering software that monitors the entire application stack and orchestrates SQL Server application failover in accordance with industry best practices.
  • SIOS DataKeeper: It is a host-based, block-level data replication solution for mirroring local storage in a SANless cluster arrangement or disaster recovery replication to remote sites or the cloud.
    Multiple Application Recovery Kits (ARKs): It provides the application intelligence as well as automatic configuration and validation to secure your mission-critical applications and data from outages and disasters.

SIOS Protection Suite could support a standard HA hardware-based cluster in a SAN environment, but it can also be used to build a shared-nothing approach to server clustering, allowing it to function SANless. For a wide range of applications, it provides a resilient, versatile, and simply configurable solution with automatic and manual failover/failback recovery rules.

                                                                                        Lets’s get started with SQL Server DBA Tutorial online!

Database Management & Administrations, clustering-sql-server-description-0, Database Management & Administrations, clustering-sql-server-description-1

Subscribe to our YouTube channel to get new updates..!

Clustering Solutions in SIOS vs. Microsoft SQL

On the market, there are alternative SQL Server clustering options. Microsoft provides some of the most popular SQL Server clustering solutions, including:

  • Basic Availability Groups in SQL Server.
  • Availability Groups in SQL Server Always On.
  • Shared Storage SQL Server Failover Cluster Instances

SQL Server Basic Availability Groups is a Windows-based clustering engine that can support up to two nodes. It functions similarly to a database mirroring solution. While both clustering and mirroring promote high availability, mirroring only allows for database failover. Clustering is the preferable approach if you have additional services, files, or other resources outside of SQL that you need after a failover, or if you have multiple databases that must stay together.

SQL Server Always On Availability Groups runs on both Windows and Linux, and it “provides an enterprise-level alternative to database mirroring,” according to Microsoft. It needs an expensive SQL Server Enterprise Edition.

When you use SQL Server Standard Edition with SIOS’ SQL clustering solutions, you can save up to 70% on software licensing expenses while getting enterprise-class clustering functionality.

Windows and Linux are supported by SQL Server Failover Cluster Instances with Shared Storage. It’s a one-site solution that necessitates the use of a SAN.

SANs, however, are costly to buy and operate, necessitate SAN administration knowledge, and are a single point of failure. The performance of a database can also be impacted by a SAN.

Here’s a more extensive comparison of SQL Server Always On, SQL Server Failover Cluster, and SIOS DataKeeper Cluster Edition’s benefits and weaknesses.

Clustering SQL Server in the Cloud

SIOS DataKeeper and SIOS Protection Suite for Linux offer high availability and disaster recovery protection for Windows and Linux applications running on any physical, virtual, cloud, or hybrid cloud architecture. For instance, SIOS DataKeeper could:

  • Protect critical on-premises or hybrid business applications, such as SQL Server, in AWS, Azure, or Google Cloud high-availability Windows or Linux environments.
  • Create a Windows or Linux cluster on AWS, Azure, or Google Cloud to protect your SQL Server cloud application.
  • By failing over SQL Server instances across cloud availability zones or regions, you may provide sitewide, local, or regional high availability and disaster recovery protection.

Both SIOS DataKeeper Cluster Edition and SIOS Protection Suite for Linux can provide fully certified high availability cluster protection across cloud regions and availability zones, simulating clustered shared storage.

SQL Server DBA Training

Weekday / Weekend Batches

Conclusion:

SIOS offers solutions that cover a wide range of applications, operating systems, and infrastructure environments, allowing you to use a single solution to meet all of your high availability requirements. Here are a few instances that show how powerful SIOS may be.

  • SIOS DataKeeper with WSFC was used by PayGo (paygoutilities.com) to provide high availability for SQL Server on AWS.
  • In a critical healthcare network environment, a healthcare information service provider employs SIOS DataKeeper to protect their important SQL Server in more than 18 cluster nodes, minimizing bandwidth concerns, boosting data protection, and reducing downtime.
  • Mavis Discount Tire relies on SIOS DataKeeper Cluster Edition to keep its mission-critical SQL Server up and running.

Related Articles:



Source link