T-SQL HOST_ID and HOST_NAME

HOST_ID and HOST_NAME Included in T-SQL for SQL Server is a functions that returns the workstation information that executes a SQL statement.  You can use this to record what workstation the transaction came from in your application or business intelligence processes. HOST_ID will return the Process ID from the client  machine that is running the … [Read more…]

Azure Data Factory

What is the Azure Data Factory? The Azure Data Factory is a managed service for data storage and processing.  It allows you to build cloud based solutions to move and store your data in a centralized managed environment.  Source data can be pulled from on premise or cloud environments consisting of structured, unstructured or semi-structured … [Read more…]