Week in Review + Power BI Best Practices, Be an ACE DBA and DBMS Job Schedulers (MSSQLTips 8/22/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server Performance Monitoring and Tuning Tutorial - Improve Performance Now]( [Development Best Practices for Power BI]( [Development Best Practices for Power BI]( As the use of Power BI continues to grow it is helpful to learn and use best practices. Check out this article to learn some best practices when working with Power BI.... [SQL Server, Oracle and PostgreSQL Job Schedulers]( [SQL Server, Oracle and PostgreSQL Job Schedulers]( Learn how to schedule tasks in SQL Server, Oracle, and PostgreSQL along with the similarities and differences.... [How to be an ACE DBA with Amazon RDS for SQL Server]( [How to be an ACE DBA with Amazon RDS for SQL Server]( Learn how to achieve supreme Database Administration with Amazon RDS for SQL Server for designing high availability, disaster recovery, patching strategy and monitoring.... [SQL Functions Reference Guide]( [SQL Functions Reference Guide]( In this tutorial / reference guide we cover several SQL Server functions that are related to strings such as LEN, TRIM, SUBSTRING, LOWER, UPPER and many more. Each function also includes several examples of the usage and the syntax.... [Adding Salesforce Connectivity to SQL Server]( [Adding Salesforce Connectivity to SQL Server]( In this article we look at how to add real time, bidirectional connectivity between Salesforce and SQL Server using DBAmp from CData.... [SQL Server Stored Procedures Tutorial]( [SQL Server Stored Procedures Tutorial]( This popular tutorial will cover creating a simple SQL Server stored procedure to more advanced options that can be used when creating stored procedures.... [Get to SQL Server Storage Performance Problems Quickly]( [Get to SQL Server Storage Performance Problems Quickly]( My organization has multiple storage solutions with different models for the same vendor, and different models across different vendors. Each product has its own set of tools for monitoring and managing. However, this is a headache because we have to... [SQL Server Analysis Services Administration Tutorial]( [SQL Server Analysis Services Administration Tutorial]( Any IT environment employing SSAS as its OLAP technology typically involves the following administrative tasks. These tasks are an integral part of any SSAS solution that Developers as well as DBAs need to perform in production and/or non-production ... [State of SQL Server Data Quality in 2022]( [State of SQL Server Data Quality in 2022]( Data is being generated at breakneck speed, and more companies are moving towards a data-driven culture. But many data professionals and companies still struggle with the challenge to improve data quality and accuracy in their systems.... MSSQLTips Week In Review [Calculating Work Days for Power BI Reports using NETWORKDAYS Function]( [Calculating Work Days for Power BI Reports using NETWORKDAYS Function]( In this article, we look at calculating working days for Power BI reports using the new NETWORKDAYS function.... [Delivering Cloud Transformation Excellence: Project Initiation, Planning of Scope, Team and Risks - Part 4]( [Delivering Cloud Transformation Excellence: Project Initiation, Planning of Scope, Team and Risks - Part 4]( In this article, we explore the initiation and planning phase for delivering a successful project by covering what should be included in the scope and team and identifying potential risks.... [Find Mismatched Data between SQL Server Tables using LEFT JOIN, EXCEPT, NOT IN and NOT EXISTS]( [Find Mismatched Data between SQL Server Tables using LEFT JOIN, EXCEPT, NOT IN and NOT EXISTS]( In this tip we look at various ways to find mismatched SQL Server data between two tables using LEFT JOIN, EXCEPT, NOT IN and NOT EXISTS.... [How to Create a SQL Server Database, Tables, Foreign Keys and Data for an Application]( [How to Create a SQL Server Database, Tables, Foreign Keys and Data for an Application]( Learn how to create SQL Server database tables, foreign keys, and create data to begin building a database to support application development.... [Metadata Functions in SQL Server and Their Use Cases]( [Metadata Functions in SQL Server and Their Use Cases]( Learn about various SQL Server system functions to return meta data from SQL Server such as SERVERPROPERTY, DATABASEPROPERTYEX, DB_NAME, DB_ID, FILE_NAME, FILE_ID, FILE_IDEX, SCHEMA_NAME, SCHEMA_ID, OBJECT_NAME, OBJECT_ID and STATS_DATE.... [Query Plan Viewer in Azure Data Studio]( [Query Plan Viewer in Azure Data Studio]( In this article, we look at the new features in Azure Data Studio to allow you to view and work with SQL Server execution plans.... [SQL Server 2022 Server Level Role Updates]( [SQL Server 2022 Server Level Role Updates]( Learn about some of the new security changes in SQL Server 2022 and the differences in roles for ##MS_LoginManager## and securityadmin.... [SQL Server, Oracle, Postgres, Azure and AWS Performance, Monitoring and Management with dbWatch Control Center]( [SQL Server, Oracle, Postgres, Azure and AWS Performance, Monitoring and Management with dbWatch Control Center]( Learn about dbWatch Control Center to help you better manage your database environment for SQL Server, Oracle, Postgres, Azure, AWS, and more database platforms.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}