SQL Server CLR Table Valued Function, Secure SQL Server REST API, Avoid Remote Desktop Connections and Get Ready for SQL Server 2022 (MSSQLTips 5/12/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server Integration Services Tutorial - Start Learning]( [SQL Server CLR Table Valued Function]( [SQL Server CLR Table Valued Function]( Learn how to create table valued functions (TVF) using common runtime language (CLR) in SQL Server along with a couple of simple examples to get you started.... [How to Avoid Making Remote Desktop Connections to SQL Server]( [How to Avoid Making Remote Desktop Connections to SQL Server]( In this article we learn how to avoid having to make remote desktop connections to SQL Server and still be able to install, patch, read error logs and manage SQL Server.... [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.... [Getting Started with Snowflake Tutorial]( [Getting Started with Snowflake Tutorial]( In this tutorial we will go over the basics of Snowflake, introducing the product and features which makes it stand out against its competitors. We look at how to load and query data as well as how to use Power BI to create reports using the Snowflak... [Find, Analyze and Optimize SQL Server Performance]( [Find, Analyze and Optimize SQL Server Performance]( As a SQL Server Professional, application performance is one of my top priorities. I know our applications have numerous inefficiencies and we are constantly firefighting to keep our internal and external users productive. Our team collects data al... [Populate a SQL Server column with a sequential number not using an identity]( [Populate a SQL Server column with a sequential number not using an identity]( I have a database table that has a lot of data already in the table and I need to add a new column to this table to include a new sequential number. In addition to adding the column I also need to populate the existing records with an incremental cou... [Learn about SQL Server 2022 with Bob Ward]( [Learn about SQL Server 2022 with Bob Ward]( [Webcast] Introduced last November SQL Server 2022 is the most cloud enabled version Microsoft has ever released. But the excitement does not stop there, continued performance, features and security innovations continue to be released as they move cl... [SQL Server Management Studio Top 10 Productivity Tips and Hidden Secrets]( [SQL Server Management Studio Top 10 Productivity Tips and Hidden Secrets]( In this article we take a look at some of the features in SQL Server Management Studio that you can use to make you more productive when working with SQL Server.... [Simple SQL Server Data Masking and Protection]( [Simple SQL Server Data Masking and Protection]( Data breaches are becoming too common place with some accounts reporting more than 1000 breaches per year with close to 50 million records exposed yearly. Learn about how DbDefence protects your data.... [By Jugal Shah - ]( [Resolving could not open a connection to SQL Server errors]( Sometimes you may have issues connecting to SQL Server and you may get messages such as could not open a connection to SQL Server. In this tip we look at different things you can check to resolve this issue.... [By Chad Churchwell - ]( [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.... [By Sergey Gigoyan - ]( [Install SQL Server Integration Services in Visual Studio 2019]( Learn the step by step process to install SQL Server 2019 Integration Services in Visual Studio as well as the history for the tool.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}