• Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Special Offers
Business Intelligence Info
  • Business Intelligence
    • BI News and Info
    • Big Data
    • Mobile and Cloud
    • Self-Service BI
  • CRM
    • CRM News and Info
    • InfusionSoft
    • Microsoft Dynamics CRM
    • NetSuite
    • OnContact
    • Salesforce
    • Workbooks
  • Data Mining
    • Pentaho
    • Sisense
    • Tableau
    • TIBCO Spotfire
  • Data Warehousing
    • DWH News and Info
    • IBM DB2
    • Microsoft SQL Server
    • Oracle
    • Teradata
  • Predictive Analytics
    • FICO
    • KNIME
    • Mathematica
    • Matlab
    • Minitab
    • RapidMiner
    • Revolution
    • SAP
    • SAS/SPSS
  • Humor

Remover Horário de Verão no Brasil em 2019 [Remove Daylight Saving Time in Brazil in 2019]

July 20, 2019   Microsoft Dynamics CRM

Olá, pessoal,

Através do Decreto Presidencial número 9772 de 25/04/2019 o Horário de Verão no Brasil em 2019 foi encerrado (http://www.planalto.gov.br/ccivil_03/_ato2019-2022/2019/decreto/D9772.htm). Desta forma, se faz necessário atualizar as configurações dos bancos de dados das organizações Dynamics CRM/365 para ignorar o Horário de Verão previamente estabelecido. Elaborei este script para ser executado nos ambientes On Premises a partir da versão 2011. O script gerará uma cópia da tabela TimezoneRuleBase, caso ha alguma mudança no Horário de Verão futuramente. Na primeira linha ajustar o nome do banco de dados da Organização a atualizar.

IMPORTANTE: (1) Este script trata somente da atualização do banco de dados do Dynamics (server) e não inibe a necessidade de updates do Windows (server / client).

IMPORTANTE: (2) Para os ambientes Online a Microsoft aplicará o ajuste em todas as organizações automaticamente. 

USE [nome_da_organizacao_MSCRM] – alterar para o banco de dados da organização
GO

BEGIN TRY

BEGIN TRANSACTION

IF (NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = ‘TimezoneRuleBase_Backup’))
BEGIN
SELECT * INTO TimezoneRuleBase_Backup FROM TimezoneRuleBase
END

UPDATE TimeZoneRuleBase
SET
StandardBias = 0,
StandardYear = 0,
StandardMonth = 0,
StandardDay = 0,
StandardDayOfWeek = 0,
StandardHour = 0,
StandardMinute = 0,
StandardSecond = 0,
DaylightBias = -60,
DaylightYear = 0,
DaylightMonth = 0,
DaylightDay = 0,
DaylightDayOfWeek = 0,
DaylightHour = 0,
DaylightMinute = 0,
DaylightSecond = 0
WHERE TimeZoneDefinitionId in (SELECT TimeZoneDefinitionId FROM TimeZoneDefinitionBase WHERE TimeZoneCode IN (65, 58))
AND EffectiveDateTime = ‘2019-01-01′

COMMIT TRANSACTION

END TRY

BEGIN CATCH

ROLLBACK TRANSACTION
THROW

END CATCH

Walter Carlin – Sr. PFE – Dynamics 365 – Microsoft

Let’s block ads! (Why?)

Dynamics 365 Customer Engagement in the Field

2019, Brasil, Brazil, Daylight, Horário, remove, Remover, Saving, Time, Verão
  • Recent Posts

    • Facebook’s new computer vision model achieves state-of-the-art performance by learning from random images
    • Now make soup!
    • Attach2Dynamics Or SharePoint Security Sync – Choose your smart app for effective document management in Dynamics 365 CRM/Power Apps.
    • 5 jobs that you should apply for this week (before it’s too late)
    • SQL Server authentication methods, logins, and database users
  • Categories

  • Archives

    • March 2021
    • February 2021
    • January 2021
    • December 2020
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020
    • May 2020
    • April 2020
    • March 2020
    • February 2020
    • January 2020
    • December 2019
    • November 2019
    • October 2019
    • September 2019
    • August 2019
    • July 2019
    • June 2019
    • May 2019
    • April 2019
    • March 2019
    • February 2019
    • January 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
© 2021 Business Intelligence Info
Power BI Training | G Com Solutions Limited