New SQL Server 2022 Functions, WRITE Function for BLOB Columns, Resolving Connection Issues and Week in Review (MSSQLTips 2/27/2023)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server 2022 is now generally available]( [SQL Server .WRITE() Function to Update VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) Data Types]( [SQL Server .WRITE() Function to Update VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) Data Types]( Learn about the SQL Server .WRITE function along with how to use this to update data in VARCHAR(MAX), NVARCHAR(MAX), and VARBINARY(MAX) data types.... [New functions in SQL Server 2022 - LEFT_SHIFT and RIGHT_SHIFT]( [New functions in SQL Server 2022 - LEFT_SHIFT and RIGHT_SHIFT]( Learn about the new functions LEFT_SHIFT and RIGHT_SHIFT in SQL Server 2022 and how these functions could be used.... [SQL Server 2022 is now generally available]( [SQL Server 2022 is now generally available]( Take advantage of the most cloud-connected release yet. SQL Server 2022 solves major challenges for data professionals by utilizing Azure for business continuity, seamless analytics, visibility, and governance over your entire data estate....... [Add and Subtract Dates using DATEADD in SQL Server]( [Add and Subtract Dates using DATEADD in SQL Server]( Date manipulation is a common scenario when retrieving or storing data in a SQL Server database. There are several functions that are available and in this tip we look at how to use the DATEADD function....... [Learn about Microsoft's Latest SQL Server Cloud Offerings]( [Learn about Microsoft's Latest SQL Server Cloud Offerings]( 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...... [Resolving could not open a connection to SQL Server errors]( [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....... [Diagnose SQL Server Performance Issues Fast]( [Diagnose SQL Server Performance Issues Fast]( Learn about how to address SQL Server performance issues such as blocking, high CPU utilization, excessive IO and more with SolarWinds Database Performance Analyzer....... [SQL Server Cursor Example]( [SQL Server Cursor Example]( A SQL Server cursor is a set of T-SQL logic to loop over a predetermined number of rows one at a time. The purpose for the cursor may be to update one row at a time or perform an administrative process such as SQL Server database backups in a sequen...... [Slash Downtime with Fast SQL Server Backup and Restores]( [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....... MSSQLTips Week In Review [Data Governance Frameworks for Sharing and Governing Data Efficiently]( [Data Governance Frameworks for Sharing and Governing Data Efficiently]( In this article, we will explore the importance of data governance frameworks and data sharing practices in enabling organizations to share and govern data efficiently. ... [How to Install the AdventureWorks Sample Database in Azure SQL Database]( [How to Install the AdventureWorks Sample Database in Azure SQL Database]( Learn how to configure Azure SQL Database and setup the AdventureWorks database for code testing and learn how to use features of SQL Server.... [Introduction to Creating Data Visualizations with Python matplotlib]( [Introduction to Creating Data Visualizations with Python matplotlib]( In this article, we will examine the matplotlib data visualization library for Python and how to generate charts to visualize data.... [Load Skype Meetings data via API into SQL Server using Python]( [Load Skype Meetings data via API into SQL Server using Python]( Skype has an API to access its data, and, in this article, we look at how to use this API with Python and how to load the data to a SQL Server database.... [Managing Excel Files with Apache Spark for Azure Databricks Implementation]( [Managing Excel Files with Apache Spark for Azure Databricks Implementation]( In this article, we look at how to manage Microsoft Excel files using Apache Spark along with several different examples and code that can be downloaded for testing.... [SELECT DISTINCT SQL Command to Return a Unique List of Values]( [SELECT DISTINCT SQL Command to Return a Unique List of Values]( Learn about the SELECT DISTINCT SQL command to return a unique list of values from SELECT queries along with several examples.... [Snowflake for SQL Server Developers - NULL Functions - Part 2]( [Snowflake for SQL Server Developers - NULL Functions - Part 2]( Learn about NULL functions that exist in Snowflake but not in SQL Server like NVL2, ZEROIFNULL, EQUAL_NULL, and IS_NULL_VALUE. ... [SQL Calendar Table - Use a Table and View to Simplify Generation ]( [SQL Calendar Table - Use a Table and View to Simplify Generation]( This article provides T-SQL code to generate SQL calendar tables and to auto-create HTML code for formatted tables that could be used in web applications.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}