LinkedIn

Row-Based Storage vs Columnar Storage: SQL Server Tables vs Parquet Files

Row-Based Storage vs Columnar Storage: SQL Server Tables vs Parquet Files is one of those topics that sounds academic until it slows a report, inflates storage costs, or blocks a data project. The ...
GitHub

SQL Server Metadata Toolkit

MSDN's SQL 2005 tool kit updated to 2008, 2012, 2014, 2016, 2017, 2019 and 2022 for detecting metadata in SQL Server, SSIS, SSRS and SSAS. This project is an update on the project released on MSDN ...
IEEE

Performance analysis of SQL Prepared Statements in CRUD operations

Abstract: In a web application, communication between the application and the database server is one of the most resource intensive operations which therefore requires optimization. Database ...
GitHub

A tool to easily and quickly mutate your INSERT SQL statements. For when you need to migrate tens of thousands of rows from one table to another by hand.

A tool to easily and quickly mutate your INSERT SQL statements. For when you need to migrate tens of thousands of rows from one table to another by hand. - dsone/quedit ...
LinkedIn

SSIS : Fetch And Import Excel Files with Dynamic Name , File Extension From Ftp Server to Sql Server with various Schema , Table Name and Columns .

3. Excel files must be store in various sql tables with various schema and columns. So I did it like this by ssis : It’s our ingredients for cooking : Sql Server 2012 or above. SSDT 2012 or above.
The Irish Times

11th-hour rush into new SSIS accounts

Up to 25,000 new Special Savings Incentive Scheme accounts have been opened each day since the beginning of the month in a last minute rush by savers to take advantage of the free €1 for every €4 ...