Jul 18, 2019 | How To, PowerShell, System Administration, Technical Information
By: Matt Wisor PowerShell to the Rescue Carrying out server maintenance on a regular basis can be challenging, especially if users are working in the application being serviced. Applying a Visual Studio update, for example, may corrupt the application if...
Jun 18, 2019 | How To, Microsoft Power BI, PowerShell
By: Mike Pierre-Louis Microsoft has made Power BI even more powerful with its latest round of updates. Whether you are an admin or a user, the software’s new benefits are for everyone to enjoy. One of the main hurdles Power BI users had to overcome...
Apr 10, 2019 | Business Intelligence, Data Visualization, How To, PowerShell, Tech Tips, Technical Information
By: Mason Prewett Introduction As an admin of many server types, I often encounter the issue of a machine running out of disk space. Tracking the culprit folder that was hogging up disk space used to be a troublesome, manual effort. However, I recently coded a...
Dec 12, 2018 | Business Intelligence, Custom Development, Data Visualization, Microsoft, Microsoft Power BI, PowerShell
By: Phillip Sharpless Introduction Microsoft’s Power BI provides a robust set of built-in visuals for displaying data in your reports and dashboards. However, no matter how many visuals are built in (or how flexible they may be) there may come a time...
Nov 12, 2018 | PowerShell, SQL Server, Tech Tips, Technical Information
By: Mason Prewett This article is Part 2 of our previous Key2 article, How to Execute and Store Transact-SQL (T-SQL) Query Results in a PowerShell Array. In this article, I will cover: Getting a SQL Server result set from a stored procedure The stored procedure has a...
Aug 21, 2018 | Data Warehousing, How To, Key2 Stories, Microsoft, PowerShell, SQL Server, SSIS, Tech Tips, Technical Information
By: Ken Adams Introduction Disclaimer: Microsoft introduced the project deployment model for Integration Services (SSIS) over 6 years ago with SQL Server 2012. At this point in time, it is likely that you know a lot about project deployment. This post will...
