Blog Archives

The most read posts of July – 2017

PS: Portuguese version below

Hi Everyone,

In case you are wondering the most read blog posts of July – 2017, here they go. Also, if you have never read them, you may do so now Smile.

1) Transaction log cheio? E agora? – 371 views – Posted on 13.06.2011

2) Configurando Linked Server de SQL Server para Oracle – 275 Views – Posted on 15.06.2012 Read the rest of this entry

Advertisements

Azure Meetup Berlin – Slide Deck

Hi Everyone,

First of all, thanks to everyone who attended yesterday’s Azure Meetup Berlin in the Digital Eatery. We had around 25 people who stayed until the end of the event!

In my opinion the talks were really good and personally I hope you all of you enjoyed my Power BI talk. As promised below is the slide deck used in my presentation and also some photos taken during the presentations. Read the rest of this entry

Azure Meetup Berlin – I will be speaking

Hi Guys,

It’s been a long time that I don’t show up here, but I just wanted to let everyone know that tomorrow (22.07.2017) starting at 06:30PM I will be speaking at the Azure Meetup Berlin. At this meetup we will have two topics and one of them will be presented by me, about a subject that I really enjoy talking as you can see below.

Talk: Azure and Power BI – Why Power BI is the right tool for you?

In this session, I will explore a few features of Power BI that can make your adoption easier. For example, analyzing data from one or multiple sources? How to efficiently share your dashboards? Free or Paid Power BI? These are common questions often asked and he hopes to have them all answered by the end of the presentation.

Meetup link: https://www.meetup.com/Berlin-Microsoft-Azure-Meetup/events/242462983/

We will also have another topic regarding Azure Containers, which sounds a really interesting talk.

The event will be hosted in the Digital Eatery at Unter den Linder 17 in Berlin! In case you are reading this post and lives or it is in Berlin tomorrow(22.07) make sure to RSVP and join us!

Regards,
Marcos Freccia

An error occurred while setting up a binding for the column

Hello Guys!

I just wanted to do this quick blog post to give you a tip about a recent problem that I had in a SSIS Project. My scenario is the following.

Source Database Server: PostgreSQL
Target Database Server: SQL Server 2016

As you can see, I need to extract data from this PostgreSQL database and import in SQL Server. So far everything is working, but today I got this error of in one particular table: [OLE DB Destination [25]] Error: An error occurred while setting up a binding for the “MyColumnName” column. The binding status was “DT_NTEXT”. The data flow column type is “DBBINDSTATUS_UNSUPPORTEDCONVERSION”. The conversion from the OLE DB type of “DBTYPE_IUNKNOWN” to the destination column type of “DBTYPE_WVARCHAR” might not be supported by this provider. Read the rest of this entry

How to connect Python and SQL Server

Hi everyone!!

Lately I have been studying a bit of Python that I intend to use at work for some projects and also for learning a new language. I would recommend for you to also learn it, because as you know Python is coming to SQL Server 2017. The thing is that with Python you can use in your Machine Learning models, build Websites using some other frameworks such as: Django or Flask and even automate trivial tasks of your daily basis.

However, something that I know from the top of my head now is: Python was not designed in the first hand to deal with Microsoft SQL Server as a backend database. You don’t find lot’s of examples, the documentation sometimes is a bit misleading and errors and more errors that you cannot even imagine. If you search about Python + MySQL, Python + PostgreSQL, you will find lots of examples out there. I am not saying this is bad or anything, but it is just the way it is. Read the rest of this entry

The most read posts of June – 2017

Hi guys,

I have decided that I will continue to do this kind of blog post. So you don’t need any other introduction about the subject. So, let me list the top 5 posts of June.

1)  Transaction log cheio? E agora? – 327 views – Posted on 13.06.2011

2) Como visualizar o conteudo de procedures criptografadas –  182 views – Posted on 11.03.2015

3) Configurando Linked Server de SQL Server para Oracle – 175 views – Posted on 15.06.2012

4) SQL Server no Linux – os primeiros passos – 115 views – Posted on 02.01.2017

2) Adding SSISDB to AG for SQL Server 2016 – 97 views – Posted on 28.04.2017

You see it, that’s not a looot of reads, but I’ll try to improve my writing skills and share more with you, because I have been doing some pretty cool stuff at work!

I hope you like this type of post!

Olá pessoal,

Decidi que vou continuar com esse tipo de postagem. Bom, acredito que não preciso fazer mais nenhuma introdução sobre esse assunto, então segue os 5 posts mais acessados do meu blog.

1)  Transaction log cheio? E agora? – 327 views – Posted on 13.06.2011

2) Como visualizar o conteudo de procedures criptografadas –  182 views – Posted on 11.03.2015

3) Configurando Linked Server de SQL Server para Oracle – 175 views – Posted on 15.06.2012

4) SQL Server no Linux – os primeiros passos – 115 views – Posted on 02.01.2017

2) Adding SSISDB to AG for SQL Server 2016 – 97 views – Posted on 28.04.2017

Para falar bem a verdade, o numero de visualizações é bem baixo até, acho que preciso fazer mais propaganda Open-mouthed smile. Está acontecendo bastante coisa legal no trabalho e vou tentar escrever mais conteúdos para todos.

Se vocês gostaram desse tipo de post, deixa um comentário, já é um bom incentivo.

Regards,
Marcos Freccia
Data Platform MVP

Berlin Azure Global Bootcamp 2017 – Scripts & Slides

Hi Guys,

Last saturday (24.03) I had the pleasure of doing my first talk outside Brazil and my first one in Berlin where I could talk a bit of Azure SQL Database in the Azure Global Bootcamp that happened at Microsoft Berlin. First of all, I would like to thank Anton Staykov and Tyrone Guiamo for inviting me for talking at the event, it was really cool. The talk was very interesting and I’ve got some very good questions. Something it is also worth to mention is that slowly companies in here are looking more and more for Microsoft Azure and specifically for Azure SQL Database. Read the rest of this entry

Codificando Night Week – Estarei Palestrando

 

 

 

 

 

 

 

Ola pessoal,

Na proxima segunda-feira dia 13/03 inicia mais um Codificando Night Week, onde teremos 5 dias de muito conteudo tecnico. Neste evento teremos SQL Server, Asp.Net, Microsoft Azure, Infraestrutura, Desenvolvimento Mobile e muito mais.

Terei o prazer de palestrar falando sobre Azure SQL Database e como migrar sua base de dados. O foco da minha apresentacao sera mostrar o Azure SQL DB como alternativa rapida a adocao do SQL Server na sua empresa e quais os pontos de atenção na hora de migrar o banco de dados. Vamos bater um papo sobre esses assuntos e espero contar com a presenca de todos vocês.

Para os que ficaram interessados em assistir segue abaixo maiores detalhes sobre a minha participação em especifico. E claro que no próprio site voce podera ficar interado sobre os demais assuntos que serão abordados durante a semana.

Data: 13/03/2017 19:00 as 20:00

Assunto: Migrando sua base de dados local para o Azure SQL Database

Palestrante: Marcos Freccia

Para realizarem as inscrições, vocês podem acessar diretamente o site do evento que segue logo abaixo.

http://codificandoweek.azurewebsites.net/

UPDATE: Gostaria de agradecer a presenca de todos voces na apresentacao de ontem. Segue abaixo o PPT utilizado e tambem toda a apresentacao esta disponivel no youtube.


 

Espero vocês na minha sessão.

Abraços,

Marcos Freccia

Agora tenho uma página no Facebook

Olá pessoal,

Recentemente criei uma página deste meu blog no Facebook para compartilhar assuntos relacionados a banco de dados SQL Server e também BI já que ultimamente tenho entrado um pouco nesse mundo.

Lá eu divulgo, postagens não apenas minhas, mas conteúdos que eu acho interessante e que não necessariamente criaria um post em especifico. Então, se você tem facebook e me segue por aqui, te recomendo a seguir também a minha página!

Então peço que curtam a minha página, isso me motiva mais e mais a continuar postando vários assuntos relacionados ao SQL Server.

https://www.facebook.com/frecciablog/

image

Abraços e até logo!

Marcos Freccia
Data Platform MVP

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