REST API Builder, Prevent Duplicate Records, DBA Cheat Sheet and T-SQL Tips

[MSSQLTips.com logo]( [View email in your browser]( TODAY'S NEWSÂ FROM MSSQLTips Learn something new every day! [mssqltips image]( [Advanced Features of DAB to Build a REST API]( Get guidance on the advanced features of DAB (Data API Builder) and how to set up a production-ready environment.... [mssqltips image]( [IDC InfoBrief | Running SQL Server workloads in the cloud]( Learn why a majority of SQL Server users chose AWS as their primary cloud provider when polled. Also, read this report to get essential guidance on selecting a cloud provider's database service for SQL Server workloads.... [mssqltips image]( [Prevent Duplicate Records in SQL using Filtered Index]( In this article, I share how an SQL Server filtered index solved the problem of preventing duplicates for new rows in a table. ... RECOMMENDED READINGÂ ON MSSQLTips [mssqltips image]( [Storage = Unacceptable SQL Server Performance?]( Learn how to unravel the many layers of the SQL Server infrastructure stack responsible for performance issues. We'll explore common bottlenecks, actual storage issues, network connectivity, and virtualization nuances. You'll leave with enough knowle... [mssqltips image]( [Encrypt Every SQL Server Database]( Learn why Becton Dickinson has selected DBDefence to protect their SQL Server data across numerous medical devices in a cost effective manner.... [mssqltips image]( [Best-of-class SQL Server Performance Monitoring and Alerting]( Learn about SolarWinds' SQL Sentry designed to monitor SQL Servers, collect Key Performance Indicators (KPIs), highlight poorly performing queries, identify performance-related issues, and send alerts to notify DBA teams promptly.... ADDITIONAL RESOURCESÂ ON MSSQLTips [mssqltips image]( [Cheat Sheet for SQL Server DBA Daily Operations]( This article contains various code fragments and scripts that could be used to manage and check on SQL Server and databases.... [mssqltips image]( [Execute a T-SQL batch multiple times using GO]( Learn how to execute the same batch of SQL Server commands X number of times using the GO command.... [mssqltips image]( [SQL Stored Procedure Tutorial]( This tutorial look at how to create stored procedures in SQL Server to be able to reuse the code for various purposes.... [Manage MSSQLTips Subscriptions | Unsubscribe]( Edgewood Solutions LLCÂ PO Box 682 | Wilton, NH 03086Â [Privacy Statement]( Sent to: {EMAIL}Â [tag]