Using Power Pivot can provide insight into your data from sales to system monitoring. Your users can use Power Pivot to quickly create dashboard-like reports that show trending on your data over time. Additionally, with the use of KPIs (Key…
SQL Server Management Studio
Cannot Show Requested Dialog Error – SQL Server Management Studio
by Alan Faulkner • • 0 Comments
Problem After a recent installation of SQL Server 2012, I encountered an error I haven’t run into before. The error “Cannot show requested dialog.” Cause When you check database properties (in my case SSAS Mutlidimensional instance), SSMS runs queries against…
Business Intelligence, SSAS Tabular
Installing SQL Server 2012 SSAS Tabular Mode
by Alan Faulkner • • 0 Comments
In this post we will cover the step-by-step process to install SQL Server 2012 Analysis Services in Tabular Mode. This post assumes that you have already gone through the process of installing a SQL Server 2012 Analysis Services multi-dimensional instance.…
PL SQL vs T-SQL
Date Math – Oracle vs. SQL Server
by Alan Faulkner • • 0 Comments
Series of posts dedicated to comparing the similarities and differences between PL SQL and T-SQL on the subject of Date Math calculations. Unlike the rules of FIGHT CLUB, we will be talking about MATH CLUB. This post is provided in…
Posts
Hello world!
by Alan Faulkner • • 0 Comments
Welcome to FalconTek Solutions SQL. This is a BLOG site that will be dedicated to SQL Server Business Intelligence Solutions. The site is currently under construction, but please check back periodically to see the latest posts!