My online presences include: Tech Blog: Marlon Ribunal - SQL, Code, Coffee, etc. Productivity & GTD Hack Blog: Productivity Bits Twitter: @MarlonRibunal
Update: Just getting started with Power BI? You can download the Power BI Report File for this KPI Report. Please find the link at the end of this post. The Power BI KPI report is probably on top 10 of … Continue reading
Update: For the KPI version of this report, please check Power BI KPI Report: Hospital Charge Data How much hospitals charge for the same type of cases compared with the average across the US and other cities around the world … Continue reading
Microsoft R Server, or Revolution R Enterprise (RRE) as it is formally known, for now, is basically a platform for advanced analytics designed to tackle big data statistics, predictive modeling, and machine-learning capabilities. The open source R is limited in … Continue reading
This is the third installment of our Getting Started With Power BI Desktop series. The first post is about installation and the second is about getting data. In this post, let’s see how easy it is to create visualization on … Continue reading
Now that the Power BI Desktop is installed, let’s get some data. As of this writing, Power BI can get data from 37 different data sources and data connections – File (Excel, CSV, XML, Text), Database (SQL Server, Oracle, IBM … Continue reading
Power BI is becoming popular for a lot of reasons. Simply put, Power BI is “BI on your fingertips.” Companies looking to adopt BI technology need not look further. Power BI is easy to learn with its intuitive tools. Gone are the days when building BI solutions always involve massive… Read more
Here’s a quick how-to on returning temporal data set that includes missing dates. Suppose you are tasked to query an employee’s “time sheet”. You’d want to return not only the days he’s reported to work but also all the days that he missed.
The expected result would look something like… Read more
Beginning in version 2005, SQL Server is making manipulation of partitioned set of rows easier by using Window Functions (ROW_NUMBER(), aggregate functions with OVER(), etc.). You can manipulate partitions of rows on the fly with Window Functions.
I’ve seen how complicated queries that require recursion were simplified by using combination… Read more
I committed to studying for MCSA SQL Server 2012 and taking the certification exams by the end of the year…last year. That didn’t happen. At the start of this year, I made that same commitment again. Neither did that happen. At that time, I told myself there’s still a lot… Read more
Central Management Server and server groups provide a convenient way to manage multiple servers and databases in one place and at the same time.You can register and manage any servers but only those in SQL Server versions 2008 and higher can be designated as Central Management Server. You can execute… Read more
I rebuilt my Hyper-V virtual machines / virtual network by deleting the old ones and building new machines on a portable external hard drive. So after a while of not starting up the host laptop, I could not start any of the machines. First, I noticed that the state… Read more
Few blog posts ago, I decided to build a virtual environment for a personal SQL Server sandbox. So, the Virtual SQL Playground Adventure blog series came to life.
In the introduction I promised to document everything but did not do a follow up blog post after that. That doesn’t mean… Read more
Building a reporting system from the ground up is a daunting task. Such a big project usually involves intricate resource movement. Reporting is an important component of Business Intelligence (BI). Therefore, perceptive implementation options of the reporting portion should be considered. Data analysis and integration become pointless if they lack… Read more
Packt Publishing has published SQL Server 2012 Reporting Services Blueprints – the book that Mickey Stuewe (b | t) and I have been collaborating on for months. Packt has published this title under their Blueprints Series.
What exactly is a Packt Blueprints Book?
“Blueprints are basically in… Read more
Welcome to the Virtual SQL Playground Adventure! Why Adventure? What’s an Adventure?
An adventure is an exciting or unusual experience; it may also be a bold, usually risky undertaking, with an uncertain outcome.
That is exactly what this series is all about. I can’t tell you how… Read more
The Windows 8 and Windows Server 2012 SP1 Virtual Machines on my laptop are connecting just fine to my physical network adapter (wifi) via the External Virtual Switch that I setup in Hyper-V (Windows 8 Pro host). I can connect to the internet to do Windows updates on those VM’s. Read more
How many lines of TSQL codes and Window Functions you need to come up with this?
R, it takes about 2 commands:
> order <- as.matrix(sqlFetch(ch,"SalesDetails") > summary(order)
To give you an idea, I prepared the dataset into a view like this:
CREATE VIEW SalesDetails AS SELECT soh.OrderDate…
I’ve got plenty of SQL Server books at home (physical and Kindle versions). But if I’m not in the mood of reading a tech book but itching to read anyway, I’d… Read more
Joe Lacob bought the struggling Golden State Warriors NBA franchise in 2010. He has been the most hated man by the Warriors fan base since then.
Lacob promised the fans he would turn the franchise around and get it back to the winning edge.
To set the wheels in motion,… Read more
I’ve been looking for better ways of learning and improving my SQL Server skills. Blogs, BOL, webcasts, and training videos are great learning aids. Having the right tools and method makes a lot of difference. Building a SQL Server VM Playground to put the lessons in practice is a vital… Read more