Powershell

Get All Endpoints for VMs in an Azure Subscription

by

I wrote a post recently about troubleshooting connectivity for endpoints on Microsoft Azure VMs. The day the post went out I was greeted with this tweet: http://t.co/Ww3MyYjwPu right on time context post for me @SQLRockstar tx sir. Need to see on ports for my #linux vms with #mysql running 🙂 — Shyam Viking (@myluvsql) April 30, … Read more

Troubleshooting Azure Connectivity: Ports and Endpoints

by
can't connect to remote computer

It was a simple enough question, or so I thought. One I felt should be either a simple “yes” or “no”. “Do we block remote desktop connections here?” Sure enough, I got back the quick and simple answer I expected, along with a question for myself. “Nope. We don’t block any RDP sessions. Maybe you … Read more

HOW TO: Recycle the SQL Server Analysis Services msmdsrv.log File

by

I found this question over at DBA StackExchange the other day and it left me shaking my head. How is it possible that there is no way to automatically recycle, or reset, the SQL Server Analysis Services (SSAS) error log in a similar manner to SQL Server? After all, it’s not like the technology doesn’t … Read more

Administering SQL Server 2012 Running On Windows Server Core

by

Are you afraid of deploying (or supporting) an instance of Windows Server Core? Are you telling others to “stay away” because of your own fears of doing something new? Then I am here to tell you that you’re doing it wrong. Last month I decided that it was time to get down and dirty with … Read more

HOW TO: Output STATISTICS IO Details Using Powershell

by

Recently I found myself looking to automate a process that would connect to a database server and run a bunch of queries and return the results of SET STATISTICS IO for each one. I could certainly load my scripts into SSMS and output the results to a text file, but I wanted to leverage Powershell … Read more

+ More