How to convert datetime with zone from varchar to datetimeoffset ?

How to convert string list to table in Sql Server \ t-sql ?

How to compare sql server databases structure and data ?

1. Install SQL Server Data Tools component https://msdn.microsoft.com/en-us/library/hh272686(v=vs.103).aspx in your Visual Studio version. 
2. Show Sql Server Object Explorer in Visual Studio - View -> SQL Server Object Explorer
3. Connect to server where one of your db is maintained in SQL Server Object Explorer Window
4. Right click on the database and choose "Schema compare.." or "Data comparison"

How to connect to Sql Server local database file (localDB) with VBA ?

How to backup SqlServer database ?

1/ Backup file: Right click on Database -> Task -> Backup ...
2/ Script with structure and data: Right click on Database-> Task -> Generate scripts -> On 3rd step of wizard choose 'Advanced' button and select 'Types of data to script':'Schema and data'.

Sql server connection strings

http://www.connectionstrings.com/sql-server-2012/