Import and export SSMS connections, date formatting, tutorials and more (MSSQLTips 06/15/2022)

[tag] [View MSSQLTips newsletter online]( [mssqltips logo]( [Tutorials]( | [Tips]( | [Videos]( | [DBA]( | [Developer]( | [Business Intelligence]( [sponsor message]( [SQL Server Stored Procedure Tutorial]( [How to Import and Export Connections from SQL Server Management Studio]( [How to Import and Export Connections from SQL Server Management Studio]( In this article we look at how to import and export connection information for servers in SQL Server Management Studio for backup and to move to another installation of SSMS.... [Different ways to Convert a SQL INT Value into a String Value]( [Different ways to Convert a SQL INT Value into a String Value]( In this article we cover different ways to convert a SQL Server numeric value into a string value.... [Easily Encrypt SQL Server Databases and Backups - All Versions and Editions]( [Easily Encrypt SQL Server Databases and Backups - All Versions and Editions]( SQL Server database encryption should be a best practice, but it can seem daunting to implement. You might be faced with the prospect of upgrading your SQL Server, changing editions, or recoding your applications. Learn how to easily encrypt your dat... [Date and Time Conversions Using SQL Server]( [Date and Time Conversions Using SQL Server]( In this article we look at several different date and time formats you can use in SQL Server.... [Optimize SQL Server Monitoring for Operational and Performance Needs]( [Optimize SQL Server Monitoring for Operational and Performance Needs]( Learn about how SQL Monitor saves significant time for operational tasks and performance monitoring for large SQL Server environments with instances on premises, in the cloud, running in virtualized environments, clusters, and Availability Groups.... [SQL Server MSDB Database Tutorial]( [SQL Server MSDB Database Tutorial]( In this tutorial we will cover common questions related to the SQL Server msdb database. This is one of the standard system databases that are part of every SQL Server installation. This tutorial will give you a better idea of what the msdb database.... [Analyze Real Time Data from Snowflake with SSAS]( [Analyze Real Time Data from Snowflake with SSAS]( Learn how to use the CData ADO.NET adaptor for Snowflake and SSAS Multidimensional to create a solution where users can connect live to Snowflake using tools like SSAS and Power BI.... [SQL Server Row Count for all Tables in a Database]( [SQL Server Row Count for all Tables in a Database]( In this article we look at 4 different ways to get rows counts for all tables in a SQL Server database.... [Need SQL Server High Availability?]( [Need SQL Server High Availability?]( If you need to migrate to Azure at end of support (EOS), and you require HA for SQL Server 2008/2008 R2, there is only one solution recommended by Microsoft: SIOS DataKeeper. SIOS DataKeeper enables clustering in the cloud, including the creation of ... [By Greg Robidoux - ]( [Simple script to backup all SQL Server databases]( In this article we look at how you can automatically backup all of your SQL Server databases with a couple of T-SQL commands.... [By Jeremy Kadlec - ]( [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 sequential ... [By Koen Verbeeck - ]( [Backwards Compatibility in SQL Server Data Tools for Integration Services]( Historically SSDT had no backwards compatibility meaning that with a newer version of SSDT, you couldn't create SSIS packages for an older version. This has changed with SQL Server 2016.... [Twitter]( [spacer] [Facebook]( [spacer] [LinkedIn]( [spacer] [Manage MSSQLTips Subscriptions | Unsubscribe](. Edgewood Solutions LLC PO Box 682 | Wilton, NH 03086 [Privacy Statement]( Sent to: {EMAIL}