Drupal is a Senior SQL Server consultant with over 20 years of experience in engineering innovative SQL Server solutions for high growth organizations. A truly SQL Server specialist and IT generalist, Drupal is a certified MCDBA, Oracle OCP-DBA and IBM WebSphere Administrator. He is also ITIL V3 certified at the Foundation and Intermediate levels as well as PMP.

Technical Article

A simple powershell script to look up server hardware and OS information

This is a simple powershell script to query and display hardware and OS information from a remote computer.

It uses CIM (Common Information Model) that is available since Powershell version 3 so as long as you have version 3 and up, you should be able to run this script against any server that you have access to.

You rated this post out of 5. Change rating

2019-08-14 (first published: )

2,391 reads

Technical Article

Look up AD user properties using powershell

I realize that this is a bit of a lengthy script for something that you can use a one liner in the power shell:

Example:

Get-ADUser

But I needed to highlight certain properties of given user and take certain actions based on the values. And the result is this power shell script.

You rated this post out of 5. Change rating

2019-07-15 (first published: )

1,260 reads

Blogs

Simplify Kubernetes Security With Kyverno and OPA Gatekeeper

By

Here’s how these tools can make Kubernetes security easier and help you avoid common...

A New Word: Lackout

By

lackout – n. the sudden awareness that you’re finally over someone, noticing that the...

Delta Lake over Spark Connect

By

All Spark Connect Posts I have just finished an update for the spark connect dotnet...

Read the latest Blogs

Forums

Merge techniques

By purushotham.k9

In Azure SQL DB, i want to merge records from the staging table to...

SSRS error: The Value for the image 'Image1' has a constant value...

By sgmunson

Full error message: SSRS error: The Value for the image 'Image1' has a constant...

XML_COMPRESSION for existing tables

By zoggling

We are in the process of upgrading to SQL Server 2022 and would like...

Visit the forum

Question of the Day

Adding Defaults

I have a table, called dbo.logger, in SQL Server 2022. I decide to add two new columns to this table with this code.

ALTER TABLE dbo.logger ADD CreateDate DATETIME CONSTRAINT dfGetDate DEFAULT GETDATE()
GO
ALTER TABLE dbo.logger ADD ModifyDate DATETIME DEFAULT dfGetDate
GO
What happens when I run these two batches?

See possible answers