This method is so discouraged that Microsoft is not including it in SQL Server 2008 and future versions of the product. I’ll include the syntax here to be thorough, but you should try to avoid ...

In SQL Server 2008 R2 you can set up a Utility Control Point and monitor both solutions to see which one performs best with your data. That will give me something tangible to test using this new ...

In this post, I’ve demonstrated how we can work with the Microsoft SQL Server sink. I’ll discuss other advanced features of Serilog in a future post here.

Let's look at an example. Fig. 1 shows a simple data flow that loads data from a flat file, called NewStores.txt, to a table in SQL Server called Stores_Staging. Fig. 2.

Information in this article applies to Microsoft SQL Server 2012. The instructions for earlier versions of SQL Server, including versions 2008 and 2005, are similar.

Also interesting is a new pay-as-you-go billing model for SQL server through Azure Arc, Microsoft’s platform for managing cloud and on-premises resources. Using a connection to Azure Arc, which ...