SQL Server - File Operations Using xp_cmdshell: How to List, Read, Write, Copy, Delete and Move Files August 29, 2017 6 min read Continue reading
SQL Server - How to query Active Directory (AD) information using Linked Server (ADSI) August 23, 2017 5 min read Continue reading
SQL Server - How to recover the source code of an encrypted object (WITH ENCRYPTION) August 22, 2017 8 min read Continue reading
SQL Server - How to identify occurrences of a specific character in a string or table August 15, 2017 6 min read Continue reading
SQL Server - How to convert an RTF string to text (Remove RTF tags) using CLR (C#) or PowerShell August 8, 2017 8 min read Continue reading
SQL Server - How to convert an HTML string to text (Remove HTML tags) using CLR (C#) August 8, 2017 3 min read Continue reading
Analysis Services - How to Use XMLA or PowerShell to Process Cubes and Dimensions via T-SQL or SQL Agent Job August 6, 2017 10 min read Continue reading
