Category Archives: VirtualPass
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
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
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.
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
You all know that lately I have been learning a bit of Python and one of the very first things that every single course says are: Create all your projects in a Python Virtual Environment. However, what does Virtual Environment mean?
When you do a default installation of Python, you can pretty much use it, install packages and create all your projects and this will work without any problems. The problem begins when a particular project of yours starts to have dependencies of a certain Python package in a certain level. If you run pip upgrade for a package in your global environment all projects that uses that one will get upgraded as well. The outcome from that are two possible results.
1) Your package is upgraded successfully and all projects that relates to that also work after.
2) Your package is upgraded successfully and some of your projects stops to work because of version compatibility. Read the rest of this entry
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.
See you in Vienna!
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
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.
Once the page is opened you should choose Services and click on GET.
In the search bar just type Github. In the Github connector click on Get it now
No dia 09 de novembro aconteceu o Microsoft 365 Day e depois de uma análise no Big Data do evento, podemos concluir: O Microsoft 365 Day foi incrível!
Foram 29 sessões, 1000+ inscritos e 500+ pessoas que passaram pelo evento online. Divido em três trilhas: Produtividade, Segurança e Business tivemos a presença média de 100 pessoas por sessão.
(1.100 inscritos ao todo. ) Read the rest of this entry
The very last SQL Saturday in Europe of this year is taking place in Ljubljana – Slovenia and I can glady say that I will be there, and even better, I am going to be a speaker.
I would say that most of my readers already know what is SQL Saturday, but if you don’t, just go directly to SQL Saturday Home Page, where you can find a very easy explanation to it.
Personaly, I think that SQL Saturday’s are a great opportunity to learn something new in your carrer. For example. nowadays the majority of the sessions that I go are about Database Lifecycle management. However, SQL Saturday’s are also good to meet new people, hear from the experts, etc.. So please, go to the event page and register it, as there will be plenty of great sessions!
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