SQL Server Management Studio (SSMS) is the principal interface for working with Microsoft SQL Server. However, many subtleties of this powerful tool evade even the most seasoned professionals. Here ...

A repository for the practice exercises for Microsoft SQL Server Integration Service (SSIS for short, it is an ETL tool) while digging deep on understanding the tool and practicing. Exploratory Data ...

Microsoft has updated its SQL Server Management Studio to version 17.3, adding two features along with various minor enhancements and bug fixes. The Import Flat File Wizard streamlines the process of ...

FileTables, a new feature introduced in SQL Server 2012, is a unique table that reflects metadata of files in a specified folder. FileTables is a new feature introduced in SQL Server 2012. It's a ...