SQL Server , Powershell, Europa e muita diversão

Pois  é galera, mes que vem começa minha maratona de palestras na Europa e uma no Brasil. Felizmente hoje sou consultor numa empresa que da suporte total para seus workers se eles quiserem palestrar em eventos ( e forem selecionados é claro). Desta maneira, ficarei 30 +- na Europa (5 paises diferentes no minimo) e depois viajo para os USA e fico mais 15 dias la.

Minha jornada começa dia 20 de Setembro indo pra SP pra fazer o treinamento Mastering em SQL Server com o Luti, depois SQL Saturday São Paulo dia 27 , Europa dia 28 e USA dia 28 Outubro . Volto pro Brasil la pelo dia 15 de novembro +-.

Amsterdã Antuérpia, Lisboa, Porto, Sofia, Barcelona, Praga, Londreesss ..caraaaaaacas acho que vai ser divertido hahahahah PQP.

27 Sep Brasil – SQLSaturday 325Criando suas próprias soluções usando PowerShell

2 October –Belgium – SQL Server DaysMastering PowerShell for SQL Server by Laerte Junior (DBA)

3/4 October – Holland – SQL Saturday Holland – Pre-Conference – Mastering PowerShell for SQL Server

SQL Relay – Esperando a seleção de palestras

11 October – Sofia –  SQL Saturday Bulgaria – Writing your solutions using PowerShell

18 October  Portugal –SQL Saturday PortoCriando suas próprias solouções usando PowerShell

25 October – Spain – SQL Saturday  Barcelona – Esperando a seleção de palestras

Ai dia 28 de outubro viajo direto pros USA pro MVP e PASS SUMMIT.

Ahhhh e se tudo correr como o  previsto, ja volto pro Brasil  na minha nova moradia, numa das praias mais lindas e deliciosas..uhuuuu Smile

“I can PowerShell. What´s your SUPERPOWER ?”

Posted in Powershell, SQL SERVER EM GERAL | 1 Comment

SQL Server–PowerShell and Europe…it will be fun

 

Next month starts my conference marathon in Brazil and Europe. It will be fun.

Thankfully I am working in a company that full supports their employees to speak/participate in community events, so I can travel to Europe on +- 30 days to speak (officially, still waiting some confirmations) at 5 SQL Conferences and then go to USA to the MVP and PASS Summit. In other words, +- 45 days out of Brazil. It will be fun

Lets go : You are welcome in any of those sessions.

27 Sep Brasil – SQLSaturday 325Criando suas próprias soluções usando PowerShell

2 October –Belgium – SQL Server DaysMastering PowerShell for SQL Server by Laerte Junior (DBA)

3/4 October – Holland – SQL Saturday Holland – Pre-Conference – Mastering PowerShell for SQL Server

SQL Relay – Waiting the selection

11 October – Sofia –  SQL Saturday Bulgaria – Writing your solutions using PowerShell

18 October  Portugal –SQL Saturday PortoCriando suas próprias solouções usando PowerShell

25 October – Spain – SQL Saturday  Barcelona – waiting the selection

 

Then on 28 oct I am flying to USA  –  MVP and PASS SUMMIT.

Busy and fun end of the year. A lot of PowerShell and SQL Server around the world for sure . 

I cant wait to meet again the SQL Family and my friends in Europe and USA.

“I can PowerShell. What´s your SUPERPOWER ?”

Posted in Powershell, SQL SERVER EM GERAL | 1 Comment

Comparing versions in PowerShell

Was recently asked on twitter how to compare properties of an object in the version format  (ie 1.2.3.4 >= 3.2.1.1). Well, as the property was string, which came into my mind was to remove the point. Something like

(Get-WmiObject win32_pnpsigneddriver |
Where-Object {(($_.DriverVersion).replace(‘.’,”)) -ge ‘3211’}).DriverVersion

Well, this solution will fail in some cases , as if you have NULL or other chars in the property. So, doing a better research, I found a post from Shay Levy (Actually he helped someone else)

https://www.cupfighter.net/2009/06/powershell-comparing-version-numbers

You can use the [version] type in Powershell to perform the operation Alegre (as showing in the post above)

(Get-WmiObject win32_pnpsigneddriver |
Where-Object {[version]$_.DriverVersion -ge [version]‘1.0.20’}).DriverVersion

Awesome !!!

Posted in Powershell | Leave a comment

Pré-Conferência no SQLRally Amsterdã–PowerShell e SQL Server

Pois é pessoal, to muito feliz e honrado pelo convite do grande amigo Andre Kamman para fazer uma pre-conference no SQLRally Amsterdã em outubro.

O SQLRally é uma conferencia intermediária entre o SQLSaturday e o SQLPASS Summit, tendo 3 dias de conferencia com os melhores profissionais do mundo e eu vou ter o prazer de apresentar uma pre-conferencia de 8 horas no dia 2. As pre-conferencias são mini cursos que são feitas antes do evento propriamente dito, pois são pagas.

É uma oportunidade verdadeiramente unica podem ter certeza  Alegre. Será muito bom rever os amigos #sqlfamily da Europa e principalmente estar novamente nessa cidade linda e com gente tão amigável que é Amsterdã.

Minha pre-con sera :

Mastering PowerShell for SQL Server

Some people say magic, others say supernatural. I’d prefer to say top technology. That’s what PowerShell is today for the Microsoft stack. An Advanced technology built into the top of the operability of windows based operating systems , which allow us to a complete automation platform based, or not, on scripts. But what’s its relationship with SQL Server ? What can I really run , automate and manage in the SQL Server using PowerShell ?
If you are looking for those answers, this course is for you .
It will be split into 2 parts : The first with basic / intermediate fundamentals of programming in PowerShell , as using variables, what are hashtables , custom tables , custom objects , script modules , functions , advanced functions and their attributes and many other concepts .
In the second part , we will see the host of PowerShell in SQL Server ( SQLPS ) , what is SMO, how to use it and how to create your framework to SQL Server using the concepts we’ve seen .
Prepare yourself for a full day of deep PowerShell coding, concepts , fundamentals and lot, but a lot of magic.

sqlrally

Posted in Algo que Esqueci de Categorizar | Leave a comment

Pre-Con in SQLRally Amsterdam–PowerShell and SQL Server

I am very happy, honored and missing words to thanks my good friend Andre Kamman (and all the SQLRally Amsterdam board) by the invitation to present a Pre-Conference in SQLRally Amsterdam on October, 2th.

The SQLRally will be on 2th,3th and 4th October. My pre-con will be on 2th. 8 hours of pure PowerShell and SQL Server.

It will be just AMAZING return to the Wonderful Amstedam and the gentle people live there, also see the #sqlfamily Europe again. I am very excited Alegre

Hope to see you there.

Mastering PowerShell for SQL Server

Some people say magic, others say supernatural. I’d prefer to say top technology. That’s what PowerShell is today for the Microsoft stack. An Advanced technology built into the top of the operability of windows based operating systems , which allow us to a complete automation platform based, or not, on scripts. But what’s its relationship with SQL Server ? What can I really run , automate and manage in the SQL Server using PowerShell ?
If you are looking for those answers, this course is for you .
It will be split into 2 parts : The first with basic / intermediate fundamentals of programming in PowerShell , as using variables, what are hashtables , custom tables , custom objects , pipeline, script modules , functions , advanced functions and their attributes and many other concepts .
In the second part , we will see the host of PowerShell in SQL Server ( SQLPS ) , what is SMO, how to use it and how to create your framework to SQL Server using the concepts we’ve seen .
Prepare yourself for a full day of deep PowerShell coding, concepts , fundamentals and lot, but a lot of magic.

sqlrally

Posted in Algo que Esqueci de Categorizar | Leave a comment

PASS New Role – Virtual Chapter Mentor

I am delighted to announce my new role in PASS. Virtual Chapter Mentor.

It  has been a great honor for me all those past years working with PASS (previosly PASS Regional Mentor for Brasil and currently Co-Lead of the PowerShell PASS Virtual Chapter) and now I have these fantastic opportunity.

I will keep doing my best for sure :)

Thanks to PASS, Karla, Jen and all SQL Server Community

Posted in Algo que Esqueci de Categorizar | Leave a comment

SQL Saturday Chicago #291 – 2014 – I’m speaking

I am very honored to say that I am speaking at SQL Saturday Chicago 2014. A LOT, really a LOT, of  very well known-names in the SQL Server Community will be there and I have the opportunity to be there with them.

My Session will be :

How to properly gather performance counter data using Windows PowerShell

We DBA´s know how important it is to collect performance data. In this session, I will show to you how to properly use the native Get-Counter PowerShell cmdlet to get all information you need from your servers. It has never been as easy to collect performance counter data and save it to a CSV file or a SQL Server table for baselining and later analysis. You may be thinking “But I don’t know nothing about PowerShell and explicitly using .NET classes in my code”. Don’t worry; you don’t need to know this to collect counters. Although this is a 100-level session, you’ll be producing 400-level results and your scripts will scale as the number of servers increase, because we’ll use asynchronous collection and processing. And better yet, we’ll schedule all of it. All this using native PowerShell cmdlets and a minimal amount of script code

Hope to see you there :)

Thanks again for the SQLSaturday Chicago Staff.

http://www.sqlsaturday.com/eventhome.aspx

 

Posted in Algo que Esqueci de Categorizar | Leave a comment