powershell
Get element max value from folder with XML files
Ever had a folder with a bunch of XML documents that you needed to query? Read on to see how you can extract values from those XML documents using PowerShell.
windows
From SQL Server to MSMQ using PowerShell
How do you get records from a SQL Server table into a MSMQ queue as separate XML messages?
A commonly suggested way to communicate with MSMQ from within SQL Server is to create a CLR assembly. See for instance this article that has a great coverage of how to use CLR in this scenario. Note however that you have to import the System.Messaging.dll as unsafe for this to work. And you have to enable CLR obviously.
If this is not an option, another way to do it is to use PowerShell. Which is what I will cover in this demonstration.
Toggl Time entries to SQL Server
Toggl is a very simple to use cloud based time tracking application. Time entries on projects and clients can be submitted through the web page or through mobile and desktop applications. Time spent by the team can be viewed in the different reports that can be accessed via their web page. There is a free version that handles much of the time tracking needs, and there are more advanced paid versions as well.
If you want to integrate the information stored at Toggl with your own enviromnent, you can use their API. One way is to download time entries to your own SQL Server database, which is the method I’ll present here.
PowerShell
From PowerShell to SQL Server tables
Some of the output from PowerShell cmdlets return results that can be represented as tables. So how can these results be stored in SQL Server tables?