Category Archives: Dicas
PS: Portuguese version below!
Before even starting this blog post, I want it to make it very clear! If you are an Python/Developer Expert most likely this isn’t for you.
The reason for that is if you aren this kind of person, maybe you will find that those courses that I am sharing in here are too basic, because the main idea is really that. I want to share the courses that I did, or that I am still doing and reviewing from time to time, in order to not forget what I learnt.
This blog post is meant for people like me that are maybe SQL Server professionals and want to learn more about this language and what can be done. So, without prolonging too much, here it is my list. Read the rest of this entry
I’m not sure if you guys know it, but on October 07th, 2017 we will have another amazing SQL Saturday 656 that it is taking place in Copenhagen, Denmark.
Surely, it will be an amazing day of learning and network from the Data Platform Experts that are coming from all places. So, if you are an IT person and is not quite sure yet on what do to on Oct, 7th, join this FREE event. You can get all the details from the home page.
Two things that are important to mention! Read the rest of this entry
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 ] 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
I wanted to share something that I am doing this week at work. One of the applications that I support is generating a lot of transaction log in the database. Just to have an idea, we run Transaction Log backups every 30 minutes and I have backups over 100GB and sometimes 200GB. The difficult part of investigating what is generating that amount of log is because the databases involved are used by at least 3 different applications and streams. So, I remember that in the past I created a simple script that looks at this information in the database and then I may have more inputs of what is really generating that amount of log. Read the rest of this entry
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
I was those days changing a few settings in the environment, where I had this small problem and I would like to share what did I do to fix it. The task in question was actually easy: To change the default directory of the LOG folder, that usually is where the SQL Server Agent logs, ERRORLOG and some other things are stored. Read the rest of this entry
Esse ano teremos a 3º edição do SQL Saturday em Joinville que acontece sempre no mês de Abril e nesse ano especificadamente será no dia 08, para esse ano o evento será o de número 580. Já não preciso mais falar o quão importante é o SQL Saturday para o profissional de Banco de Dados que deseja aprimorar seu conhecimento e de quebra conhecer novas pessoas e fazer muito networking durante o evento.
Vale lembrar que a cada ano o evento está crescendo, então é sempre bom garantir sua vaga para não ficar de fora. Logo abaixo seguem duas postagens dois eventos anteriores. Read the rest of this entry