Power BI Navigation, SQL NOT IN, DROP TABLE and more (MSSQLTips 12/27/2021)

[View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server Stored Procedure Tutorial]( [Power BI New Navigation Features]( [Power BI New Navigation Features]( Learn about the new navigation features in Power BI to make for better interactive Power BI reports for the end users.... [SQL Server DBAs Eyes into VMware]( [SQL Server DBAs Eyes into VMware]( We have a large SQL Server environment supported by physical servers, VMware and cloud infrastructure. Unfortunately, we are facing a number of performance challenges. We have frequent situations where the end user experience degrades.... [Create Calendar Table Using Power Query M Language]( [Create Calendar Table Using Power Query M Language]( Learn how to create a customizable calendar date table that can be used for Power BI reports using Power Query.... [Modernize Your SQL Server Data Warehouse]( [Modernize Your SQL Server Data Warehouse]( Learn how to connect Microsoft SQL Server Analysis Services (SSAS) multidimensional MDX cubes with Snowflake to modernize your data warehouse.... [SQL NOT IN Operator]( [SQL NOT IN Operator]( This tip will cover the SQL NOT IN operator and explain the functionality and use cases with several NOT IN examples. ... [Focus on Real Database Monitoring Issues]( [Focus on Real Database Monitoring Issues]( In this webcast, we will take a look at how and when to use different tools for monitoring, so you can make better decisions to ensure proper performance of your SQL Server database environment.... [SQL Server DROP TABLE IF EXISTS Examples]( [SQL Server DROP TABLE IF EXISTS Examples]( In this article we cover various ways to check if a SQL Server table exists before trying to drop the table to avoid the error Msg 3701 Level 11 State 5 cannot drop the table because it does not exist or you do not have permission.... [Cloud Migration Guide: SQL Server to AWS]( [Cloud Migration Guide: SQL Server to AWS]( Given the increased cadence of SQL Server releases, many of the migration activities detailed in this guide also apply when performing SQL Server upgrades on-premises if you are not yet ready for full cloud adoption. This guide will provide a detaile... MSSQLTips Week In Review [Auto generate SQL Server UPDATE triggers for data auditing]( [Auto generate SQL Server UPDATE triggers for data auditing]( This article includes a script to auto generate T-SQL code to build an UPDATE trigger to track any changes from the main table into an audit table.... [Azure Data Studio SQL Server Profiler Extension]( [Azure Data Studio SQL Server Profiler Extension]( In this article we look at how to install and use the SQL Server Profiler extension for Azure Data Studio to use against on-premises and cloud databases.... [Creating a SQL Server Agent Job to Run Python Scripts in a Virtual Environment]( [Creating a SQL Server Agent Job to Run Python Scripts in a Virtual Environment]( In this article we walk through how you can run Python scripts using SQL Server Agent, so you can setup scheduled jobs to run your Python code.... [Data Engineering with Microsoft Azure Databricks, Synapse and Apache Spark]( [Data Engineering with Microsoft Azure Databricks, Synapse and Apache Spark]( Microsoft Azure has two services, Databricks and Synapse, that allow the developer to write a notebook that can execute on a Spark Cluster. Today, we are going to talk about the two design patterns that can be used to take a raw file and transform it into... [How to Move SQL Server System Databases to a different directory on Linux]( [How to Move SQL Server System Databases to a different directory on Linux]( In this article we cover the steps on how to move SQL Server system databases to a new location when SQL Server is running on Linux.... [Power BI Zoom and Focus]( [Power BI Zoom and Focus]( In this article we look at how to add the zoom feature to your charts and graphs in Power BI reports for a better user experience.... [Python Regular Expressions Explained with Examples]( [Python Regular Expressions Explained with Examples]( In this article we cover in depth how Regular Expressions (RegEx) works along with several examples using Python to explain RegEx.... [SQL ORDER BY Clause Examples]( [SQL ORDER BY Clause Examples]( Learn how to use the SQL ORDER BY clause to provide different sort orders for query results. This article covers several different examples of how this can be used.... [SSRS Interview Questions and Answers]( [SSRS Interview Questions and Answers]( In this article we cover some questions and topics that may come up in an interview related to SQL Server Reporting Services along with many links for further learning.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] Edgewood Solutions LLC | PO Box 682, Wilton, NH 03086 [Unsubscribe {EMAIL}]( [Update Profile]( | [Our Privacy Policy]( | [Constant Contact Data Notice]( Sent by newsletter@mssqltips.com