Getting data out of a Database hasn’t been easier these days. Giving all the tools you have at your disposal…
Giving the fact that all the fuss about BI and Cloud Storage, Big Data etc. We seem to loose feeling with all the o
Here are a few examples we can use for simple and complex query and reporting purposes.
1. Query using the MS SQL SSMS
It’s obvious that SQL SSMS offers all the functionality you need to get the data out of the database.
This example shows a combination of Common Table Expression (CTE) Query combined with the PIVOT function, to generate you dataset.
2. Using PowerShell – Query
Re-using this quite complex Query using Scripting language is quite Powerful.
3. Excel – Query
Using Excel combined with MS Query we can re-use the same Query
4. Access – Pass-Through Query
Re-using the complex query using MS Access in a Pass-Through Query Statement.
5. MS SQL Reporting Services
Re-using the complex query using MS SQL Reporting Services & Report Builder
6. MS PowerPivot – Excel Addin
Re-using the complex query using MS Power Pivot – Addin
7. MS Power BI
Re-using the complex query using MS Power BI
This is not a limit list of tools you have a hand. There many more which you might overlook …
– QlikView Client
– MS Power Query
For getting data out of a database you need to the proper tools, but this is not a constraint at the moment.
What is, is being able to manage all these different applications and technologies.
Bottom-line is that one you spend efforts in getting your queries right you can re-use them most any tool that comes around