Power BI vs Tableau, Snowflake Constraints, SQL Query Analysis and Filter Hive Tables (MSSQLTips 12/7/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQLGrease - Built by Performance Experts, Not Elves]( [Comparing Power BI vs Tableau as Data Visualization Tools]( [Comparing Power BI vs Tableau as Data Visualization Tools]( In this article, we do a comparison of Power BI and Tableau, and which tool may be a better choice for your report and dashboard development.... [Learn Snowflake Constraints Primary Key, Unique Key, Foreign Key and Not Null ]( [Learn Snowflake Constraints Primary Key, Unique Key, Foreign Key and Not Null]( In this article, we look at constraints in Snowflake such as PRIMARY KEY, UNIQUE KEY, FOREIGN KEY, and NOT NULL and how they are enforced in Snowflake.... [SQLGrease Does What Santa Can't]( [SQLGrease Does What Santa Can't]( SQLGrease greatly simplifies finding the root cause of performance problems. Try SQLGrease free to see how it can help you track down the most difficult performance problems....... [Filtering and Aggregating Hive Tables with Spark SQL]( [Filtering and Aggregating Hive Tables with Spark SQL]( Learn how to use the Apache Spark ecosystem to filter and/or aggregate data stored in hive tables....... [Deep SQL Query Analysis and Tuning]( [Deep SQL Query Analysis and Tuning]( Learn how to conduct deep SQL Query optimization with SQL Grease with the Enterprise dashboard, historical data, troubleshooting SQL Server Wait Stats, capturing anomalies and intelligent notifications....... [SQL SELECT DISTINCT Examples]( [SQL SELECT DISTINCT Examples]( In this article we look at how to retrieve a list of distinct datasets from SQL Server without repeating information using the DISTINCT clause....... [Improve the Data Quality for Healthcare, Clinical and Life Sciences Projects]( [Improve the Data Quality for Healthcare, Clinical and Life Sciences Projects]( All companies fundamentally have the need to improve data quality for decision making. For healthcare, clinical and life sciences organizations, merging, reconciling and enhancing data is challenging for electronic medical records, clinical trials an...... [Calculating MTD, QTD, YTD, Running and Cumulative Total in Power BI]( [Calculating MTD, QTD, YTD, Running and Cumulative Total in Power BI]( In this tip we cover how to calculate MTD, QTD, YTD and Running Total in Power BI....... [How to Monitor Storage Performance with a Single Application]( [How to Monitor Storage Performance with a Single Application]( Learn about storage monitoring and storage performance for your SQL Server environment with Storage Resource Monitor....... [By Greg Robidoux - ]( [How to determine SQL Server database transaction log usage]( In this article we look at how to tell what parts of a database transaction log are being used.... [By Tim Ford - ]( [Run same command on all SQL Server databases without cursors]( In this article we cover how to run the same command against all SQL Server databases using sp_MSforeachdb along with several examples of how to use it.... [By Bhavesh Patel - ]( [Import Text and CSV Files into SQL Server Database with SSIS Script Task]( In this tip we look at how to import text files and CSV files into SQL Server using SSIS and the Script Task.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}