SQL Server DBA, BI Analyst and Microsoft MVP

Categories

PowerShell / CMD

10 posts

Azure Data Factory (ADF) - How to Create Offline Documentation (in CSV) for Your Project

October 3, 2021 10 min read

Continue reading

Powershell - Script to list and export to CSV all files in a directory with name, directory, size, and duration attributes

June 14, 2021 2 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

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

SQL Server - How to back up all SQL Agent jobs via command line (CLR C# or PowerShell)

February 22, 2017 9 min read

Continue reading

How to use the Pushbullet API to send SMS messages in C#, PHP, Java or through SQL Server (with CLR)

September 11, 2016 9 min read

Continue reading

SQL Server - How to list and kill Windows processes using CLR (C#)

September 11, 2016 5 min read

Continue reading

SQL Server - How to run PowerShell and Prompt-DOS (MS-DOS) scripts using CLR (C#)

September 11, 2016 6 min read

Continue reading

How to Compress Directories into ZIP Files Using 7-Zip and CMD

August 6, 2016 2 min read

Continue reading

SQL Server - How to batch run all .sql scripts from a folder or directory with SQLCMD

June 14, 2016 3 min read

Continue reading