Category Archives: SQL Server
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
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
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
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!
First of all, I want to thank everyone at my session at SQL Saturday 689 in Prague this last weekend. It was a tremendous pleasure for me to present and share a bit of what I know with all of you.
I also want to say THANK YOU to the Czech BI & SQL Pass User Group for putting this amazing event to the community, I know how much work and effort has to be done to have such a great event. You treated not only myself but all the speakers so well, so thanks again for having me! You guys are great!
I also want to say THANK YOU to the Sponsors, with all your support the event was just awesome!
As I promised during my presentation, I would write this post to share the link to where you can download most of the resources used by myself during the presentation.
I would like to also ask you a bit of your time to fill up the session evaluation. This means a lot to all the speakers. Doing that, it helps all of us speakers to improve our presentation, subjects, demos and etc.. Please, please, please!! Do it! The link is below.
Thanks again and see you in 2018!
Data Platform MVP
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
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
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