Running SQL Server Best Practices Check, Filtered Index Issues, SQL Server Cloud Options and T-SQL Coding Tips (MSSQLTips 2/16/2023)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [Create a Non-Sensitive Copy of Production Data]( [Running SQL Server Best Practices Check with Azure Data Studio to Assess your SQL Servers]( [Running SQL Server Best Practices Check with Azure Data Studio to Assess your SQL Servers]( In this article, we look at how to install and run the SQL Server Best Practices Check with Azure Data Studio to get an assessment for all your SQL Server instances and databases.... [Overlooked Reason SQL Server Ignores Your Filtered Indexes]( [Overlooked Reason SQL Server Ignores Your Filtered Indexes]( In this article, we look at using SQL Server filtered indexes to improve performance, why SQL Server will sometimes ignore these indexes, and what you can do to ensure that SQL Server always picks the best index.... [Data Breach Low-Hanging Fruit]( [Data Breach Low-Hanging Fruit]( Organizations that move a copy of production data into non-secure environments, such as test and development, must take steps to secure the data. A critical step is the use of static data masking that permanently masks all sensitive data....... [Concatenate SQL Server Columns into a String with CONCAT()]( [Concatenate SQL Server Columns into a String with CONCAT()]( In this tip we look at different ways to concatenate SQL Server string data and how to deal with NULL values when concatenating strings....... [SQL Server in the cloud - What are the real benefits?]( [SQL Server in the cloud - What are the real benefits?]( Azure SQL Managed Instance is an intelligent cloud database service combining the broadest SQL Server engine compatibility with the benefits of a fully managed, up-to-date platform as a service. Learn how to confidently and cost-efficiently modernize...... [Execute Dynamic SQL commands in SQL Server]( [Execute Dynamic SQL commands in SQL Server]( In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. This is where dynamically building SQL statements can be useful....... [Difficulties Managing Your SQL Server Environment?]( [Difficulties Managing Your SQL Server Environment?]( Managing a database environment has gotten significantly more complex with 24x7x365 requirements, limited qualified database professionals and fierce ...... [Format numbers in SQL Server]( [Format numbers in SQL Server]( In this article we cover different ways to format numbers in SQL Server using various functions like CAST, CONVERT, ROUND, CEILING, FLOOR and FORMAT....... [Strategies to Improve SQL Server Storage Performance]( [Strategies to Improve SQL Server Storage Performance]( Learn about important considerations for SQL Server Professionals building and managing large databases - storage, lower life cycle environments, performance, IO, backups, snapshots, DBCCs and more....... [By Greg Robidoux - ]( [Find Last Restart of SQL Server]( In this tip, we look at various methods of how to get the start time for a SQL Server instance. ... [By Sergey Gigoyan - ]( [Find and Remove Duplicate Rows from a SQL Server Table]( Learn how to find and remove duplicate rows from a SQL Server table with and without a unique index.... [By Eduardo Pivaral - ]( [Multi-detail reports using sub reports in SQL Server Reporting Services]( In this tip we look at how to use sub reports to correctly display multi-detail reports within a main SQL Server Reporting Services (SSRS) report.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}