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.

Event Notifications Example

Event notifications are kinda like a trigger in the sense that they respond to specific event, specifically in response to DDL statements and SQL Trace events.

The major difference between...

2019-11-21 (first published: )

866 reads

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.

2019-08-14 (first published: )

1,182 reads

Blogs

Daily Coping 26 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Rowcount estimates when there are no Statistics

By

When you don't have statistics, what does SQL use to calculate the estimated number...

Synapse Analytics and .NET for Apache Spark Example 4 - JOINS

By

This is a bit of a longer one, a look at how to do...

Read the latest Blogs

Forums

Balance is not calculating correctly,when date get change in transection.

By akhterhussain80

Below is data in which two different date are coming,01/19/2021 and 01/18/2021 , Date...

Accessing a RESTORING database for test refresh

By Pete Bishop

I have a requirement whereby testers on ServerA need a copy of the production...

How to get value portion key to every rn from 1 to 3 row on one row?

By ahmed_elbarbary.2010

I need to get value portion key to every 3 row on one row...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers