Tuesday, July 20, 2021

SQL server express 2019: First installation | Comparison among versions

 

Microsoft SQL Server Express: Version Comparison Matrix and Free Downloads

Microsoft SQL Server is an enterprise quality database management system that's usually hosted by a server and can scale across multiple servers and locations.

For local PC, small databases, and less critical situations, Microsoft offers a limited version of SQL Server called SQL Server Express. SQL Server Express can be downloaded for free and installed on your local PC. This is helpful for:

  • Deploying desktop Windows solutions that use SQL Server databases to users who don't own SQL Server
  • Deploying lightweight web applications that use SQL Server databases
  • Developers wanting to create and test applications with a SQL Server database on their own, rather than a database hosted on a server

There are many editions of the full version of SQL Server with Enterprise, Standard and Web being the most common. Here are some of the major differences of the 2017 version compared to the 2016 and 2017 Express editions:

EnterpriseStandardWeb2019 Express2017 Express2016 Express
Maximum Database Size524 PB524 PB524 PB10 GB10 GB10 GB
Compute CapacityOS Max4 sockets or 24 cores4 sockets or 16 cores1 socket or 4 cores1 socket or 4 cores1 socket or 4 cores
Maximum MemoryOS Max128 GB64 GB1.4 GB1.4 GB1.4 GB
Database Mirroring
Smart Backups, Encrypted Backups
SQL Profiler

The most critical issue is the maximum database size. The other differences are related to performance and maintenance.

For more details, visit Microsoft's Supported Features of SQL Server 2019.

Note: SQL Server Express cannot be installed on a compressed drive. It only supports standard, non-compressed drives.


Monday, July 19, 2021

USD <-> CAD | My 20 minutes study | Crude oil price | Market sentimental | Covid related stock crashes

 - Monday, July 19, 2021

Facts to review:
  1.  The Canadian dollar lost over 1.5% of its value against the U.S. dollar in overnight trading
  2.  A nearly 3% slide in West Texas Intermediate oil prices
  3. The Organization of the Petroleum Exporting Countries and Russia reached an agreement with the United Arab Emirates. The UAE’s base production level was increased along with other cartel members, and production is being increased by 400,000 barrels per day, beginning in August and continuing until the end of 2022.

USD/CAD - Canadian Dollar Falls off a Cliff

 The Canadian dollar lost over 1.5% of its value against the U.S. dollar in overnight trading. A litany of woes transpired to pummel the currency, with plunging crude prices leading the way. A nearly 3% slide in West Texas Intermediate oil prices, combined with new COVID-19 delta variant cases in Europe and Australia, and heightened tensions between China and the U.S., triggered a stampede into safe-haven U.S. dollars.


The Organization of the Petroleum Exporting Countries and Russia reached an agreement with the United Arab Emirates. The UAE’s base production level was increased along with other cartel members, and production is being increased by 400,000 barrels per day, beginning in August and continuing until the end of 2022.

The drop in oil prices exacerbated negative Canadian dollar sentiment following last week’s more dovish than expected Bank of Canada policy meeting. Traders were unhappy with BoC downgrading 2021 economic growth to 6.0% from 6.5% in April, and took it out on the currency.

USD/CAD technicals are bullish while trading above $1.2405, supported by the break above the downtrend line from last November. The break above $1.2650 overnight sets the stage for a test of $1.3000.

Widespread safe-haven demand for U.S. dollars made the Canadian dollar the worst-performing currency compared to the U.S. dollar. The Australian and New Zealand dollars were not far behind, losing 1.0% and 0.77% respectively.

USD/JPY dropped from 110.09 to 109.62 due to U.S. 10-year Treasury yields falling to 1.248% from 1.30%, and safe-haven demand for yen.

The drop in oil prices exacerbated negative Canadian dollar sentiment following last week’s more dovish than expected Bank of Canada policy meeting. Traders were unhappy with BoC downgrading 2021 economic growth to 6.0% from 6.5% in April, and took it out on the currency.

USD/CAD technicals are bullish while trading above $1.2405, supported by the break above the downtrend line from last November. The break above $1.2650 overnight sets the stage for a test of $1.3000.

Widespread safe-haven demand for U.S. dollars made the Canadian dollar the worst-performing currency compared to the U.S. dollar. The Australian and New Zealand dollars were not far behind, losing 1.0% and 0.77% respectively.

USD/JPY dropped from 110.09 to 109.62 due to U.S. 10-year Treasury yields falling to 1.248% from 1.30%, and safe-haven demand for yen.

EURUSD is trading at key support after dropping from 1.1813 to 1.1766 overnight. Risk-aversion pressures are exacerbated by new COVID-19 restrictions in France, and Germany, and due to economic growth concerns from flooding in many areas. Traders are also worried about the European Central Bank meeting on Thursday, especially when recent Consumer Price Index reports highlighted the divergent inflation rates between the U.S. and Eurozone.

GBPUSD fell to $1.3702 from $1.3773 as slowing U.K. growth fears exacerbated the risk-aversion fueled selloff. However, GBP/USD as strong support in the $1.36750 zone.

AUD/USD underperformed as delta-variant coronavirus outbreaks, soft commodity prices, and last week’s dovish Reserve Bank of Australia policy meeting weigh on prices. NZD/USD traded lower but outperformed AUD/USD.

There are no economic reports of note today.


Rahim Madhavji is the President of KnightsbridgeFX.com, a Canadian currency exchange that provides better rates than the banks to Canadians

股市狂泄 原油暴跌 加币兑人民币跌破近3个月新低

 Delta变种再次引发全球风暴!

 

19日,受Delta变种感染病例激增引发的市场恐慌情绪,全球市场周一集体重挫,股市和原油价格全部暴跌,加币更是跌破近3个月新低,兑人民币竟跌破5.1!


猝不及防,今天美国三大股全线低开,道指跌超700点,纳指跌1.5%,标普500指数跌2%。

 

标普500指数和纳指录得5月中以来最大单日百分比跌幅。

 

道琼斯指数创近九个月来最差单日表现,也是今年以来的最大跌幅。


要知道,美国从开始爆发疫情至今已经过了18个月,美股市场在短暂地暴跌后触底反弹,之后就一直在屡创新高,对于所有坏消息都不为所动。结果今天突然大跌,一直到收盘都未有转机。


道指跌725点,见2.1%跌幅;标普500跌1.6%;纳斯达克跌1.1%。


投资公司 Oanda 的策略师EdwardMoya)表示:“Delta变种引发避险情绪,加剧了人们对全球经济的担忧。”

 

美国之外,欧洲疫情也因Delta沦陷,恐慌情绪同样笼罩欧洲故事。今日欧股全线低开后跌幅扩大,意大利MIB指数跌超3%,德国DAX指数、英国富时100指数、法国CAC40指数均跌逾2%。


与股同跌的还有原油。

 

就在欧佩克宣布每天将增200万桶原油后,今日原油价格暴跌至每桶66美元,跌幅近8%。


原油一跳水,加币更难“幸存”。

 

今日兑人民币价格竟一路狂跌至5.08新低!兑美元更是跌至5个月以来的最低点。


丰业银行分析师Shaun Osborne表示,加币的暴跌与避险情绪的加深和大宗商品价格的疲软有关。

 

Delta变种给经济复苏带来的巨大不确定性,原油增产加价格下跌,引发人们对需求过程的担忧。


与此同时,美联储有可能在下周宣布加息,更使投资者减少了对加拿大的看涨押注。


由于美联储采取更激进的政策行动,加元会保持下跌,直到2022年。”经济学家在一份报告中写到。


对于需要兑换人民币给国内汇款的华人来说,加币狂跌等于自己资产缩水,能换到的钱更少了。


不过,对于中国留学生以及需要人民币换加币在加拿大买房的新移民来说,加币跳水倒是一个换汇的好时期,有了更充裕的资金,加拿大的房市或将得到一波刺激,房价只怕还得涨。

 

加拿大经济能复苏吗?

 

虽然加币唱衰,股市下跌,不过,经济学家们并没有太过悲观。

 

总部位于多伦多的总部位于多伦多的Baskin金融公司首席投资官BarrySchwartz表示,周一的抛售可能是经济复苏道路上的暂时现象。他指出,在周一的抛售之前,多伦多证券交易所今年上涨了近20%。

 

 “经济正在反弹,但不会直线上升。即使有Delta,我们依然需要比一年前更有信心。”


此外,零售业受解封的刺激,近日也开始出现反弹情况。一些餐厅大排长龙,更多的加拿大民众开始花钱外出用餐、购物、看电影等,弥补疫情期间居家避疫的缺憾。

 

而据加拿大统计局,由于全国范围的逐步解封,6月份加拿大经济增加了23.07万个工作岗位。兼职职位增加了263,900个,基本恢复到疫情前的水平。


6月份的结果是,加拿大全国约有34万个就业岗位,比2020年2月疫情前的就业水平低2%。考虑到人口增长因素,加拿大统计局认为就业岗位缺口可能接近54万。


此外,加拿大咨询公司RSM周一的报告显示,加拿大制造业和铁路货运目前也优于疫情前水平,或将带领加拿大经济走出衰退。

 

尽管如此,疫情依然是潜在的巨大风险。目前,先于加拿大解封的美国和英国惨遭Delta攻陷,全球新增确诊已经连续4周上升。WHO负责人谭德塞指出,Delta 变种现在在超过 111 个国家/地区出现,世界正进入“第三轮疫情的早期阶段”。


历时一年多的教训已经告诉了我们,在这场病毒浩劫中,没有谁可以完全独善其身。加拿大也是如此。全球经济以及加拿大经济接下来会如何?依然有待观望。



Crude oil price: OPEC, allies raise limits for 5 countries to end oil dispute

Agreement will boost production by 2 million barrels per day by the end of 2021

OPEC and allied nations agreed Sunday to raise the production limits imposed on five countries next year and boost their production by two million barrels per day by the end of this year, ending a dispute that roiled oil markets.

The disagreement, sparked by a demand by the United Arab Emirates to increase its own production, temporarily upended an earlier meeting of the cartel. In a statement Sunday, the cartel announced that Iraq, Kuwait, Russia, Saudi Arabia and the UAE would see their limits rise.

"What bonds us together is way much beyond what you may imagine," Saudi Energy Minister Prince Abdulaziz bin Salman said. "We differ here and there but we bond."

Prince Abdulaziz declined to elaborate on how they came to that consensus, saying it would see the cartel "lose our advantage of being mysterious and clever." But he clearly bristled at earlier reports on the dispute between Saudi Arabia, long the heavyweight of the Vienna-based cartel, and the UAE.

Prince Abdulaziz deferred at the beginning of a news conference afterward to UAE Energy Minister Suhail al-Mazrouei  in a sign of respect.

"The UAE is committed to this group and will always work with it and within this group to do our best to achieve the market balance and help everyone," al-Mazrouei said. He praised the deal as a "full agreement" among all the parties.

 Outside of OPEC, however, tensions still remain between the neighboring nations. The UAE largely has withdrawn from the Saudi-led war in Yemen, while also diplomatically recognizing Israel. Saudi Arabia also has opened its doors to Qatar again after a yearslong boycott, though relations remain icy between Abu Dhabi and Doha. Saudi Arabia also has aggressively sought international business headquarters — something that could affect the UAE's business hub Dubai.

Abu Dhabi's powerful Crown Prince Mohammed bin Zayed, the country's de facto ruler, and Saudi Crown Prince Mohammed bin Salman have been close though over the years. The two leaders likely will meet Monday in Saudi Arabia.

New production limits

Under the new production limits, the UAE would be able to produce up to 3.5 million barrels of crude oil a day beginning in May 2022. That's below the 3.8 million barrels a day it reportedly sought. Saudi Arabia's limit of 11 million barrels a day would rise to 11.5 million, as would Russia's. Iraq and Kuwait saw smaller increases.

In its statement, OPEC acknowledged oil prices continued to improve.

"Economic recovery continued in most parts of the world with the help of accelerating vaccination programs," the cartel said.

Prince Abdulaziz also mentioned OPEC members Algeria and Nigeria had raised concerns about their production limits as well.

Oil prices collapsed amid the coronavirus pandemic as demand for jet fuel and gasoline dropped amid lockdowns across the globe, briefly seeing oil futures trade in the negatives. Demand since has rebounded as vaccines, while still distributed unequally across the globe, reach arms in major world economies.

Benchmark Brent crude oil traded around $73 a barrel Friday.

Once muscular enough to grind the U.S. to a halt with its 1970s oil embargo, OPEC needed non-members like Russia to push through a production cut in 2016 after prices crashed below $30 a barrel amid rising American production. That agreement in 2016 gave birth to the so-called OPEC+, which joined the cartel in cutting production to help stimulate prices.

OPEC+ agreed in 2020 to cut a record 10 million barrels of crude a day from the market to boost prices. It's slowly added some 4.2 million barrels back over time.

Beginning this August, the cartel said it separately will increase its production by 400,000 barrels a day each month through December — a total of 2 million barrels. The cartel then will assess plans on whether to phase out its current 5.8 million barrel of oil production cut by the end of 2022 as planned by the initial agreement.

OPEC member nations include Algeria, Angola, Congo, Equatorial Guinea, Gabon, Iran, Iraq, Kuwait, Libya, Nigeria, Saudi Arabia, the UAE and Venezuela. Members of the so-called OPEC+ include Azerbaijan, Bahrain, Brunei, Kazakhstan, Malaysia, Mexico, Oman, Russia, Sudan and South Sudan.

Prince Abdulaziz, in praising Sunday's agreement, offered a cheery assessment of the future despite the recent turmoil, suggesting at one point the enlarged group might last beyond the expiration of the cuts next year.

"OPEC+ is here to stay," the prince proclaimed.

Stock markets fall, oil prices plummet as COVID-19 fears rise again

 July 19, 2021


OPEC deal to pump 2 million more barrels a day pushed down price of crude

The Toronto Stock Exchange had its worst day in months on Monday as rising COVID-19 infections around the world gave investors a sobering reminder that the pandemic is still far from over.

The S&P/TSX composite index lost more than 350 points, or almost two per cent, to 19,655 nearing the end of the trading day.

Less than a month ago, Canada's benchmark stock index was hitting all-time highs as optimism over the looming end of COVID-19 had investors pouring money into stocks poised to benefit from the reopening of the global economy. Even as recently as last week, the TSX was nearly 1,000 points higher than it is right now.

But the pandemic numbers have become a lot gloomier since then, as the delta variant has caused cases to rise again in the U.S., Europe and elsewhere.

"Risk aversion is firmly in place as the delta variant spread is triggering a flight to safety as global economic concerns intensify," said Edward Moya, a strategist with the investment firm Oanda.

The price of oil cratered to $66 a barrel, losing almost eight per cent, after the oil cartel known as OPEC announced over the weekend it would soon pump two million more barrels of oil every day. Oil companies make up a big chunk of the TSX, so the sell-off in those shares made a bad day even worse for the index.

"There was a general market sell-off related to renewed worries about COVID and delta," said Rory Johnston, managing director with the investment firm Price Street.

"Oil is a very classic risk asset, so it's going to ease off a bit," he said in an interview.

The sell-off was even more pronounced in the U.S., where the Dow Jones Industrial Average was at one point down by almost 1,000 points, or just shy of three per cent.

Randy Ollenberger, an analyst with Bank of Montreal, said the sell-off makes sense. 

"There's a lot of nervousness with what's going on with the variants," he said in an interview. "We are not completely out of the woods yet, so we are going to have these days."

Sectors that stood to gain the most from getting back to normal — like travel, tourism, energy and commodities — were hit hardest.

"Travel and hotel stocks are getting crushed today as concerns grow that crude demand outlook might have overly priced in a normal summer abroad," Moya said. "Jet fuel demand will struggle as international travel is not happening anytime soon."

Others weren't so gloomy.

Barry Schwartz, chief investment officer with the Toronto-based Baskin Financial, said in an interview that Monday's sell-off is likely a temporary blip on the broader path toward economic recovery. He notes that prior to Monday's sell-off, the TSX was up by almost 20 per cent this year. 

"Things got ahead of themselves," he said. "The economy is rebounding, [but] it's not going to be in a straight line."

He blamed most of the sell-off on automated trading algorithms programmed to follow momentum — and end up feeding on themselves.

"Even with delta, you have to be much more positive on the world than where we were a year ago."