In this tip we look at various restore commands (RESTORE LABELONLY, RESTORE HEADERONLY, RESTORE FILELISTONLY) that can be used to reveal the contents of SQL Server backup files to help you with restore operations.
This article will help with gaining confidence and familiarity with Microsoft Azure's Data Lake Analytics offering to process large datasets quickly while demonstrating the potential and capabilities of U-SQL to aggregate and process big data files.
This tip compares SQL and R for performing multiple steps in a data science project from accessing a dataset, to performing exploratory data analysis, to computing a contingency table, to computing a Chi Square statistic.
Learn about the need for multithreading in .NET applications, especially for data applications and GUI environments. It is with multithreading that we avoid screen freezes when time-consuming processes are running in the background