(Bhavesh Patel) Triggers are database objects that store code and get executed automatically when some type of event occurs, such as a data change or change to an object. In SQL Server, there are four types of triggers: DDL Triggers (Data Definition Language), DML Triggers (Data Manipulation Languag

(blobeater) I only ever use the storage explorer when managing my blobs, files, queues within storage accounts.

(James Serra) With data lakes becoming popular, and Azure Data Lake Store (ADLS) Gen2 being used for many of them, a common question I am asked about is “How can I access data in ADLS Gen2 instead of a copy of the data in another product (i.e. Azure SQL Data Warehouse)?”.

(Pinal Dave) The other day I had a very interesting experience with one of my client of Comprehensive Database Performance Health Check. It is a standard process of the health check to identify the workload of the server before making the necessary changes.

(Hannes du Preez) Learn more about how to use three very different SQL statements.

(Siddharth Mehta) Relational databases are found almost in every conceivable business scenario, and SQL is arguably the de-facto standard of accessing data from database systems.

(Rajendra Gupta) This article gives an overview of the KILL SPID command and how to monitor the rollback progress.

(Pinal Dave) I have said many times that I love my job because every single day I find something new to learn and explore. Recently while working on Comprehensive Database Performance Health Check, we took a 5 minutes coffee break and during that short time, one of the DBA asked me a question about

(Kenneth Fisher) TL;DR; Final query is at the bottom.

(Marcin Policht) SQL Server Integration Services (SSIS) was first made available well over a decade ago as part of the release of SQL Server 2005, replacing Data Transformation Services, which had been integrated into the product since SQL Server 7.0.