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...
Jun 26, 2018 | How To, Microsoft, PowerShell, SharePoint, SQL Server, Tech Tips, Technical Information
By: Mason Prewett This article covers a Key2 client’s upgrade to SQL 2016 of a SQL Server Reporting Services instance in SharePoint Integrated Mode (in a SharePoint 2013 environment). You can follow the information in this article to conduct your own...
Sep 12, 2017 | PowerShell, SQL Server, Technical Information
By: Jharred R. Williams A brief intro of Windows PowerShell • Windows Powershell is a task automation framework used for its ease of use when compared to building full blown executables. • With a command line shell that is almost identical to a...
