Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Rocked_Services_Type_A has a deprecated constructor in C:\xampp\htdocs\fabriciolima\wp-content\themes\rocked\widgets\fp-services-type-a.php on line 8

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Rocked_Services_Type_B has a deprecated constructor in C:\xampp\htdocs\fabriciolima\wp-content\themes\rocked\widgets\fp-services-type-b.php on line 8

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Rocked_Facts has a deprecated constructor in C:\xampp\htdocs\fabriciolima\wp-content\themes\rocked\widgets\fp-facts.php on line 3

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Rocked_Projects has a deprecated constructor in C:\xampp\htdocs\fabriciolima\wp-content\themes\rocked\widgets\fp-projects.php on line 3

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Rocked_Clients has a deprecated constructor in C:\xampp\htdocs\fabriciolima\wp-content\themes\rocked\widgets\fp-clients.php on line 3

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Rocked_Testimonials has a deprecated constructor in C:\xampp\htdocs\fabriciolima\wp-content\themes\rocked\widgets\fp-testimonials.php on line 3

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Rocked_Skills has a deprecated constructor in C:\xampp\htdocs\fabriciolima\wp-content\themes\rocked\widgets\fp-skills.php on line 3

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Rocked_Action has a deprecated constructor in C:\xampp\htdocs\fabriciolima\wp-content\themes\rocked\widgets\fp-call-to-action.php on line 3

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Rocked_Video_Widget has a deprecated constructor in C:\xampp\htdocs\fabriciolima\wp-content\themes\rocked\widgets\video-widget.php on line 3

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Rocked_Employees has a deprecated constructor in C:\xampp\htdocs\fabriciolima\wp-content\themes\rocked\widgets\fp-employees.php on line 3

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Rocked_Latest_News has a deprecated constructor in C:\xampp\htdocs\fabriciolima\wp-content\themes\rocked\widgets\fp-latest-news.php on line 3

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Rocked_Contact_Info has a deprecated constructor in C:\xampp\htdocs\fabriciolima\wp-content\themes\rocked\widgets\contact-info.php on line 3

Deprecated: Unparenthesized `a ? b : c ? d : e` is deprecated. Use either `(a ? b : c) ? d : e` or `a ? b : (c ? d : e)` in C:\xampp\htdocs\fabriciolima\wp-content\plugins\types\vendor\toolset\toolset-common\lib\enlimbo.forms.class.php on line 930

Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in C:\xampp\htdocs\fabriciolima\wp-content\plugins\types\vendor\toolset\types\embedded\includes\wpml.php on line 644

Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in C:\xampp\htdocs\fabriciolima\wp-content\plugins\types\vendor\toolset\types\embedded\includes\wpml.php on line 661

Deprecated: implode(): Passing glue string after array is deprecated. Swap the parameters in C:\xampp\htdocs\fabriciolima\wp-content\plugins\crayon-syntax-highlighter\util\crayon_util.class.php on line 73
Managed Instance (#21) – Problema do Getdate() na sua localidade resolvido! – Fabricio Lima | Consultoria e Treinamento SQL Server
Loading…

Managed Instance (#21) – Problema do Getdate() na sua localidade resolvido!

Fala Pessoal,

Estamos de volta com um post rápido sobre Managed Instance.

No post abaixo de Novembro de 2018 mostrei que a tão usada função GETDATE() ainda não retornava a hora da minha localidade no managed instance:

https://www.fabriciolima.net/blog/2018/11/23/managed-instance-7-a-funcao-getdate-ja-retorna-a-data-da-minha-localidade/

Mas deixei essa notícia no post:

“Mas, Porém, Entretanto, Contudo, Todavia…. Na palestra do Borko Novakovic (líder do projeto MI) no Pass Summit 2018, ele disse que está vindo em breve a possibilidade de utilizar nosso Time Zone local na criação de um MI.”

Esse problema foi resolvido!

A microsoft liberou o Public Preview da opção de escolher o Time Zone no momento de criação do Managed Instance:

https://azure.microsoft.com/en-us/updates/managed-instance-time-zone-preview/

Agora no momento de criação do Managed Instance podemos escolher o Time Zone de Brasilia conforme abaixo:

 

Pronto! Último problema que tinha para migrar resolvido Fabrício (exceto grana rsrs).

É isso aí pessoal. Já que o objetivo do Managed Instance é facilitar as migrações das aplicações para um serviço no Azure sem reescrita de código, agora isso está mais fácil de ser alcançado.

Já administro um SQL de produção de um cliente que está no Managed Instance. TOP da balada!

Bora migrar!!!

Um dos benefícios do reconhecimento do programa MVP da Microsoft é ter um acesso direto ao time de produtos. Falo constantemente com os responsáveis pelo produto Managed Instance e em Dezembro de 2018 eles já tinham me liberado um acesso a essa feature do Time Zone enquanto ela ainda estava em fase de testes privados.

=)

 

Nice!

Até o próximo post pessoal.

Seguem os posts anteriores sobre Managed Instance:

Gostou dessa Dica?

Curta, comente, compartilhe…

Curta nossa página no Facebook , LinkedInInstagram para receber Dicas de Leituras, Vídeos e Eventos sobre SQL Server.

Aproveite os cursos do #TeamFabricioLima para se diferenciar no mercado:

 

Abraços,

Fabrício Lima

Microsoft Data Platform MVP

Consultor e Instrutor SQL Server

Trabalha com SQL Server desde 2006

2 thoughts on “Managed Instance (#21) – Problema do Getdate() na sua localidade resolvido!

Deixe uma resposta

%d blogueiros gostam disto: