Top Tips for October 2021 (MSSQLTips 11/2/2021)

[MSSQLTips.com]( Cannot see this MSSQLTips.com newsletter? [View in browser]( [SQL Server Indexing Tutorial - Start Learning Today]( [Using Power Apps Patch Function with SQL Server]( In this article we look at how to create a basic Power App that allows saving data to a database table.... By Hristo Hristov - [Learn More]( [Options to Export of Azure SQL Database – Part 2]( Learn about different ways to export an Azure SQL Database so that it can restored and used somewhere else.... By Mohammed Moinudheen - [Learn More]( [Faster SQL Server Clustering]( Making SQL Server deployments resilient to failures is a goal most want to achieve. Whether you are trying to account for high availability and/or disaster recovery, there are various methods to achieve the end goal. One of the most popular approache... [Learn More]( [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.... [Learn More]( [Application Performance Monitoring for all of IT]( We need to understand the performance issues in the environment at a high level, prioritize our findings then drill into the root cause in order to correct the issues. Ideally, we would like to have a single monitoring tool for the DBA, Development a... [Learn More]( [SQL Server Database Stuck in Restoring State]( In this tip we look at different reasons why a SQL Server database will be in a restoring state and things that can be done to access the database.... [Learn More]( [Powerful SQL Server Data Cleansing and Processing]( The constant data management moving target tends to overwhelm the SQL Server DBAs and Developers with the need for immediate response of updating the validation and import code to then load the data to meet the business requirements between the organ... [Learn More]( [Searching and finding a string value in all columns in a SQL Server table]( Sometimes there is a need to find if a string value exists in any column in your table. This script will help you find all occurrences in all columns in the table.... [Learn More]( [Confidently Slash Downtime with Fast SQL Server Backup and Restores]( Learn how to slash downtime for SQL Server backup and restores with FlashBlade backup terabyte databases in minutes, make database restores your first choice for disaster recovery and protect your databases from ransomware.... [Learn More]( MSSQLTips - Last Month's Top Ten Tips [Common Data Warehouse Development Challenges]( [Build Pie Charts with Python for Displaying Counts from SQL Server Data]( [Handling an unknown number of parameters in SQL Server]( [SQL COUNT Function]( [Learning SQL CROSS JOIN with Examples]( [Multiple Ways to Concatenate Values Together in SQL Server]( [SQL Server NOT Equal Operators]( [How To Become a Successful BI Developer]( [Always use the right case for data type names in SQL Server]( [SQL Server CLR Introduction]( [Twitter]( [Facebook]( [LinkedIn]( 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