SQL Server - How to import text files into the database (OLE Automation, CLR, BCP, BULK INSERT, OPENROWSET) May 29, 2016 7 min read Continue reading
SQL Server - Error Using OPENROWSET: Access to the Remote Server Is Denied Because No Login-Mapping Exists May 28, 2016 3 min read Continue reading
SQL Server - Cannot resolve the collation conflict between ... in the equal to operation. May 25, 2016 6 min read Continue reading
SQL Server - How to resolve the Warning Null value is eliminated by an aggregate or other SET operation May 22, 2016 2 min read Continue reading
SQL Server - Heterogeneous Queries Require the ANSI_NULLS and ANSI_WARNINGS Options to Be Set for the Connection May 22, 2016 3 min read Continue reading
Analysis Services - Deserialization Failure: The 'AllowedRowsExpression' element in namespace May 9, 2016 1 min read Continue reading
SQL Server - How to list, read, write, copy, delete and move files with CLR (C#) May 7, 2016 11 min read Continue reading
SQL Server - How to perform UPDATE and DELETE with TOP x records May 7, 2016 2 min read Continue reading
