Featured Database Articles
Arshad Ali demonstrates how to use Analysis Services connector to interactively query your on-premise data from an Analysis Services instance in Power BI reports or dashboards.
The Power BI Designer was recently added under the Microsoft Power BI umbrella. Power BI Designer quickly builds reports or dashboards locally and deploys them to the Power BI site. In this article, Arshad Ali demonstrates how to get started with Power BI Designer.
In recent articles we have been discussing how to streamline deployment of SQL Server 2014 Azure Infrastructure-as-a-Service (IaaS) virtual machines, without relying on Gallery images. In this article we capture all of the steps in the form of a single PowerShell script that can be executed remotely.
Over the years Oracle backup and recovery has changed significantly, from manual backups to the most recent version of RMAN. Read on to see where we were and where we are now.
Monitoring tablespace space is a constant, yet necessary, task. It's changed over the years and releases, so read on to see how it used to be done and what new views are available to make the task easier.
According to Jonathan Lewis: "Stoptimisation - the art of optimization by not doing the things you don't need to do." Read on to see what things you may be doing that you shouldn't be doing.
In many cases, the success of a big data application can be traced to how well it is integrated into your enterprise data warehouse. This article presents several ways to get this done quickly and efficiently from the beginning.
Today, everyone realizes that in order to reach their full performance potential, Big Data applications require some tuning. The tuning isn't easy, it's not free, and responsibility for understanding requirements and implementing the appropriate tuning methodology falls squarely on the shoulders of the database administrator. Read on to learn more.
Big data applications are not usually considered mission-critical: while they support sales and marketing decisions, they do not significantly affect core operations such as customer accounts, orders, inventory, and shipping. Why, then, are major IT organizations moving quickly to incorporating big data in their disaster recovery plans?