In the following article we will go through a solution to a very common requirement of getting Nth record in a SQL server table. Let us first create a table and add sample data to this table. Col1 in ...

In the following article we will go through a solution to a very common requirement of removing delete duplicate rows from SQL server table. Let us first create a table and add sample data to this ...

SQL Bulk Insert has been tuned over the years to work well with the Microsoft .NET Framework. This tutorial shows you how to take advantage of its power. SQL Bulk Insert is not a new technology. In ...

Though businesses typically use Microsoft's SQL Server for mundane items such as customer names, addresses and sales amounts, you can also store entire PDFs in a database record. Data items called ...

I am quite new to Azure Data Lake and U-SQL and have worked with SQL earlier. I am facing the following issue while trying to migrate a SQL application to cloud. I ...