Referential Integrity Across Databases, Data Masking, Cloud Costs, Indexing and more tips

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]( [Control Referential Integrity Across SQL Server Databases]( Learn how to control referential integrity from parent table for tables that reside in different SQL Server databases on the same server.... [Read Now]( [mssqltips image]( [Seamless Monitoring and Reporting for SQL Server]( SolarWinds SAM provides a one-stop method to easily and seamlessly implement a top tier monitoring and reporting system for your SQL Servers and entire infrastructure.... [Read Now]( [mssqltips image]( [Identify the Most Current Record in a Power BI Report]( Learn how to identify the most current record from a historical dataset for a Power BI report in this step-by-step guide.... [Read Now]( RECOMMENDED READING ON MSSQLTips [mssqltips image]( [Reduce your SQL Server Costs in the Cloud]( Customers have increasing demand to optimize SQL Server costs in the cloud and in this webinar we will look at how AWS Compute Optimizer provides proactive cost optimization recommendations while still providing the needed resources for your database... [Read Now]( [mssqltips image]( [REPLACE versus TRANSLATE for SQL Server Text Data Manipulation]( Learn how to replace text in SQL Server strings using the REPLACE and TRANSLATE functions and how these could be used for data manipulation.... [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]( [SQL Server Indexes to Improve Query Performance]( In this article, we look at how to design SQL Server indexes and why the way an index is created makes a difference in query performance.... [Read Now]( [mssqltips image]( [SQL Server Data Masking Simplified]( Data breaches are becoming too common place with some accounts reporting more than 1000 breaches per year with close to 50 million records exposed yearly in the financial, business, education, government and healthcare industries. Learn about how Db... [Read Now]( [mssqltips image]( [Power BI Report Automation]( In this article we look at how to get Power BI to Auto-Create a report for your based on data input or copied into a new dataset.... [Read Now]( [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL} [tag]