Learn about how selecting a SQL Server index fill factor can impact storage and performance. Check out the included scripts to help give you better insight.
In this tip we look at other approaches you can take to improve bulk loading of data into SQL Server to reduce contention and avoiding expensive hardware changes or a moving to the Enterprise edition.
Learn how to remove the filestream feature from a SQL Server database. In this tip we cover an example as well as the scripts to use to remove filestream attributes from a database.
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.
In this tip we look at how to setup an Azure Storage Account and then how to write a SQL Server backup to this storage and also how to restore a database from this storage.
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.
In this tip we look at some approaches and queries you can use to log error messages and then use these scripts to find and send custom notifications based on the errors.
In this tip we have a PowerShell script that can be used to check the status of SQL Server database mirroring as well as generate the code need for a failover of the databases.
In this tip we will use Azure Logic Apps to fetch files from SharePoint, dump them into Azure Blob Storage and then copy the data into the database using the Copy Activity in ADF.
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 the top reasons why candidates are put off during the interview process, as well as some tips to mitigate this happening to you and your organization.
In the first part of this tip we created a new virtual machine using Oracle VirtualBox with Red Hat Linux installed. In this tip we will install SQL Server 2017 and SQL Server Agent.
In this tip we look at how to setup a virtual machine using Oracle VirtualBox and install Red Hat Linux to prepare a machine for the next tip where we will install SQL Server 2017 on Linux.
Learn how to write T-SQL code to make DMV queries backwards compatible. This way you can have one set of code that can work with all of your different versions of SQL Server that you support.
In this tip we will walk through how to create a PowerShell module to get a list of files and subfolders of a Windows folder and store this information in a SQL Server table.
In this article I will create a solution which will join files that reside in Azure Data Lake Store Azure with Azure SQL DB Data using federated U-SQL queries in Azure Data Lake analytics.
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