SSRS IIF, Switch and Choose Functions for Dynamic and Appealing Reports
Learn how to use IIF, Switch and Choose logical functions in SSRS reports to make your reports more dynamic and more appealing to report users.
2021-10-13
reporting
Power BI for Business Intelligence
Power BI is becoming widely used for reporting and data analysis. There are many different versions of Power BI and the features that are offered and this article provides an overview of what is available.
2021-04-30
Power BI Introduction: Publishing Reports to the Power BI Service — Part 8
Power BI Desktop is typically used to create reports that will eventually be published to Power BI Services where dashboards can be built. Robert Sheldon demonstrates how to publish reports from Power BI Desktop to the Power BI Service. Once published, the visualizations can be filtered, drilled into, or pinned to a dashboard.
2018-10-08
3,198 reads
Azure Data Warehouse 7: Create reports in Azure SQL DWH using SSRSS
In this article, we will show how to create reports in ASDW using SSRS
2017-03-27
1,377 reads
The SQL Server 2016 Query Store: Built-in Reporting
One of the most important features of the SQL Server 2016's new Query Store is the reporting. With these features, it is now possible to get a wealth of information on how your query workload is performing, either aggregated for the entire query workload or for a single query. With this information, you can see the effects of 'forcing' an execution plan for specific queries and get feedback of the consequences.
2016-03-03
3,901 reads
The SQL Server 2016 Query Store: Built-in Reporting
One of the most important features of the SQL Server 2016's new Query Store is the reporting. With these features, it is now possible to get a wealth of information on how your query workload is performing, either aggregated for the entire query workload or for a single query. With this information, you can see the effects of 'forcing' an execution plan for specific queries and get feedback of the consequences.
2016-01-29
4,359 reads
Top 10 MySQL Reporting Tools
Both management and various departments rely on data reports to help guide their business decisions. Rob Gravelle presents ten open source and commercial report generation tools for MySQL and other relational databases.
2016-01-11
4,964 reads
Calendar Table by Year
Populate a calendar table with user set interval start and end datetime values.
2014-03-11 (first published: 2014-02-21)
1,312 reads
Calendar Table by Month
Populate a calendar table with user set interval start and end datetime values.
2014-09-16 (first published: 2014-02-21)
1,993 reads
Calendar Table by Day
Populate a calendar table with user set interval start and end datetime values.
2014-09-15 (first published: 2014-02-21)
1,959 reads
Blogs
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
EightKB 2024 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory
By Steve Jones
I had a customer that was looking to document a restore that had occurred...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers