Tuesday, June 13, 2023

15 Things to Know About Visiting Bow Lake in Banff (Alberta)

 Bow Lake is one of the many lakes that line the Icefields Parkway and a popular stop for visitors to Banff National Park in Alberta, Canada. It’s no secret that the Canadian Rockies are not short of spectacular vistas and lakes.

Bow Lake is one of our top recommendations for a stop to stretch the legs on the Icefields Parkway. A short walk along the lakeshore trail is a family-friendly hike, or you can enjoy longer hikes around Bow Lake for a more complete day. Whatever you decide to do, make sure you don’t miss Bow Lake. Here’s all you need to know about this beautiful Banff lake.

Visiting Bow Lake

Bow Lake is a tremendous stop on the Icefields Parkway and one of our favorite Banff lakes to enjoy. While it’s not a large lake in the scope of the world, it is big for the Canadian Rockies.

In the Banff summer months, when the lake thaws, it turns a dizzying blue from the glacier melt of the Crowfoot Glacier and Wapta Icefield.

The sheer rock wall of Crowfoot Mountain, the hanging glacier, and the expansive Wapta Icefield provide an innate way of humbling all who gaze on the landscape.

Bow Lake sits at an elevation of 1920 meters and spends most of the year locked away in ice. This makes it a popular spot for winter activities like snowshoeing and ski touring. The lake acts as the source of the Bow River, a notable river in Banff National Park that flows through Banff, Canmore, and Calgary.

We love Bow Lake in the summer and have spent a lot of time exploring the area as there are several peaks and hikes. There are a plethora of options for hikers, scramblers, and mountaineers around Bow Lake.

Bow Lake also has an excellent picnic site with picnic benches along the shoreline just off the Icefields Parkway (Hwy 93), the perfect stop for lunch. It’s also an awesome spot to hang a hammock and relax along the shoreline.

Along its shore lies Num-Ti-Jah Lodge (now called The Lodge), a historic site built by one of Banff’s early mountain guides, Jimmy Simpson. The mountain above the lodge that sits at the North end of the Lake is also named after the man, Mount Jimmy Simpson.

Mount Jimmy Simpson is a wonderful objective for rock climbers or scramblers as there are multiple routes, and views from the summit are sublime.

Directions to Bow Lake

Bow Lake is located off the Icefields Parkway or 93N. The highway begins just off the Trans-Canada Highway #1, a few minutes West of Lake Louise. From there, it’s another 35 km to Bow Lake. You can find the exact location on Google here.

Watch for signs for Num Ti Jah Lodge (The Lodge) off the Icefields Parkway, and the turn off will be on your left coming from the Trans-Canada or on the right from Jasper.

Bow Lake is nearby Peyto Lake, so if you are heading to Peyto Lake it’s best to combine the two!

When is the Best Time To Visit Bow Lake?

The best time to visit Bow Lake in Banff is from June to September. Spring arrives around June and is a tremendous time as the lake melts. You can witness tons of wildflowers and a brilliant blue lake.

In summer the lake remains full and is always a great visit. In the Fall, late September to October, there are almost no larch trees, so fall colors are not present. If you plan to go hiking around the lake, the best time is from July to mid-September.

Once the lake locks into the winter come November, it can make for a fantastic place to snowshoe along the lake surface. The lake will be frozen and covered in snow, so you can not witness the gorgeous blue. Be cognizant to not approach the slopes of Crowfoot Mountain or any steep slopes as avalanches in the area are very common.

Bow Lake makes for a great photo stop along the highway in the winter, there’s an amazing bridge there that gives picture perfect photos. Otherwise, wintertime access is limited to the more adventurous and experienced on skis or split boards.

Things To Do at Bow Lake

With the dramatic rock wall face of Crowfoot Mountain, hanging glaciers, and the vivid blue, Bow Lake it’s one of the most popular stops for photographers to Banff National Park.

The classic shot is to park near the Num Ti Jah Lodge and take photos near the small footbridges at the water’s edge. It’s a stunning Alberta lakes scene. We think evening light is best if you’re a photographer planning out your photographs; the photo above was taken about an hour before sunset.

Hike

There are several tremendous hikes around Bow Lake. We’ll get more into the hikes further on in the post. The parking lot also provides access to the ACC Bow hut for backcountry and mountaineering trips.

Bow Glacier Falls

Hike to the origin of the Bow Glacier Falls (not to be confused with Bow Falls) for some outstanding views and a gorgeous Banff waterfall. It’s a pretty relaxed hike that spends the majority of time along the shoreline of Bow Lake.

However, the views from along the Bow Lake are spectacular, and at its finish, hikers witness the birth of a vital river in Alberta from the Wapta Icefield high above. It’s a great hike for those driving the Icefields Parkway as it only requires a few hours and gives a chance to stretch the legs.

  • Difficulty: Moderate
  • Elevation: 266 meters
  • Distance: 8.7 km
  • Time: 2 – 4 hours

Road trip to Calgary | 2022 | Summer road trip | Aug 2022

Total six days stay at hotels. 
  1.  Revelstoke - Motel stay, near $200 dollar/ day, one day, 7+ hours driving from Vancouver
  2.  Lake Louise, 3 hours tour by myself
  3. Calgary - Four day hotels, $115/ day
  4. Calgary downtown
  5. Bow River Downtown
  6. Banff national park - one day road trip, Banf <-> Banff national park
  7. Mount view, link is here.  Around $75 dollars, mountain views
  8. Cascade Mountain 
  9. Hot spring resort - 2 hours 
  10. Calgary -> Kamloops -> Lorgan lake, motel $150/ day 
  11. Lorgan lake -> Horrison hot springs -> Boat tour 2 hours around Harrison lake, $75 dollars 
  12. Horrison lake -> Vancouver 
Gas cost around $380 dollars 


February 25 2025

Two bedroom new condo in 2022 sold around $190,000, now it is around $250,000 Canadian dollars.


SQL Server: Security for Developers | Build secure applications in SQL server

 Learn how to protect databases and preserve the integrity of an organization's data by configuring the security settings in SQL Server. This course covers how to use built-in options on Microsoft platforms, including Azure AD, to secure database and network infrastructure. Learn about establishing users, assigning roles, and granting privileges. Find out how to prevent SQL Server from malicious injection by addressing vulnerabilities. Discover how to encrypt data at rest and in-transit. See how to build a robust security model for your applications. Additionally, learn how to encrypt connections and secure a network.

Learning objectives

  1. Building secure applications in SQL Server
  2. Configuring authentication in Azure AD
  3. Assigning user roles and privileges
  4. Building custom roles
  5. Creating contained users
  6. Protecting SQL Server from injection
  7. Identifying vulnerabilities
  8. Writing strong procedures
  9. Checking inputs
  10. Using dynamic parameterization
  11. Encrypting network connections
  12. Securing linked servers
  13. Configuring firewalls

Joey D'Antoni | Linkedin learning | Scaling Your SQL Server Application

 Can your applications handle the load? In this one-hour class, you can learn about techniques to scale your SQL Server application as both your data volume and userbase grow. Instructor Joey D'Antoni introduces techniques you can use when designing a new application as well as techniques to fix an existing application—balancing security and performance concerns. Learn how to leverage built-in SQL Server features such as columnstore indexing, read-only routing, and portioning, and design a tenancy model that meets the demands of your application. Plus, find out how to use a caching tier and integrate Microsoft Azure for cloud-based storage that automatically scales as your needs grow.

Learning objectives

  • Designing for high-write and high-read workloads
  • Designing an archiving model
  • Leveraging SQL features such as portioning and compression
  • Building a tenancy model
  • Using Azure design patterns for scaling

Skills covered

Microsoft SQL Server 2019: New Features | Linkedin learning | Adam Wilbert

Introducing Synapse Data Science in Microsoft Fabric

Arshad Ali | Linkedin profile

https://www.linkedin.com/in/arshadalitmmba/ 

Seasoned technical architect with deep experience in architecting and delivering enterprise scale data warehousing, business intelligence, big data and advance analytics solutions for enterprise customers across globe. Engages with strategic customers for digital transformation and business prioritization processes, particularly focused on data platform modernization and data analytics, to enable them to better utilize their data platform assets, and drive new insights and scale from their investment in cloud solutions through a combination of batch or real-time data consumption & processing (Lambda or Kappa architecture), predictive analytics as well as intuitive visualizations that enables users to make smarter, faster decisions.


A technical thought-leader who manages and collaborates with multi-stakeholders ecosystem - customers, engineering, marketing and sales, consulting, partners etc.

Presented in several technical events both internally and externally. Has co-authored a book on big data analytics (Big Data Analytics with Microsoft HDInsight by Sams\Pearson) and has written 200+ technical and performance optimization technique articles on data platform and analytics which have been published on several sites.

SABRE

 Sabre Announces Successful Completion of Previously Announced Private Financing and Settlement of Cash Tender to Strengthen Balance Sheet and Improve Free Cash Flow

  • Completes upsized financing from lenders led by affiliates of Centerbridge Partners, L.P. ("Centerbridge") for $700 million new senior secured credit facility
  • Settles tender offer by purchasing for cash $670 million in principal amount of 9.250% Senior Secured Notes due 2025
  • Transaction refinances significant portion of 2025 maturities and improves free cash flow generation via PIK interest toggle on the new senior secured credit facility

SOUTHLAKE, Texas, June 13, 2023 /PRNewswire/ -- Sabre Corporation (NASDAQ: SABR), a leading software and technology provider that powers the global travel industry, announced today the successful completion of a $700M private financing led by Centerbridge and other high quality institutional investors, and the corresponding early tender settlement by purchasing $670 million in principal amount of the 9.250% Senior Secured Notes due 2025 in a cash tender offer.  The transaction enables the company to strengthen its balance sheet by refinancing and extending a significant portion of its capital structure's 2025 maturities and provides financial flexibility and improved free cash flow via a payment-in-kind (PIK) interest toggle through 2025.

Mike Randolfi, Chief Financial Officer of Sabre, said, "We are pleased to complete this financing that provides Sabre with additional flexibility to meet our financial objectives and continue pursuing our focus on driving innovation, enhancing Sabre's value to our customers and aligning resources toward our growth initiatives."

"We are pleased to be a capital partner to Sabre, helping to strengthen its balance sheet by refinancing a significant portion of its nearest-dated maturity," said Gavin Baiera, Senior Managing Director at Centerbridge."  Simon Brookim, Managing Director at Centerbridge, added, "We are excited about this unique capital partnership in a premier global technology platform in travel."

Perella Weinberg Partners LP acted as financial advisor and Davis Polk & Wardwell LLP and Norton Rose Fulbright LLP acted as legal counsel to Sabre on the transaction. Paul, Weiss, Rifkind, Wharton & Garrison LLP and Allen & Overy LLP acted as legal counsel to Centerbridge.

Getting Started with Extended Events in SQL Server 2008 | Arshad Ali

How to avoid Page Splits in SQL Server

An Overview of Extended Events in SQL Server 2008 | Arshad Ali

Using Extended Events to troubleshoot SQL Server issues

Alibaba

 Alibaba

 is cutting 7% of the workforce in its cloud computing division as the unit gears up for an initial public offering.

The move, confirmed to CNBC by a person familiar with the matter who preferred to remain anonymous because they were not able to speak publicly, will see the Chinese e-commerce giant offer severance packages to those affected. Alibaba has begun informing staff of the layoffs and is also helping them to move to different positions internally if they desire, the same source added.

This comes after it announced plans in March to split the company into six business units each with their own chief executive and board of directors.

Last week, the company announced plans for a full spin-off of its cloud computing unit and said it intends for the division to become an independent publicly listed company. Alibaba aims to complete the spin off within the next 12 months.

Alibaba’s CEO Daniel Zhang has long-seen cloud computing as a key part of the e-commerce giant’s future but it currently accounts for just 9% of the group’s total revenue. And revenue has been slowing significantly over the last few quarters. In fact, revenue fell 2% year-on-year in the first quarter of the year.

Zhang said on the company’s earnings call last week that this was “partially due to our proactive move to adjust our revenue structure and focus on high-quality growth, and also a result of external changes in market environment and customer composition.”

TikTok owner ByteDance began moving its international operations off of Alibaba’s cloud which continues to weigh on the company’s cloud business.

Still, Alibaba has made some headway with its cloud business over the past few years. It is the number one player by market share in China and number two in Asia-Pacific, just behind Amazon, according to Synergy Research Group. However, on a global level, it still trails giants Amazon, Microsoft and Google

三年防疫期过后

 "不堪回首的三年防疫期过后,中国本应以满血复活的形象成为今年最大的惊喜。而现如今,中国央行不得不恳请各方对短暂复苏后再度陷入疲软的经济保持耐心。外国对中国产品的需求不断减少,五月的出口数据又一次下滑。


但中国所面临的问题,并非国际市场的疲软,而是内需的不景气。这不仅仅表现在不断下跌的生产者价格指数上。正如摩根大通总裁戴蒙( Jamie Dimon)在上海所发出的警告那样,政府发布不确定信号,中国人就不会进行投资。下一轮零售业数据是否会有所改善,谁都没有把握。由于中国人购买汽车的数量远远低于预期,政府推出了新的补贴计划。中国人的手机上每隔几分钟就会收到提供贷款的促销信息。只需按一下按钮,就可获得招商银行的259000元五年期贷款。

但统计数据却显示,大量的现金都被放进了储蓄账户,并没有进入经济流通领域。这倒也不足为奇,毕竟社交媒体上对失业的恐惧已经成了压倒性的话题。阿里巴巴现在的做法也加剧了这种担忧:这家名义上的因特网私企宣布将大规模裁员,而来自经济圈的消息称,阿里巴巴裁员是政府的愿望。被裁人员离开位于东部沿海城市的经济中心,重返内地城市,虽然他们的薪资会减少,但却有利于推动当地经济的发展。而大公司则可以转而招聘大学毕业生入职,以遏制足以威胁政权稳定的青少年失业问题。"

评论指出,中国政府以减少基建项目、提高房地产开发公司的贷款门槛等手段,试图恢复对经济领域的管控,这样做必然会导致经济增速的放缓,但减幅如此之大,却令人震惊。

美国 | 5个方面考虑自己的退休储蓄

 在美国,如果想要美美地享受退休生活,通常需要从5个方面考虑自己的退休储蓄:


1. 社会安全福利(Social Security Benifit)

只要你领工资,就必须将税前收入的一定比例交给政府,在缴满一定的期限(40个季度)后,便能在退休后领取相应的福利。


不过别想的太好,这部分的福利金并不高。而且这些年关于社安金即将倒闭的消息时不时传出来,所以想要社安金养老绝对是不够的。


那么社安金到底可以拿多少呢?以下情况虽然不能保证百分百正确,但是基本上符合实际,各位可对号入座!


1)底薪如售货员,饭店服务员等,时薪8到10元,假如平均月收入1400:工作10年的话,退休金是360;工作20年的话,退休金是701;工作35年以上,退休金是892。


2)一般收入如办事员等,月薪2000到3000,假如平均月收入2500:工作10年的话,退休金是643;工作20年的话,退休金是902;工作35年以上,退休金是1245。


3)全职工作中位数收入如小学教师,记者等,年薪四万到五万,假如平均月收入3500:工作10年的话,退休金是765;工作20年的话,退休金是1084;工作35年以上,退休金是1565。


4)高薪工作如职业白领等,年薪6万到10万,假如平均月收入6000:工作10年的话,退休金是993;工作20年的话,退休金是1542;工作35年以上,退休金是2131。


5)顶薪如管理层等,超过11万社保最高限,即平均月收入9166:工作10年的话,退休金是1283;工作20年的话,退休金是2017;工作35年以上,退休金是2605。


2. 部分公司和政府的退休金(Pension Plan),不需要雇员缴费

说到这部分就更是欲哭无泪了。目前绝大部分公司都不再提供Pension Plan,很多公司也在实施老人老办法,新人新办法。当然政府雇员还有此计划,主要适用于公务员。此外,某些工会也提供企业养老金。


3. 401K

由企业主导,雇主和雇员共同出资的企业补充养老保险制度,适用于在公司有提供该福利者。多数公司都提供401K计划,只是计划补偿不同。


4. 个人退休金计划 (分为传统IRA和Roth IRA)

这部分养老金是由个人负责,自愿参加的个人储蓄养老保险制度。


传统IRA:

* 人们可以将一部分钱存入其中,2023年规定每年最多存$6500,这部分钱在满足一定条件下可以用于抵税。

* 拥有延迟缴税功能。账户中的钱可以做一定投资,投资增值部分不用每年缴税,取钱的时候才需要缴税。

* 年满59½岁可以开始领取本金及利息。

* 59½岁前取钱,除了要交所得税外,还要支付10%的提前领取罚款。


Roth IRA:

* 让入Roth IRA的钱是税后的,所以这笔钱不能用来抵税。

* 存入Roth IRA的钱增值部分领取时不需要缴税。

* 如果Roth IRA拥有人已过59½岁,而第一笔存款已超过5年,领取时免税。

* 如果未满59½岁,第一笔存款已满5年,想要领取时,满足以下条件可以不用交10%的罚款:a)用于第一次购买住房,但一生的限额是$10,000;b) 伤残;c)死亡(由受益人领取)。


5. 人寿保险

很多中产阶级及以上的美国人会为自己和家人购置一份附带长期护理险或重疾险的人寿保险。


如果没用上,那就是留给子女的一份宝贵的财富,如果用上了,那么也可以为家庭减轻经济负担,让自己可以安心看病,不至于为了钱愁眉苦脸。


例如这几年市面上最热卖的长期护理险。


在美国,绝大部分65岁以上的老人或多或少都用到了长期护理,有的是请家政来家里打扫、照顾自己,有的则是住进了养老院。不管选择用哪种方式来养老,都是一笔不小的开支!


以加州为例,根绝Genworth的数据:

2023年Homemaker Service(家政服务)的费用大约为每月$6,473;

Home Health Aide(家庭医疗护理服务)的费用大约为每月$6,473;

Adult Day Health Care(老人日间康复中心)的费用大约为每月$1,954;

Assisted Living Facility(辅助型养老社区)的费用大约为每月$5,570;

专业护理养老院合住房,费用大约为每月$10,390;

专业护理养老院单人房,费用大约为每月$12,908;


但如果你拥有一份长期护理险,那么就完全不用担心费用的问题了,它除了可以为你支付所需的护理费,还带有储蓄功能。简单来说就是,钱没花完的可以全部免税传承给子女。

75岁了机场工作

 在凤凰城天港国际机场工作的Maria Rios今年已经75岁了,作为一个食品准备工人,她的时薪仅为14.5美元。虽然她的丈夫已经退休,但他每个月只能获得大约400美元的社会保障福利。所以她不得不每天超额工作维持生计。

Rios说她也很想退休,但她没有退休金,没有退休保险,甚至还在与卵巢癌作斗争。所以只能硬着头皮继续工作。


“我已经75岁了,但为了付账单,我仍然得被迫工作。而且我们公司提供的医疗保险非常昂贵,”里奥斯说,她每个月还要额外支付大约200美元的医疗保险费用。


“人们能够拥有养老金是非常非常重要的,这样当他们年迈的时候就能够体面地退休。人们就不用被迫身处我目前的困境,我都75岁了还得继续工作。”


Rios并不是个例,数百万美国人因为无法承受失业的代价,而不得不一直工作到死。


根据美国劳工统计局的数据,在未来十年,75岁及以上的劳动力人数预计将增加96.5%,75岁及以上的劳动力参与率预计从2020年的8.9%上升到2030年的11.7%。该比率已经从1996年的4.7%稳步持续上升。


诚然有极少数的美国人热爱自己的事业而一直工作不选择退休,但大部分75岁以后仍然选择继续工作的人是被现实所迫,他们没有保险,没有退休金,为了支付自己的账单而不得不工作。

他们之中,很多人是由于巨额债务(房屋、子女的学费等)无法拥有足够的养老储蓄,但另有近一半的美国家庭是因为没有提前合理规划自己的退休生活而使生活陷入困境。


据统计,全美近900万50岁及以上的美国人仍有学生贷款或家长贷款,该人群所欠的金额增长速度比其他任何年龄群体都快。


马萨诸塞州的Jane Switchenko说,她今年已经68了,但还不能退休,因为身上背负着子女上大学的贷款,每个月需要还大约1000美金。“我们勤劳,我们节俭,但我们无法退休。我们有五个孙子,但我们不知道我们能为他们在圣诞节买什么礼物。”


都说美国是老年人的地狱,在美国养老真的这么可怕吗?到底怎样才能在美国体面地过上养老生活呢?


提前规划你的退休储蓄真的很重要!



Create an Extended Events Session

 Applies To: SQL Server 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2014)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

You can create an Extended Events session by using the Query Editor, or you can create a session in Object Explorer. In Object Explorer, Extended Events provides two user interfaces you can use to create, modify, and view event session data — a wizard that guides you through the event session creation process, and a New Session UI that provides more advanced configuration options. You can create Extended Events sessions to diagnose SQL Server tracing, which enables you to resolve issues such as the following:

  • Find your most expensive queries

  • Find root causes of latch contention

  • Find a query that is blocking other queries

  • Troubleshoot excessive CPU usage caused by query recompilation

  • Troubleshoot deadlocks

Learn / SQL / SQL Server / Extended events overview

Monday, June 12, 2023

Run SQL Server Profiler

Here is the article.



CFRA vs Morningstar 2023

 It’s easy for you to get overwhelmed with all the stock investment information available, and knowing where to turn for reliable guidance can take time and effort. Luckily, research tools are available to help, such as CFRA and Morningstar.

CFRA is an excellent tool for investors looking for timely, proven guidance on the financial markets and the driving forces behind them. This tool can help you stay up-to-date on the trends and developments impacting stock performance, giving insight into when to buy, hold, and sell.

Meanwhile, Morningstar is an investment firm that provides a comprehensive research tool that analyzes mutual funds, stocks, and other relevant market data. This tool offers valuable insights into mutual funds and ETFs, making it an excellent resource for investors making informed investment decisions.

In this CFRA and Morningstar review, I’ll walk you through everything about both platforms, so you can feel confident in your investment decisions and stay ahead of the curve.

CFRA is Better for:Morningstar is Better for:
Analyzing mutual funds and ETFsPremium investment services
Providing comprehensive research on stocksPortfolio tools
Offer insights for making informed investment decisionsStock recommendations

To compare CFRA and Morningstar, assessing their distinct features is essential. While both platforms aid in informed decision-making, differences in their tools and offerings can make one more suitable for your needs. Factors like investing style, goals, and objectives can impact your platform preferences. Consider the following features of each platform to make an informed decision: