Automating running PowerShell script which required Administrator elevation via SSIS
UPDATE (08 AUG 2016): I have updated this to use a SQL Server Agent Job instead of the Task Scheduler which proved to not be reliable. What we are going to explain below is the following via an example. Example – We are required to run a PowerShell script which will snapshot a database using Xtreme IO from EMC. In…
BI-NSIGHT – Power BI (New On-Premise Gateway, Data Stories Gallery, Embedded GA coming soon – Publish to Web GA, New Visuals,) – SQL Server (R Client, Migration Assistant for Datazen) – Excel (Faster Pivot Tables in Excel 2016) – Azure (Azure SQL Data Warehouse GA)
There sure has been a whole host of updates and additions in the world of BI in the past week. So here they are below. Power BI – New On-Premise Gateway This is another great update that I did not see coming. But it does make total sense. As well as great to have a single point in which you…
BI-NSIGHT – Power BI (Desktop Update – May, New Visuals, Gateway Enterprise Update, Azure ML Predictions, Planned Work started) – SQL Server 2016 (Generally Available, Mobile Report Publisher,SSMS
Here are the weekly BI Updates, with a lot of great things within Power BI as well as the major release for SQL Server 2016 Power BI – Desktop Update for May Well this week there is a whole stack of updates to the Power BI Desktop which once again is great to see so many updates and actual user…
BI-NSIGHT – Power BI (Publish in Web App, Enterprise Gateway GA, Desktop Update, Troux Content Pack, New Visuals) – SQL Server 2016 (CTP3.3, eBook, R)
So from last week to almost having nothing to talk about, to this week having a whole host of updates. Just to quickly mention I attended the first local Power BI User Group meeting in Brisbane this evening ( QLD Power BI User Group ), and it had a really great turnout, along with some great content for the first…
BI-NSIGHT – Power BI (IOS Power BI App for SSRS, Enterprise Gateway, Printing, AT Internet Content Pack) – SQL Server 2016 (eBook, Mobile Publisher)
The year is finally coming to a close and it has been a really busy but amazing year. I am looking forward to what will be happening in the Microsoft BI space next year, with the release of SQL Server 2016, as well as I have no doubt that there are a great things planned for Power BI. Power BI…
Power BI (Visual Contest, On the Go, Hyperlinks, Drill Up, Drill Down, tyGraph Content Pack) – SQL Server 2016 – CTP 2.3 (SSAS Tabular with a dose of speed, SQL Server Data Tools (SSDT), SQL Server Reporting Services (SSRS)) – Power BI (Personal Gateway for Power BI Update)
Right once again there is a lot to get into this week, and as with every week there are a whole host of Power BI updates. Power BI – Visual Contest I have to say that this is both a smart and fantastic move by Microsoft. This allows them to get or gain a whole host of new chart types…
BI-NSIGHT – Power BI Designer Refresh – SQL Plugin for Excel – SQL Server 2016 In Memory Tables – Azure SQL Data Warehouse – Office 2016 Update – Power BI Content Pack (UserVoice)
Another week has gone by, so let’s get into what is currently out there and happening in the BI world. Power BI Designer Refresh I do know that this came out last week, but I still wanted to comment on this. Once again this is something that customers and myself have been waiting to be implemented and asked for on…
For SQL Server 2014 – Use the following link below to use an oData Source to get data from SharePoint List into your table
Below are the steps if you want to use SQL Server 2014 to get data from a SharePoint list into your database. The URL below explains how to download and install the OData Source for SQL Server 1. Click on the following link below a. http://www.microsoft.com/en-us/download/details.aspx?id=42295 2. Then once you load the page click on Download a. This will then…
SQL Server 2014 Observations
Today’s post is not going to be about explaining something but more along the lines of my experience on SQL Server 2014. When I heard about all the new features in SQL Server 2014, the In Memory Tables, new cardinality estimator, new changes to how TempDB works, SSIS and Delayed Durability, I was excited to see how I could use…