SQL script to copy stock quotes in .csv files into a SQL server database These scripts can be used to import stock quote information that is downloaded in .csv format from Yahoo Finance into SQL ...

Update the appsettings.json file with the location of the SQL script to read in and execute Set the options as required (Continue on Error, split the file up etc [Note that spliting the file is ...

Many books, blogs, and articles on using Groovy with Windows rightly point out that some of the commonly used commands in Windows are not actually executables, but are instead built-in commands. These ...

The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...

Microsoft SQL Server 2014 brings new performance and scalability gains by introducing In-Memory OLTP. In-Memory OLTP contains tables and indexes optimized for in memory. Transactions execute under ...

A common practice on-premise to improve the performance of SQL Server workloads is storing TempDB and/or Buffer Pool Extensions (SQL Server 2014) on SSDs. The former improves the performance of ...