More SQL/PowerShell/PASS community stuff

 

I am very happy to announce that I will be speaking at SQLSaturday Barcelona –> http://www.sqlsaturday.com/338/schedule.aspx

That will be epic, and it will be very cool to see my Solidq and Spanish friends again.

Also, I will be in the PASS booth  at TECHED Europe. If you be around there, please go to the Exposition Hall and lets drink some coffee and talk about PASS

Belgium,Holland,Bulgaria,Portugal,Spain ..then USA –> MSmileVP and PASS Summit

A great end of year, with what I love to do..Community Stuff

Posted in Algo que Esqueci de Categorizar | Leave a comment

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