Happy First Birthday to Power BI!

Happy Birthday to Power BI! Today marks one year since Power BI released to GA (general availability) on July 24, 2015. Since then, it has had an incredible impact on the industry and on many individuals, including me. I’ve spent nearly the entire year learning and improving my skills with Power BI, and have had the chance to…

0

Create your personalized Twitter Analytics Dashboard in Power BI in 10 minutes!

Create your own personalized Twitter Analytics Dashboard in Power BI When I do Tweet the most? What day and hour do my Tweets receive the most interactions and impressions? With Power BI, these questions are very simple to answer. In this blog, you’ll learn how to export your Twitter Analytics stats to use as a…

3

Power BI – Which data center hosts my data? Where is my data stored?

Power BI – Which data center currently hosts my data? Where is my data stored now? I was recently asked if it is possible to determine which data center hosts the data uploaded through Power BI. After a little searching, I found the answer below. Log in to www.powerbi.com Click on the ? (question mark)…

1

Power BI – Using Web Page Data Sources and “Publish to Web” to build and embed your personalized dashboard

Power BI – Using web pages as a Power BI data source to build your personalized MSDN/TechNet and PowerBI.com forum dashboard The following example shows how to leverage web pages as a Power BI data source and how to use the “publish to web” functionality to embed the dashboard into your blog (or other web site). In…

0

So long AdventureWorks, we’ll miss you! (And hello World Wide Importers!)

So long AdventureWorks, we’ll miss you! It’s the end of an era for the SQL Server sample database AdventureWorks as development has been suspended for the popular sample database following the release of SQL Server 2016. Many of us have used this sample database to learn constructs and features of the product since its introduction…

0

Refreshing KPIs in SSRS 2016

Refreshing KPIs in SSRS 2016   The introduction of KPIs in SQL Server Reporting Services 2016 gives us an ability to display key point indicators to allow for quick visual consumption of critical metrics. With the upcoming release of SSRS 2016, I spent some time diving into KPIs and found the default behavior for the…

7

Power BI & SSRS 2016 in an On-Premises Environment

Power BI and SQL Server Reporting Services 2016 in an entirely On-Premises Environment In my current role as a SQL Server and BI Premier Field Engineer, I support customers that are unable to move to Azure-based Power BI in the near term, so all of my current BI deliverables have a strict requirement to be wholly…

5

Querying SCCM – Finding Manufacturer Counts and Percentages

Lately I’ve been doing a lot of work with System Center Configuration Manager (SCCM) 2012 in terms of reporting and custom collections. As part of this, I’ve had the need to write this particular short query to retrieve manufacturer details several times, which seemed to make for a good target to share. Goal: Find the number…

0

Discovering SQL Server 2005 Instances by Querying System Center Configuration Manager (SCCM)

SQL Server 2005 extended support will end on April 12, 2016. After this date, Microsoft will no longer be releasing security updates for this product. In the article, we will query the System Center Configuration Manager (SCCM) 2012 database to obtain the number and editions of SQL Server 2005 instances that are installed, along with…

0

Auditing the usage of “EXECUTE AS” in a database

A question was recently asked in the MSDN Transact-SQL Forum about detecting the usage of “EXECUTE AS” in a specific database. https://social.msdn.microsoft.com/Forums/sqlserver/en-US/9a385b29-1181-47aa-9f80-062d1bed3cd4/remove-spaces-in-like-search?forum=transactsql The “EXECUTE AS” clause was introduced in SQL Server 2005 as a powerful execution context enhancement to grant permission to a function, stored procedure, or trigger, while maintaining strict control over permissions on…

0