Category Archives: VirtualPass
I just wanted to share that I will have the pleasure of speaking at Microsoft Ignite The Tour in Stockholm/Sweden.
The event is taking place on the days 24th and 25th of April at Stockolmsmassan.
I will be speaking about Azure SQL Database and all the cool features around the platform that you can take advantage off. If you are planning to attend the event and have any curiosities around Azure SQL DB, I really recommend you to be there.
Below you can see more details of the session.
Azure SQL DB brings a lot of benefits for new and existing workloads. In this session we are going to explore the various aspects of an Azure SQL DB. How we can have a self managed, high available and high performing Database. Properly monitoring is also an important part of the job and we will cover several aspects of monitoring an Azure SQL DB. After this session you will feel comfortable in moving your workload to the cloud.
I hope to see some of you there!
As a matter fact, it is not new that dbatools is a great PowerShell module for the SQL Server DBA, and from time to time they come up with new functions that for me I just think: Why I never thought about it before?
Today I want to talk about the function Remove-DbaBackup and more specifically my customized version of it. No, I didn’t rewrite Remove-DbaBackup but rather improved to my environment. The function by itself is just great and it addresses the goal of removing the backups nicely, but at the end, the function was not doing something that I wanted. Read the rest of this entry
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.
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.
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
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
On the attempt to always learn something new, I was playing around with Python, the Python-Twitter Package and the Schedule package.
Pretty much I wanted to create a small script where I could every X minutes to connect on twitter and re-tweet some tweets that were using an specific hashtag.
This was what I came up with. Read the rest of this entry
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.
Nos dias 6 e 7 de Abril, acontecerá na UNIP Tatuapé São Paulo o maior evento presencial de experts Microsoft do Brasil – www.mvpconf.com.br, vou tentar enumerar as 5 razões de qualificar como o maior evento de expects e impulsionar sua curiosidade para realizar sua inscrição agora: Read the rest of this entry
I just wanted to make a short blog post to tell you that I will be speaking in two meetups in Berlin in this month. So, if you follow me and live in Berlin or nearby I invite you to attend it and learn more about the Microsoft Data Platform world. Read the rest of this entry
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