SSIS is a popular and mature tool for performing data movement and cleanup operations. In the Microsoft ecosystem, SSIS is one of the most common extract, load, and transform (ETL) tools in use today.

I've been working with SQL Server for over 20 years now, Generally, I limit my tools to the things I might expect to find in a given client environment. My toolbox typically includes the tools that ...

Step-By-Step: Learn the basics of using DTS in Microsoft SQL Server Your email has been sent Learn how Data Transformation Services (DTS) can help you import, export, and/or transform data from ...

If you use SQL in your be nimble, you have several options easy to complete to, ranging from enterprise options to the manageable SQL Server Express. Monitoring SQL queries are just one of the many ...

Microsoft is getting really serious about giving customers choices. That much was clear at this week's combined Microsoft Ignite and Envision events in Orlando and, in particular, in announcements ...

As developers look to harness the power of AI in their applications, one of the most exciting advancements is the ability to enrich existing databases with semantic understanding through vector search ...

Microsoft is making available on July 17 its first near-final public Release Candidate of SQL Server 2017. SQL Server 2017 is the first version of Microsoft's SQL Server database that will run on both ...

The daily routine of an IT professional remains largely reactive. A lot of time and budget is spent responding to tickets, limiting the time that we spend creating systems that drive growth and ...

The latest SQL Server comes packed with support for Linux, automatic tuning and other enhancements that will enhance and simplify the use of the database platform. Today at the Microsoft Ignite ...