Install SQL Server using Powershell Desired State Configuration (DSC)
This article shows the basics of using PowerShell Desired State Configuration to install a SQL Server.
2023-05-29
6,300 reads
PowerShell
A Brief Introduction to PowerShellAI, an Intelligent Command-line
Learn how you can interact with ChatGPT from PowerShell.
2023-09-06 (first published: 2023-04-24)
7,032 reads
ChatGPT and PowerShell – Some practical examples
See how well ChatGPT works with questions on generating PowerShell code.
2023-03-20
13,988 reads
How to grant PowerBI Service Workspace access using PowerShell
Learn how to more easily manage permissions in the Power BI service using PowerShell.
2022-06-06
2,908 reads
Using T-SQL over PoSh
When do you choose to use one tool or language over another. Steve discussed T-SQL vs. PowerShell.
2022-04-20
164 reads
2022-02-14
4,512 reads
2022-01-07
453 reads
Working with PowerShell strings
Knowing how to manipulate strings is critical in any language. In this article, Greg Moore explains working with PowerShell strings.
2021-12-20
2021-12-15
426 reads
2021-11-29
187 reads
Blogs
AI Step 1
By Vinay Thakur
As this is an Artificial Intelligence (AI) World, things are changing. We can see that...
Beginner’s Guide: Building a Dockerized Todo App with React, Chakra UI, and Rust for Backend
In a containerized app, React and Chakra UI provide a robust and accessible user...
A New Word: Nachlophobia
By Steve Jones
nachlophobia – n. the fear that your deepest connections with people are ultimately pretty...
Forums
identify consecutive records greater than 1
Hello I need help identifying all records that have consecutive hours (time in order)...
Call dynamic sql storedprocedure from SSIS execute sql task
hi, I have a table called Rules Create table Rules ( Id int ,...
Migrating database with many orphan users.
I am currently upgrading a very old database running SQL Server 2008 to SQL...
Question of the Day
The Funny SELECTs
What is returned from this query?
SELECT
( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2011' AND soh.OrderDate < '01/01/2012') AS OrdersIn2011
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2012' AND soh.OrderDate < '01/01/2013') AS OrdersIn2012
, ( SELECT COUNT (*) FROM Sales.SalesOrderHeader AS soh
WHERE soh.OrderDate >= '01/01/2013' AND soh.OrderDate < '01/01/2014') AS OrdersIn2013; See possible answers