Business intelligence and data warehousing tips and trends for database administrators
Load tests give the database administrator (DBA) quite a lot of valuable information and may make the difference between poor and acceptable application performance. But what about a big data environment? Are there any gotchas or traps associated with big data?
While using a custom SSIS-based project to upload content of an arbitrarily chosen table from an on-premise SQL Server database to Azure PaaS-based SQL Database provides the most flexibility its inherent complexity might not be justified in more simplistic scenarios. Marcin Policht presents an alternative approach that addresses this concern by employing the bcp utility, which not only eliminates the need for any custom development, but also rivals SSIS in terms of its data transfer efficiency.
Power Map is an Excel add-in under the Microsoft Power BI umbrella that extends the capability of Power View by enabling end users to visualize data in a 3D visualization format. Arshad Ali shows you how to install it and how to get started using it.
Power Query, provided as part of the Microsoft Power BI self-service solution, is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Read on to learn how to install and get started using it.
Microsoft Power BI is a cloud based self-service Business Intelligence solution that you can use in Excel for all your data needs. It includes different tools for data discovery, analysis and visualization. Read on to learn more about Microsoft Power BI, the different tools under the Microsoft Power BI umbrella, and when each of them can be used.
NEWS ANALYSIS: Enterprise data architects are turning their attention to developing hybrid databases that can process structured and unstructured inputs for big data analytics.
NoSQL isn't just for big servers anymore, as Couchbase Lite brings open-source database technology to the mobile form factor.
Open Source database scales up and set a course forward for an lightweight embeddable database.
SQL etc Archives