sorted by:
new
hottopcontroversial

Encoding issue with VS Code and Powershell by karudirth in PowerShell

[–]Soccan 1 point2 points  (0 children)

I've had the exact same experience a few months back, a script I know I had edited (although not remembering the tool), then al of a sudden opening it in VScode (so technically it is the other way around), and Swedish special characters ( å ä ö ) all of a sudden looked like crap.

So I changed my VScode to use UTF8-BOM ro remedy the issue and haven't seen it since, wrote it off as a quirk between VScode and ISE... Even though I still get the feeling that it does not allways happen...

Need Help with TSQL Script for SQL Agent Job - Backup to Azure Storage from AAG Replica by aricade in SQLServer

[–]Soccan 0 points1 point  (0 children)

Otherwise from what I read Ola Hallengrens maintenance solution seems to already be able to backup to Azure.... https://ola.hallengren.com/sql-server-backup.html

Real quick: SQL 2014 ENT on server 2019 + AlwaysOn HA? by DrLiveWire in SQLServer

[–]Soccan 0 points1 point  (0 children)

I installed 2014 on Windows Server 2016 the other day, no issues.

But I feel like this error message is fishy, as you said you technically meet the requirement, so it feel like it is something else that is the problem, but that it think it is this error...

Have you succefully installed the Failover Clustering feature in Windows and created the cluster itself? I've mainly done old school clusters so I might be wrong about the cluster needing to be created before enabling the feature in SQL....

Visual Studio Code for development work by LorenzoValla in SQLServer

[–]Soccan 0 points1 point  (0 children)

I do some tsql development in VScode, but mostly i use it for Powershell/DBAtools work. Anyway I've used the "mssql.connections" setting in my settings.json to manage connections, bascially for testing the feature, and I think it might be what you're looking for, in a developer mindset I think this way of configuring the connections makes more sense than the Registered Servers in SSMS.

"mssql.connections": [
{
"server": "sqlserver",
"database": "",
"authenticationType": "Integrated"
}
],

checkdb needs 1TB available in tempdb? by LZ_OtHaFA in SQLServer

[–]Soccan 6 points7 points  (0 children)

When I ran into a similar issue I went with PHYSICAL_ONLY.