Blog Archives

Ich werde sprechen an SQL Saturday Munich 2018

Guten Morgen zusammen!

Die zeit zur minem nächsten session ist gekommen!

It is a mixed feeling of excitement and being nervous at the same time!

This weekend I will be, along with my friend and also Data Platform MVP Fabiano Amorin, delivering a session at SQL Saturday 772 in Munich/Germany.

Together with him, we will deliver the following session: Stop Everything! T-SQL tips to make a developer life easier!

We promise it will one hour of really cool demos and also some surprises for you! I guess you will like what you are going to see.

Off course I want you guys in our session, but as Fabiano is coming from Brazil for the event, he is also going to deliver a second session called: 13 reasons why my query is slow, which I will be certainly checking it out, and you should do the same.

Other than that, you have at least other 25 sessions that you can choose to watch, there is something to please everyone. Ah! I should say that you have to register yourself ASAP, as open seats are running out very fast.

I will be the whole day in the konferenz, and I’d love to talk with you! Make sure to stop by.

Bis später!

Marcos Freccia
Data Platform MVP

Linking Data Sources to SSRS Reports with PowerShell

Imagine the following scenario: You just migrated a bunch of SSRS Reports to a new Reporting Services instance, which has a different folder structure. In this perspective, one of the things that get lost along the way is the linking between Data Sources and Reports.

If you are in the PowerShell world like me you know very well this repository in the Microsoft organization on Github: ReportingServicesTools.

Reporting Services Tools is a module that interacts with Microsoft SQL Server Reporting Services, making it easier several tasks like importing and exporting reports, creating folders, subscriptions, data sources and so on. The module is maintained by Microsoft along with some know PowerShell folks from the community like my friend Claudio Silva(@claudioessilva) from the dbatools team. Read the rest of this entry

Automate your SQL Server Restore Tests with PowerShell, dbatools and PowerBI

Hello everyone,

At work, I got to do some really interesting stuff. What I like is they really give me the freedom to try things out. Ah, and if you wanna join us, we have a position to work with me, posted here: https://grnh.se/4899e2091.

There is a saying, which I don’t exactly remember, is that a backup is only a backup if you test the restore of the same. So, I was working on creating an automated way of restoring the backups of my production databases and give me some sort of reporting around it.

So, I did that work and it is running really fine with the structure that I have. Then, I had the idea to share what I did with the community, mainly because I rely on almost all of my work to dbatools, and without them I would have more trouble/work do, to get the same results.

I shared a screenshot on twitter as you can see below.
image
link: https://twitter.com/marcosfreccia/status/1037031233262374914

I got a few replies from people saying that they would like to see how it is done. So, in this blog post, I’ll explain you all the steps that I had to do, to obtain this result.

Read the rest of this entry

I’m speaking at SQL Saturday Lviv 2018

SQLSaturday #753 - Lviv 2018 Hello Everyone!

In the end of this month, I will be in Lviv, Ukraine for the SQL Saturday 753 or SQL Saturday Lviv!

There will be 18 sessions with a variety of topics for you to choose 🙂 If you live in Lviv or nearby you should definetely check it out.

Honestly, I am really excited to be in Lviv, I never expected that one day I would be in Ukraine and also going there for speaking, it is a double excitement!

I will be speaking about some 10 alerts that you shoul have it running in your SQL Server. It is a very interesting topic in those days where everything is “automated”, right? If you are attending the event, make sure to join me at 12:50PM for the session: 10 alerts that you should have it running in your SQL Server.

If you follow me here or in my twitter @marcosfreccia and you are going to attend the event, make sure to stop by and say hello!!

See you!

Marcos Freccia
Data Platform MVP

Free Microsoft Flow + Twitter + SQL Server

Those days I was playing around with Microsoft Flow and have created some automation for a few things.

While playing with it the thing that I liked was the possibility to host workflows in a free account. So, if you have a live account you can pretty much use a ton of connectors and create your own workflows. You should check it out the plan offers in this link below and understand how you can use it.

image
https://emea.flow.microsoft.com/en-us/pricing/  Read the rest of this entry

My Lightining Talk at SQL Saturday Vienna 2018

SQLSat679_Speaking_600x300_02

Hello everyone!

I just wanted to share that I will be presenting a Lightining Talk at SQL Saturday 679 in Vienna, Austria. I will have 10 minutes to present the following session.

Title: My 5 favorite Powershell Commands!

So, if you are planning to be in Vienna for the SQL Saturday, make sure to register yourself, as there are only a few spots available. Also, if you are a DBA, I would say that you really should be attending my Lightining Talk, because the commands that I am gonna show you will save your life.. or at least make it easier.

Also, look at the Event Agenda, as there will be many other sessions in all areas of the Data Platform world.

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

See you in Vienna!

24 Horas de PASS– Edição em Português

Olá pessoal,

Nos próximos dias 29 e 30 de Novembro teremos mais uma edição do 24 Horas de PASS – Edição em Português. O evento já é bastante conhecido da comunidade técnica Microsoft de Data Platform.

Como todos sabem o evento é 100% gratuito e online, então sem desculpas para não participar. Nessa edição terei o prazer de realizar uma apresentação sobre Power BI Report Server e falar um pouco mais sobre esse modelo de Power BI e como sua organização pode também obter. Então, segue abaixo os detalhes de minha apresentação. Read the rest of this entry

Looking at dbatools github with Power BI

First of all! Really, really thanks dbatools team for this. I don’t have words to describe the impact that you guys have in my job. I use it every single day!

Now… back to the subject..

Those days I was preparing myself for a presentation and started to play around with Online Services Content Packs and decided to use the GitHub App Connector that is available.

In the left bottom of the Power BI area you have the Get Data option.

image

Once the page is opened you should choose Services and click on GET.

image

In the search bar just type Github. In the Github connector click on Get it now

image

Now the fun begins. What about if you want to have a look at your favorite DBA Powershell  Gallery? Off course I am talking about dbatools.io. Read the rest of this entry

Creating Custom SSRS Security Roles

When you have a consolidated environment, usually you don’t want to set very broad permissions to users, most of the times you only want them to see what is really necessary.

Doing that in the Database Engine is quite easy, but what about Reporting Services? We know that SSRS exposes the following default roles: Browser, Content Manager, My Reports, Publisher and Report Builder. However, for me sometimes those roles offer too much to the user.

What people usually don’t know is that you can connect to your SSRS Instance using SQL Server Management Studio and then create customized roles. So, let me show you how to do it. Read the rest of this entry

EVENTO ONLINE: MICROSOFT 365 DAY

IMG_Evento

Fala galera!

Espero que vocês estejam bem e rodando tudo em Cloud!

Neste tempo repleto de mudanças, o evento passa por uma grande transformação a fim de proporcionar à toda a comunidade Microsoft uma nova e atual experiência: Seja bem-vindo ao MICROSOFT 365 DAY.

Para este evento reunimos os melhores profissionais da comunidade técnica e agora além do Office 365, teremos também sessões EM+S, falando de Azure AD, ATA, Cloud App Security, AIP, Intune e para fechar o ciclo, contaremos com sessões sobre Windows 10.

O MICROSOFT 365 DAY é inovador em todas as suas formas, o evento será 100% Online, com 24 sessões de 25 minutos cada e 4 sessões de Business de 50min, tudo dividido em três trilhas de conhecimento:


Read the rest of this entry