Sponsored Post Learn from the experts: Create a successful blog with our brand new courseThe WordPress.com Blog

Are you new to blogging, and do you want step-by-step guidance on how to publish and grow your blog? Learn more about our new Blogging for Beginners course and get 50% off through December 10th.

SQL Server Connection Manager – Cannot connect to WMI provider

You need to access configuration manager of your SQL server and as you double click on the icon, you are greeted with SQL Server Connection Manager - Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with … Continue reading SQL Server Connection Manager – Cannot connect to WMI provider

How to get SQL Server output in text tab delimited using PowerShell

This is very straight forward topic. May not be relevant to most people. I was tasked to do something similar recently. I automated that tedious task using PowerShell Script $hostname = hostname $filepath = 'C:\Users\xxxxx\Desktop\script_auto_text_delimiter\input\' $file = Get-ChildItem -Path $filepath | select name |where-object name -NotMatch '_output.txt' $scripts = $file.name ForEach ($script in $scripts){ $sqlfile … Continue reading How to get SQL Server output in text tab delimited using PowerShell