Category: SQL

Apr 24

Read SQL tables and its content using PowerShell

When I first started with PowerShell, I mostly used to export my content to CSV files, and then work with these, but after a while, I figured it would be best to store the data in a SQL Database. Using powershell to import the data to my tables is a lot better than having csv …

Continue reading

Apr 04

How can I install System Center Configuration Manager (Current Branch) version 1802 on Windows Server 2016 with SQL Server 2017 – Part 1

https://www.windows-noob.com/forums/topic/16114-how-can-i-install-system-center-configuration-manager-current-branch-version-1802-on-windows-server-2016-with-sql-server-2017-part-1/?tab=comments#comment-61281

Apr 04

How can I install System Center Configuration Manager (Current Branch) version 1802 on Windows Server 2016 with SQL Server 2017 – Part 2

https://www.windows-noob.com/forums/topic/16116-how-can-i-install-system-center-configuration-manager-current-branch-version-1802-on-windows-server-2016-with-sql-server-2017-part-2/

Apr 03

A new command to find all of your SQL instances

a new command to find all of your sql instances

Mar 06

AddWithValue is Evil

Good read! http://www.dbdelta.com/

Dec 21

Powershell scripts for Office 365

PowerShell Scripts for Office 365

Jul 11

sp_Blitz® – Free SQL Server Health Check Script

sp_Blitz® – SQL Server Takeover Script