Week in Review, Find Unused Databases, PowerBI Comments Form, SQL LIKE Examples and more (MSSQLTips 6/1/2021)

[View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server Stored Procedure Tutorial]( [PowerBI Comments Form with Power Apps]( [PowerBI Comments Form with Power Apps]( In this article we look at how you setup Power Apps for users to leave comments on the report or a part of the report.... [How to Find Unused Databases in SQL Server]( [How to Find Unused Databases in SQL Server]( In this article we look at how to identify if SQL Server databases are not being used and a process to take these unused databases offline.... [Unlock Reliable and Predictable System Performance]( [Unlock Reliable and Predictable System Performance]( Having reliable, predictable system performance is the goal of every IT professional. This is even more true for a SQL Server database professional given that the data is the backbone of almost every organization. While you could build your own set o... [SQL Server LIKE Examples]( [SQL Server LIKE Examples]( Learn how to use the SQL LIKE operator to search for various string patterns within SQL Server data. This covers several examples of how the SQL LIKE statement can be used.... [Build a Secure SQL Server REST API in Minutes]( [Build a Secure SQL Server REST API in Minutes]( Learn how to build a secure SQL Server REST API in minutes with DreamFactory which is middleware that connects all of your applications across the enterprise in a secure manner.... [How to tell what SQL Server versions you are running]( [How to tell what SQL Server versions you are running]( Check out this tip to easily find out what version of SQL Server you are running.... [Master 5 Common SQL Server Monitoring Challenges]( [Master 5 Common SQL Server Monitoring Challenges]( [Webcast] Master the 5 most common monitoring challenges for DBAs and boost the performance of your SQL Servers.... [Getting Started with SQL Server 2017 Express LocalDB]( [Getting Started with SQL Server 2017 Express LocalDB]( In this tip we cover the steps to install SQL Server 2017 Express LocalDB and things you need to do to get started using this feature.... [Faster SQL Server Clustering]( [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... MSSQLTips Week In Review [Azure Databricks Access Controls and Row Level Security]( [Azure Databricks Access Controls and Row Level Security]( Azure Databricks has a number of Access Controls and Row Level Security options that we will explore in this article.... [Performing a Wilcoxon Signed Rank Test in SQL Server]( [Performing a Wilcoxon Signed Rank Test in SQL Server]( This article shows how to use TSQL for a Wilcoxon signed rank test which is one of two widely recommended statistical tests for assessing if two repeated measurements on a sample of entities are statistically different. ... [SQL CAST Function for Data Type Conversions]( [SQL CAST Function for Data Type Conversions]( In this article we look at how to use the CAST function to change the data type for some data as well as compare CAST, CONVERT and PARSE functions.... [SQL ORDER BY Clause]( [SQL ORDER BY Clause]( In this article we look at using the ORDER BY clause with TSQL statements and different ways ORDER BY can be used in SQL Server.... [SQL Server Backup Testing and Verification]( [SQL Server Backup Testing and Verification]( In this article we look at a PowerShell that will help you automate testing of your SQL Server database backups.... [SQL Server Linked Server, Oracle DBLink and PostgreSQL Foreign Data Wrapper]( [SQL Server Linked Server, Oracle DBLink and PostgreSQL Foreign Data Wrapper]( Learn how to query across database servers and database platforms for SQL Server, Oracle and PostgreSQL.... [Troubleshoot New Line Breaks, Line Feeds and Carriage Returns in SSIS Flat File Destination]( [Troubleshoot New Line Breaks, Line Feeds and Carriage Returns in SSIS Flat File Destination]( In this article we look at how to properly export data from SQL Server to a flat file when the SQL data contains line breaks, line feeds and carriage returns.... [Understanding SQL Server Full Text Search]( [Understanding SQL Server Full Text Search]( In this article we look at the Full Text Search feature in SQL Server that allows you to quickly query large text that is stored in tables.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] Edgewood Solutions LLC | PO Box 682, Wilton, NH 03086 [Unsubscribe {EMAIL}]( [Update Profile]( | [Constant Contact Data Notice]( Sent by newsletter@mssqltips.com