Another year passes. I was hoping to write more articles instead of just these end-of-the-year screeds, but I almost died in the spring semester, and it sucked up my time. Nevertheless, I will go ...

If you want to be a true spreadsheet power user, you need to learn about the Power Query and Power Pivot features in Excel. While you can get a lot done with Excel alone, using these built-in “Power” ...

The SQL Server Import and Export Wizard is a tool that allows you to copy data from a source to a destination. This document describes how to use the SQL Server Import and Export Wizard if a source ...

DevOps is now the most prevalent software development methodology in use. Since 2009, it has spread beyond development teams into other functional areas. One of the earlier DevOps extensions was into ...

On August 22, 2012, the Russian Federation officially joined the World Trade Organization (WTO) after almost 18 years of negotiations. A mere month later Russian leadership was declaring that trade ...

Please note: This item is from our archives and was published in 2018. It is provided for historical reference. The content may be out of date and links may no longer function. Because the field names ...

This topic provides an overview for using the bcp utility to export data from anywhere in a [!INCLUDEssNoVersion] database where a SELECT statement works, including partitioned views. The bcp utility ...