Power BI Functions, Data Integration, SQL Developer Tutorials and Standalone Python Application

Learn about new SQL Server topics from MSSQLTips.com [MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWS FROM MSSQLTips Learn something new every day! [mssqltips image]( [Scientific Calculations in Power BI]( In this article, we look at options to use scientific calculations in Power BI such as cube, square, logarithms, powers, inverse, and more.... [Read Now]( [mssqltips image]( [Salesforce and QuickBooks Integration to Snowflake with SSIS]( Learn how to use CData connectors to easily connect SSIS to Salesforce and QuickBooks Online then load the data into a Snowflake data warehouse.... [Read Now]( [mssqltips image]( [SQL Server Stored Procedure Tutorial]( This tutorial look at how to create stored procedures in SQL Server to be able to reuse the code for various purposes.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Troubleshoot and Tune Your Database Systems - SQL Server and DB2]( The DBI Web Performance Suite for SQL Server and DB2 is a database performance collection, analysis and recommendation tool to help you troubleshoot and tune your database systems.... [Read Now]( [mssqltips image]( [SQL Server Triggers Tutorial]( There is often the need to perform a database action in response to a specific event occurring. In this tutorial learn about SQL Server triggers and how these can be used to run additional code after an event occurs like inserting or changing data.... [Read Now]( [mssqltips image]( [SQL Server Best Practices for Data Quality]( Data Quality | SSIS Integration - Accurate data is imperative for an organization to conduct cost effective decision making. Like everything else, change is constant for your data. There is a need to cleanse and validate data when received and on a ... [Read Now]( ADDITIONAL RESOURCES ON MSSQLTips [mssqltips image]( [Simple script to backup all SQL Server databases]( In this article we look at how you can automatically backup all of your SQL Server databases with a couple of T-SQL commands.... [Read Now]( [mssqltips image]( [Creating a Standalone Executable Python Application]( In this article, learn how to build a standalone Python application without the need to have Python installed for the application user.... [Read Now]( [mssqltips image]( [DAX Rounding Functions for Power BI Reports]( In this article we look at various ways you can use DAX to round numbers for Power BI reports using round, rounddown, floor, trunc, mround, ceiling, roundup and iso.ceiling.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]