Technical Article

Fun with PowerShell Asynchronous

Imagine a candle that is lit and takes 1 hour to burn out. Now imagine one hundred candles. How many hours will it last? That depends. If they are lit simultaneously, it will take 1 hour. That is the basic idea of running in the background or asynchronously. Of course, the 100 candles can execute independently of one another, unlike if you try to run 100 processes on a computer with 2 cores. PowerShell has some ways to manage that, as PowerShell job – which we will see in this article – runspaces – needs to add programmable using .net.

Blogs

A New Word: Gnossienne

By

gnossienne– n. the awareness that someone you’ve known for years still has a private...

Exploring DiskANN: Part I: Understanding the Algorithm before the disk

By

How I used AI for this postChatGPT to generate images based on info specifically...

Learning Tool – Deepstash

By

A few months ago I started using Deepstash. Deepstash breaks books into the key...

Read the latest Blogs

Forums

How Can SQL Server Detect Application Errors When Developers Can’t?

By Pablo Echeverria

Comments posted to this topic are about the item How Can SQL Server Detect...

Getting Database MaiL Profiles

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting Database MaiL Profiles

Preserving Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Preserving Data

Visit the forum

Question of the Day

Getting Database MaiL Profiles

If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?

See possible answers