Category Archives: SQL Server
Olá pessoal, tudo bom com vocês?
Nos artigos anteriores demos inicio a nossa sequencia de vídeos sobre o dbatools, onde realizamos a instalação do Visual Studio Code e consequentemente instalamos o módulo do dbatools.
Nesse vídeo é onde de fato vamos abortar os primeiros comandos que compoem esse maravilhoso módulo que são: Get-DbaLogin e Export-DbaLogin. Vocês verão que através de scripts simples podem automatizar algumas rotinas que farão a vida de um administrador de banco de dados mais simples.
Nada do que vou mostrar no vídeo é complexo de ser feito, você precisa apenas pensar no problema a ser resolvido, e é isso mesmo a minha abordagem.
Espero que vocês gostem do conteúdo que estão prestes a assistir.
Como sempre enfatizo, fico aguardando os comentários de vocês, sejam com sugestões de vídeos ou até mesmo críticas.
Abraços e até o próximo vídeo.
Data Platform MVP
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.
Data Platform MVP
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!!
Data Platform MVP
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