2020年8月25日 星期二

version or edition consideration when SQL Server migrate or upgrade

version or edition consideration when SQL Server migrate or upgrade


如果SQL Server 2000並採用資料庫備份還原來移轉Migration,步驟如下

1.restore to SQL 2008 R2

2.changet db's compatibility level from 80 to 100

3.take a backup

4.restore the backup on SQL Servre 2022 


如果採用原機升級 Upgrade in-place

Supported version & edition upgrades (SQL Server 2019)

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-version-15?view=sql-server-ver15

Upgrades from Earlier Versions to SQL Server 2019 (15.x)

SQL Server 2019 (15.x) supports upgrade from the following versions of SQL Server:

  • SQL Server 2012 (11.x) SP4 or later
  • SQL Server 2014 (12.x) SP3 or later
  • SQL Server 2016 (13.x) SP2 or later
  • SQL Server 2017 (14.x)


Supported version & edition upgrades (SQL Server 2017)

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2017?view=sql-server-ver15

SQL Server 2017 (14.x) supports upgrade from the following versions of SQL Server:

  • SQL Server 2008 SP4 or later
  • SQL Server 2008 R2 SP3 or later
  • SQL Server 2012 SP2 or later
  • SQL Server 2014 or later
  • SQL Server 2016 or later


Supported version & edition upgrades (SQL Server 2016)

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades?view=sql-server-ver15

SQL Server 2016 supports upgrade from the following versions of SQL Server:

  • SQL Server 2008 SP4 or later
  • SQL Server 2008 R2 SP3 or later
  • SQL Server 2012 (11.x) SP2 or later
  • SQL Server 2014 (12.x) or later





2020年8月22日 星期六

Azure Storage Queue, Service Bus, Event Hub, Event Grid

Azure IoT Hub、Storage Queue、Service Bus、Event Hub、Event Grid


IoT


  1. IoT Hub:IaaS,可在您的 IoT 應用程式與其所管理裝置之間進行高度安全兼可靠的通訊。
    • Collect IoT Message
    • Connect Other Services
      • Queue
      • Service Bus
  2. IoT Central:SaaS,大規模連線、監視並管理您的物聯網 (IoT) 資產。
    • Collect IoT Message
    • Master/Process



Queue


  1. Storage Queue:單一Message size上限64KB
  2. Service Bus:
    • Service Bus queue,單一Message size上限 Standard tier: 256KB,Premier tier: 1MB
    • Service Bus topic,處理message前做filter篩選
  3. Event Hub:處理巨量Message
  4. Event Grid:能夠收集並處理Message

ServicePurposeTypeWhen to use
Event GridReactive programmingEvent distribution (discrete)React to status changes
Event HubsBig data pipelineEvent streaming (series)Telemetry and distributed data streaming
Service BusHigh-value enterprise messagingMessageOrder processing and financial transaction

Storage queues and Service Bus queues - compared and contrasted
https://learn.microsoft.com/en-us/azure/service-bus-messaging/service-bus-azure-and-service-bus-queues-compared-contrasted

Choose between Azure Queue services – Queue Storage, Service Bus Queue, Service Bus Topics
https://ramanisandeep.wordpress.com/2020/06/11/choose-between-azure-queue-services-queue-storage-service-bus-queue-service-bus-topics/

Choose Service Bus Topics if
you need multiple receivers to handle each message

Choose Service Bus queues if
You need an At-Most-Once delivery guarantee.
You need a FIFO guarantee.
You need to group messages into transactions.
You want to receive messages without polling the queue.
You need to provide a role-based access model to the queues.
You need to handle messages larger than 64 KB but less than 256 KB.
Your queue size will not grow larger than 80 GB.
You would like to be able to publish and consume batches of messages.

Queue storage isn’t quite as feature-rich, but if you don’t need any of those features, it can be a simpler choice. In addition, it’s the best solution if your app has any of the following requirements.

Choose Queue storage if
You need an audit trail of all messages that pass through the queue.
You expect the queue to exceed 80 GB in size.
You want to track progress for processing a message inside of the queue.

A queue is a simple, temporary storage location for messages sent between the components of a distributed application. Use a queue to organize messages and gracefully handle unpredictable surges in demand.

Summary
Use Storage queues when you want a simple and easy-to-code queue system. For more advanced needs, use Service Bus queues. If you have multiple destinations for a single message, but need queue-like behavior, use topics.

Azure IoT中樞

Azure IoT Central

Choose between Azure messaging services - Event Grid, Event Hubs, and Service Bus

SQL Server Planning, Pricing and License

  Server-CALs授權模式 1.需購買的量應該是所有終端用戶的電腦 例如:一台Data warehouse主機 與 一台Web報表主機,但公司有50人或電腦會連進Web報表主機開啟報表,則應該每一台用戶端電腦都需要有CALs授權,Data warehouse主機購買Ser...