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: )

366 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: )

888 reads

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.

2019-07-15 (first published: )

958 reads

Blogs

Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 4

By

This is the fourth and final post in a series about modern Data Lake...

SQLOrlando 2019

By

We just had our final event of the year and looking back, not bad...

Read the latest Blogs

Forums

@AR*https://secchampionshipsec.co/2019/

By all315sporbp

https://secchampionshipsec.co https://secchampionshipsec.co/2019/ https://secchampionshipsec.co/live/ https://secchampionshipsec.co/stream/ https://secchampionshipsec.co/football/ https://secchampionshipsec.co/reddit/   https://accchampionshipthe.co https://accchampionshipthe.co/2019/ https://accchampionshipthe.co/live/ https://accchampionshipthe.co/stream/ https://accchampionshipthe.co/football/ https://accchampionshipthe.co/reddit/  

about system table of sys.dm_db_missing_index_details and sys.dm_db_index_usage_

By 892717952

sys.dm_db_missing_index_details shows we need to create an index based on the columns under equality_columns...

From Source Control to Database using SQL Compare Command Line

By Additional Articles

Comments posted to this topic are about the item From Source Control to Database...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers