Category Archives: Dicas

Reporting Services Databases on Availability Groups

In my current job as a DBA, one of my missions is making everything as automated as possible and making sure that when things go wrong(trust me, they will), the applications that are using my environment can smoothly continue to run with less intervention possible.

You will make mistakes which is part of the job, learning from those mistakes is what makes you grow. Today I want to share with you a few tips that will make your experience with SSRS Databases and Availability Groups less painful. Read the rest of this entry

Changing the Job Owner, doesn’t change the Schedule Owner

One of the capabilities that we do offer to our developers is the ability for themselves to create SQL Server Agent Jobs in our DEV/TEST Environments, so they perform some of their work without the DBA to be involved.

To fullfil this requirement, we grant them the role SQLAgentUserRole, which pretty much does the job. They can create and schedule jobs and execute them. However, latelly one of our DEV’s changed his team and I had to transfer his SQL Agent Jobs to another DEV.

It turns out that when the DEV tried to edit the existing schedule he got the following message: The specified @schedule_id (‘ScheduleIDHere’) does not exist. Read the rest of this entry

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

Visualizing the content of encrypted stored procedures

Probably you were a bit curious about it and decided to click here, right? This is a very recurrent question on Microsoft forums, where people who maybe by mistake encrypted all of the stored procedures, or maybe you support a 3rd party application and there is an particular stored procedure killing the performance of your server and you just wanna know what the same is doing?

Independent of what you want to do, let me show you here how can you manage to see the content of an encrypted procedure. Read the rest of this entry

Removing Databases from Availability Groups with Powershell

Those days at work I had to remove a bunch of databases from the Availability Groups and later drop them from the primary and secondary replicas. I know I could do the click, click and drop thing, but why not PowerShell? Read the rest of this entry

Synchronize Files and Folders using Powershell

Hello everyone!

Last week I was helping an Application Admin to Synchronize files and folders between Source and Destination Servers. The challenge was because some folders had really long hierarchies, so you could imagine something like this.

image

I would say that doing this for some files it is really ok, but for my case we are talking about of 10GB of data and around 4K folders in the root level. Basically, this was the solution that I was able to come up.
The script in in the Github link below.
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

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