Only way I know is to write some powershell to look in C:\Program Files\Microsoft SQL Server\<version>\Setup Bootstrap\Log\<date>\Summary_<somestring>.txt

Where <version> is 80/90/100/110/120/130/140/150 etc based on the version of SQL you have installed.

Where...

Any form of recovery will need a backup.

The caveat would be if your in FULL recovery and have not backed up the transaction log after the point in time you...

No, the concepts in Azure are totally different to on-prem, as such you need load balancers and health probes and disk sync tools on top of the "old fashioned" stuff...

DECIMAL(28,12) is 14 on the left, 12 on the right, DECIMAL(15,2) is 13 on the left 2 on the right.

What do you get from the following snippit?  Anything where the...

Azure has its differences to on-prem in every way, so while you build a cluster one way on-prem the process is totally different in Azure.

You can't just go and create...

Have all the health probes and load balancers etc been setup?  S2D synced etc?

What documentation have you been following? Hopefully the below...

https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-portal-sql-create-failover-cluster

Also sometimes, having the firewall disabled can again cause...

As per your other post, your best posting this to an ORACLE forum not a Microsoft SQL Server forum.

Again ROW_NUMBER() and a CTE as per the "ORACLE TOP N" will...

Take a look at the row_number() function, there is plenty out there on the web for "ORACLE TOP N" as a search term in your favourite search engine queries which...

Well I will go back and re-look at my code see if I can perfect it in anyway to do ADO and OLE connections strings, always nice to have multiple...

Hi Phil

In addition to VS you will also need to download SSDT (https://docs.microsoft.com/en-gb/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017), this will give you the required project types to be able to build a new SSRS...

A google search led me to StackOverflow where the following was cited, unsure if this is what you want Phil but probably a starter for 10.

Format - https://www.markit.com/news/InterestRates_<CURRENCYCODE>_<DATE&gt;.zip

Example - https://www.markit.com/news/InterestRates_GBP_20200120.zip

IIRC you can only store one item in the object variable, so it has to be the connection string or the server.

I tried with server and catalog and it wouldn't...

Ok how I've done this in the past.

Create a variable of type "Object" to store the ADO.NET connection string table

Create a variable of type "String" to store the individual connection...

Without a full sample mock up of the tables in question, is it simply just a case of adding MAX and GROUP BY

select 
i.item_code,
i.cost_standard,
max((select item_price.item_price where item_price.price_group...

Who or what is the source of the excel files?  Could it be where the source is has exported them as 2013 office format or above?  If it's a 3rd...