Laerte Junior in Sysadmin

SQL Server 2022 on Ubuntu 24.04 step by step

Microsoft does not yet support this edition of Ubuntu, but there are some workarounds to make it work. This should...

20 May 2025 5 min read

Laerte Junior in PowerShell

Fun with PowerShell Asynchronous

Imagine a candle that is lit and takes 1 hour to burn out. Now imagine one hundred candles. How many...

03 February 2025 7 min read

Laerte Junior in PowerShell

Extending Get-Process to show the Process Chain using PowerShell Proxy Functions

A proxy function or wrapper function allows you to deploy a custom version of a function or cmdlet while the...

01 July 2024 8 min read

PowerShell

Laerte Junior in PowerShell

Automating BCP with PowerShell

I was talking with a good friend that has an environment with terabytes of information and to create a homolog...

09 February 2024 8 min read

PowerShell

Laerte Junior in PowerShell

PowerShell Dynamic Parameters and SQL Server

Have you ever been in a situation that you want to call a cmdlet or a function with a parameter...

05 January 2024 6 min read

Database Administration

Laerte Junior in Database Administration

What Is SQLPSX?

SQLPSX is a useful library you can add to PowerShell to automate many DBA tasks. In this article, Laerte Junior...

29 October 2018 12 min read

Containers and Virtualization

Laerte Junior in Containers and Virtualization

Provisioning SQL Server Instances with Docker

With SQL Server 2017, Microsoft announced the exciting news that SQL Server would now run in Docker containers. Laerte Junior...

16 April 2018 12 min read

Laerte Junior

Questions About Amazon Data Migration Service (AWS DMS) That You Were Too Shy to Ask

Can you imagine it? You are in a group of smart database people, and they are debating the finer points...

18 October 2017 9 min read

Laerte Junior

Questions About RDS SQL Server That You Were Too Shy to Ask

There are a number of different ways that you can host SQL Server. RDS SQL Server, for example, uses SQL...

13 September 2017 12 min read

Database Administration

Laerte Junior in Database Administration

SQL Server High CPU: Investigating the Causes

Any DBA who is trying to find the cause of an intermittent problem such as SQL Server high CPU dreams...

17 July 2017 9 min read

Database Administration

Laerte Junior in Database Administration

Automating the Synchronization of RDS SQL Server Agent Jobs in a Multi-AZ Environment

Although Azure is the obvious Cloud service to host SQL Server, Amazon Relational Database Service (RDS) for SQL Server is...

27 June 2017 8 min read

Laerte Junior

Invoke-SqlCmd Just Got Better!

If you’ve read even just a few of my articles on Simple-Talk you know that I’m a big fan of...

30 June 2016 3 min read

Laerte Junior

The PoSh DBA: Accessing SQL Server from PowerShell

The worst part for a DBA of getting started with PowerShell is often just figuring out the best way of...

01 June 2016 17 min read

Laerte Junior

Questions About PowerShell Basics That You Were Too Shy To Ask

Developers who are already familiar with application languages will be baffled by different aspects of PowerShell to the beginner to...

11 April 2016 16 min read

Laerte Junior

The PoSh DBA: Assigning Data to Variables Via PowerShell Common Parameters

Sometimes, it is the small improvements in a language that can make a real difference. PowerShell is able to introduce...

07 March 2016 7 min read

Laerte Junior

The PoSh DBA – Towards the Re-usable PowerShell Script

When starting out with PowerShell, it is hard to escape from the detail to work out the best strategy for...

21 January 2016 17 min read

Laerte Junior

The PoSh DBA – Using the Basic PowerShell Paradigms

PowerShell is like any computer language: you must understand the paradigms, the constructs, and the way it is designed to...

04 December 2015 10 min read

Laerte Junior

Automating Your SQL Server Best Practice Reports: The Document

If you're making a report from table-based data, an MS Word document is often a good option. In the second...

21 October 2015 10 min read

Laerte Junior

Automating Your SQL Server Best Practice Reports:The Checks

A DBA in charge of a whole lot of databases and servers has to check regularly that there are no...

06 October 2015 13 min read

Laerte Junior

The PoSh DBA – Specifying and Gathering Performance Counters

If you are needing to keep tabs on a number of servers and applications in a Windows domain then performance...

07 March 2014 18 min read

Register for Simple Talk

Laerte Junior

Laerte Junior's content

SQL Server 2022 on Ubuntu 24.04 step by step

Fun with PowerShell Asynchronous

Extending Get-Process to show the Process Chain using PowerShell Proxy Functions

Automating BCP with PowerShell

PowerShell Dynamic Parameters and SQL Server

What Is SQLPSX?

Provisioning SQL Server Instances with Docker

Questions About Amazon Data Migration Service (AWS DMS) That You Were Too Shy to Ask

Questions About RDS SQL Server That You Were Too Shy to Ask

SQL Server High CPU: Investigating the Causes

Automating the Synchronization of RDS SQL Server Agent Jobs in a Multi-AZ Environment

Invoke-SqlCmd Just Got Better!

The PoSh DBA: Accessing SQL Server from PowerShell

Questions About PowerShell Basics That You Were Too Shy To Ask

The PoSh DBA: Assigning Data to Variables Via PowerShell Common Parameters

The PoSh DBA – Towards the Re-usable PowerShell Script

The PoSh DBA – Using the Basic PowerShell Paradigms

Automating Your SQL Server Best Practice Reports: The Document

Automating Your SQL Server Best Practice Reports:The Checks

The PoSh DBA – Specifying and Gathering Performance Counters