Novos vídeos no canal do Youtube

Olá pessoal,

A algum tempo atrás estava gravando um curso sobre criação de baselines com SQL Server, Integration Services e Reporting Services. Acontece que com a minha mudança de rotina, de trabalho e de uma série de outros fatores a gravação do curso acabou ficando em segundo plano.

Depois de pensar mais sobre isso, decidi que não iria mais continuar a gravação dos vídeos e então resolvi liberar em meu canal do youtube os primeiros que eu tinha gravado. São cerca de 4 a 5 vídeos curtos, mas que passam alguma dicas bem legais. Read the rest of this entry

Advertisements

Say goodbye to Service Packs!!

Did you hear the news?

Microsoft is changing its Service Model for SQL Server and the major difference is that Service Packs will be no longer released starting on SQL Server 2017. However, this doesn’t mean that you no longer will have new features and product enhancements, rather than they will release new features and so on in Cumulative Updates.

Why are they doing this for SQL Server 2017? Well, in my personal opinion I believe that with major product versions being released almost every year or two years, they want to be faster in terms of releasing new fixes, launching new features and so on. Read the rest of this entry

Do you want to improve SQL Server Docs?

I think many of us have not heard this, but recently (maybe not that recently) Microsoft made the SQL Server Docs available on GitHub under this link: https://github.com/MicrosoftDocs/sql-docs

Currently, if you navigate to any SQL Server Documentation and let’s say that you right now goes to this link: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server in the right hand side of the window you will see this… Read the rest of this entry

SQL Saturday #689 Prague – I will be speaking!

SQLSat689_Speaking_600x300_02 Read the rest of this entry

Which Python courses I did? Or I’m still doing

PS: Portuguese version below!

Hi everyone,

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

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

SQL Saturday 656 Denmark – I am going!

Hi everyone!

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.

http://www.sqlsaturday.com/656/EventHome.aspx

Two things that are important to mention! Read the rest of this entry

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

How to connect Python and SQL Server – Part 2

Hey Guys,

In my first blog post about Python and SQL Server, I gave a very short introduction in how to actually connect and execute a simple query. Today I want to extend a bit on using Python and SQL Server.

As I described in the end of the previous post the ideal scenario is that you inherit the database connection from a single file and then use it whenever and anywhere you want. This makes your code to look cleaner and eliminate redundant work in case you need to change credentials or something else. For that I will show to you how to do it. Read the rest of this entry