Blog Archives

SQL Saturday 689 – Prague – Scripts and Slides

Hi Everyone,

First of all, I want to thank everyone at my session at SQL Saturday 689 in Prague this last weekend. It was a tremendous pleasure for me to present and share a bit of what I know with all of you.

I also want to say THANK YOU to the Czech BI & SQL Pass User Group for putting this amazing event to the community, I know how much work and effort has to be done to have such a great event. You treated not only myself but all the speakers so well, so thanks again for having me! You guys are great!

I also want to say THANK YOU to the Sponsors, with all your support the event was just awesome!

As I promised during my presentation, I would write this post to share the link to where you can download most of the resources used by myself during the presentation.

https://github.com/marcosfreccia/sql-saturday-689-prague

I would like to also ask you a bit of your time to fill up the session evaluation. This means a lot to all the speakers. Doing that, it helps all of us speakers to improve our presentation, subjects, demos and etc.. Please, please, please!! Do it! The link is below.

https://goo.gl/6ZTfH6

Thanks again and see you in 2018!

Regards,
Marcos Freccia
Data Platform MVP

Advertisements

Adding SSISDB to AG for SQL Server 2016

Hi Everyone,

I’ve setup a new SQL Server 2016 AG Environment for Developers where they will use it for deploying and testing code, which means that they also want to SQL Server Integration Services for deploying and executing SSIS Packages. From SQL Server 2012 and onwards we have the new deployment model for SSIS and also the addition of SSISDB.

One of the features highly requested was the ability to add SSISDB to AG, which was also added, but before SQL Server 2016 the failover of the SSISDB database has to be done manually, on which you end up having more work to do. In SQL Server 2016 it was added the possibility for automatic failover of SSISDB. Read the rest of this entry

SQL Server Discovery Day em Joinville

Discovery DayOlá pessoal,

No próximo sábado (18/06) a partir das 08:00 da manhã o Rodrigo Dornel e eu estaremos conduzindo o SQL Server Discovery Day na Univille em Joinville.

Para quem não conhece o SQL Server Discovery Day será um evento focado apenas nas novidades do SQL Server 2016 e também onde levaremos um problema a ser resolvido pelos participantes na qual todos deverão apresentar a sua solução criada. Então é um dia com bastante mão na massa e aprender muito SQL Server. As vagas são beemmmm limitadas (cerca de 20 a 30) então se você tem interesse em participar é só verificar os passos abaixos. Read the rest of this entry

Apresentação Data Driven SQL Server 2016

Olá pessoal,

Obrigado a todos presentes na minha palestra sobre Nuvem Hibrida com SQL Server 2016. Essa postagem é apenas para compartilhar o material utilizado na apresentação de hoje. Segue também uma foto da apresentação.

Link da apresentação: https://onedrive.live.com/redir?resid=8C86677ACC072D7F!14234&authkey=!AKjpdVIjHeSbOYs&ithint=file%2cpdf

Qualquer dúvida é só entrarem em contato comigo. Quem estava na apresentação deixe um comentário abaixo.

Abraços,
Marcos Freccia
Data Platform MVP

Mudanças na agenda do SQL Saturday #488

Olá pessoal,

O SQL Saturday #488 já está logo aí, é no próximo sábado e garanto que todos estão anciosos para mais esse grande evento da comunidade técnica. As razões para não perder um evento como esse são inumeras e não irei repeti-las aqui. Acontece que tivemos uma pequena mudança na agenda onde um dos palestrantes não poderá comparecer abrindo uma vaga para que então meu amigo Rodrigo Dornel e eu, possamos realizar uma palestra juntos. Read the rest of this entry

How to enable Strecth Tables in SQL 2016

Howdy!

SQL Server 2016 CTP 2.0 has been launched today, so I want to take some time to show you how to enable the new feature called Stretch Tables. Stretch Tables will allow you to save your table in a Microsoft Azure SQL Database without any application code change to retrieve the information stored in the cloud. Below I will describe what you need to do to get Stretch Tables working. Read the rest of this entry