Click here to monitor SSC

Laerte Junior Laerte Junior
Laerte Junior is a SQL Server MVP and, through his technology blog and simple-talk articles, an active member of the Microsoft community in Brasil. He is a skilled Principal Database Architect, Developer, and Administrator, specializing in SQL Server and Powershell Programming with over 8 years of hands-on experience. He holds a degree in Computer Science, has been awarded a number of certifications (including MCDBA), and is an expert in SQL Server 2000 / SQL Server 2005 / SQL Server 2008 technologies. He also organizes, and is a speaker at microsoft community events, attracting hundreds of attendees. Laerte has also recently become a Friend of Redgate in Brasil, has taught classes at universities, and produced webcasts for the community.

You should follow him on Twitter as @LaerteSQLDBA

Create a Monitoring Server for SQL Server with PowerShell
by Laerte Junior | 21 October 2011 |
At some point, you are going to need a notification system for a range of events that occur in your servers, even if it is only a warning of low disk space. Laerte shows how you can even set up temporary or permanent alerts for any WMI events to give you a system... Read more...
Using PowerShell and WMI Events Queries for Powerful Notifications
by Laerte Junior | 25 July 2011 |  7 comments |
With PowerShell in one hand, and WMI in the other, DBAs can do almost anything in their Window's environments, and Laerte is using his powers for good. He built a highly precise, highly configurable alerting system for his servers, and now shows us exactly how he... Read more...
PowerShell Eventing and SQL Server Restores
by Laerte Junior | 05 July 2011 |  3 comments |
When you're managing a large number of servers, it makes no sense to run maintenance tasks one at a time, serially. PowerShell is able to use events, so is ideal for, say, restoring fifty databases on different servers at once, and be notified when each is... Read more...
Fun with SQL Server Profiler trace files and PowerShell
by Laerte Junior | 25 November 2010 |
Running Profiler traces against multiple servers becomes a painful process when it’s time to collate and filter all that data. It would be time-consuming, frustrating and messy if Laerte hadn’t written this handy PowerShell script (complete with examples) to help... Read more...
Gathering Perfmon Data with Powershell
by Laerte Junior | 08 July 2010 |  23 comments |
When you have to routinely collect data from Performance Monitor Counters, it soon becomes easier and more convenient to use PowerShell. SQL Server MVP Laerte Junior was inspired to create a script, and guides us through its useful functions. Read more...
I'm a SQL Server DBA, and I'm in Love with PowerShell
by Laerte Junior | 28 May 2010 |  23 comments |
To learn PowerShell, Laerte suggests that you just start using it. To encourage you to start, he provides a series of tips on using PowerShell with SQL Server to solve various everyday problems. With a little patience, a good IDE, and a bit of help and advice,... Read more...
Exceptional PowerShell DBA Pt 3 - Collation and Fragmentation
by Laerte Junior | 11 February 2010 |  22 comments |
In this final look into his everyday essentials, Laerte Junior provides some useful scripts for the DBA that use an alternative way of error-logging. He shows how to use a PowerShell script to check and, if necessary, to defragment your indexes, write data to a SQL... Read more...
Exceptional PowerShell DBA Pt 2 - The Morning Checklist
by Laerte Junior | 21 January 2010 |  26 comments |
Laerte Junior takes us further into the world of an Exceptional PowerShell DBA, showing us how he uses PowerShell 2.0 to take all the headaches out of even more of his daily checklist. What could be better than having your morning checklist run itself? Read more...
Exceptional PowerShell DBA Pt1 - Orphaned Users
by Laerte Junior | 26 November 2009 |  30 comments |
Inspired by Brad McGehee's 'How to Become an Exceptional DBA', Laerte decided it was high time he took a proactive approach to his work. Using PowerShell, he came up with a solution that makes finding and fixing orphaned users as easy as cake, and now he's sharing... Read more...
Reducing I/O with the 'Missing Indexes' DMVs
by Laerte Junior | 09 October 2009 |  20 comments |
Laerte recently experienced an I/O nightmare, which, as a happy accident, gave him an opportunity to test out the ‘Missing Indexes’ DMVs and see if they were up to scratch. He solved his problems, ran a few tests to get a feel for how well the DMVs performed, and... Read more...
Over 400,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.

Join Simple Talk