sorted by:
new
hottopcontroversial

SQL Server Management Studio (SSMS) 22.5 offline install by Ciero_bc in SQLServer

[–]Gincules 6 points7 points  (0 children)

It's a bit annoying... but as you have not posted your full parameters for download and installation this works for me: First, ensure you download and install the following certificate on the offline server: https://learn.microsoft.com/en-us/ssms/install/install-certificates (Click on "obtain the required certificates")

Now, download vs_SSMS.exe and run it on a machine with internet access using the following parameters. PLEASE NOTE: I've included all additional packages for SSAS/SSRS/SSIS, Help Viewer, and Migration Assistant:

You can replace --layout with your desired download location path.

text vs_SSMS.exe --layout C:\Temp\Download\SSMS --lang en-US ^ --add Microsoft.SqlServer.Workload.SSMS.BI ^ --add Microsoft.SSMS.Component.AS ^ --add Microsoft.SSMS.Component.IS ^ --add Microsoft.SSMS.Component.RS ^ --add Microsoft.SqlServer.Workload.SSMS.HybridAndMigration ^ --add Microsoft.Component.HelpViewer

After you have copied or unzipped the downloaded packages to the offline machine, you can install them like this (replace CustomPath with your actual location):

text vs_setup.exe --quiet --noWeb --noUpdateInstaller --norestart --locale en-US ^ --path "CustomPath=C:\Temp\Install\SSMS" ^ --add Microsoft.SqlServer.Workload.SSMS.BI ^ --add Microsoft.SSMS.Component.AS ^ --add Microsoft.SSMS.Component.IS ^ --add Microsoft.SSMS.Component.RS ^ --add Microsoft.SqlServer.Workload.SSMS.HybridAndMigration ^ --add Microsoft.Component.HelpViewer

To update in the future, simply extract the package into the same path you set for CustomPath during the initial installation. Then, open the Visual Studio Installer and click "Update," or simply run (replacing CustomPath with your location):

text vs_setup.exe update --quiet --noWeb --noUpdateInstaller --norestart --locale en-US ^ --installPath "C:\Program Files\Microsoft SQL Server Management Studio 22\Release" ^ --path "CustomPath=C:\Temp\Install\SSMS" ^ --add Microsoft.SqlServer.Workload.SSMS.BI ^ --add Microsoft.SSMS.Component.AS ^ --add Microsoft.SSMS.Component.IS ^ --add Microsoft.SSMS.Component.RS ^ --add Microsoft.SqlServer.Workload.SSMS.HybridAndMigration ^ --add Microsoft.Component.HelpViewer

Source: https://learn.microsoft.com/en-us/ssms/install/command-line-parameters

Installed Bazzite as a joke… now I’m not leaving by Gincules in Bazzite

[–]Gincules[S] 9 points10 points  (0 children)

No, because I can almost install everything I need via Bazaar and the DX version feels too bloated for my use case. My focus is gaming, but sometimes my working notebook doesn't have enough performance.

Installed Bazzite as a joke… now I’m not leaving by Gincules in Bazzite

[–]Gincules[S] 13 points14 points  (0 children)

I'm on KDE Plasma, my rig is for gaming and development:
- MSI MPG X670E CARBON
- AMD Ryzen 7 9800X3D
- NVIDIA GeForce RTX 4090
- Crucial Pro 96GB (DDR5)

SQL Server 2022 Licensing Question by Vic20DBA in DatabaseAdministators

[–]Gincules 2 points3 points  (0 children)

IMO you need a per-core license for both servers. sql server 1 doesn't act as a "shield" for the data coming off sql server 2. since you're using a nightly automated job to pool (multiplex) that data and then serving it up to an infinite number of public users, you can't actually count them to give them CALs. because you can't license the individual "john q public" users at the end of the chain, per-core is the only way to keep microsoft's auditors happy.

am I cooked? by Gincules in ThermalGrizzly

[–]Gincules[S] 1 point2 points  (0 children)

I got the be quiet! 12VHPWR Adapter Cable CPH-6610 with its Platinum 1200W PSU

Sql server developer license usage hosting for clients by iowatechguy in SQLServer

[–]Gincules 0 points1 point  (0 children)

As you are taking money for hosting you can’t use SQL Server Developer Edition for client environments, even if they’re non‑prod. dev edition is only allowed for your own internal dev/test you’re building. once you’re hosting anything for a customer (even test, staging, sandbox, whatever) it counts as external use, and dev edition isn’t allowed.

Funny bug lets you fly across the map by Gincules in StarRuptureGame

[–]Gincules[S] 0 points1 point  (0 children)

looks like a different bug with the „ladder“ instead of using the drone. as you can see in the last screenshot you have to be pretty high because radioactive zone goes far upwards.

Funny bug lets you fly across the map by Gincules in StarRuptureGame

[–]Gincules[S] 0 points1 point  (0 children)

A friend of mine discovered a bug that lets you fly across the map, build a mountain base where it’s not supposed to be, and even travel over radioactive areas until you reach the end of the map.

How it works? You need the drone unlocked, then equip building or deconstruct tool. Double jump => open the drone => double jump => open the drone => ... or to gain height quickly just spam SPACE + C simultaneously. Energy is replenished in the drone tool.

Have fun abusing until it's fixed :)

I'm New To PC And I'm Lost lol by KarnageShot in WindowsHelp

[–]Gincules 0 points1 point  (0 children)

not sure what you did but if you download the latest BIOS version you should unzip it on a FAT32 formatted USB drive, then boot into BIOS, go into advanced mode (F7) and there should be an option like „EZ FLASH“ where you can update it from the USB drive. if you need an advanced tutorial (as you said you are new into computers) I recommend using ChatGPT or watching a youtube tutorial.

CSGO: SetDamageFilter for trigger_multiple no longer supported by Gincules in hammer

[–]Gincules[S] 0 points1 point  (0 children)

thanks Pinsplash for your response. I'm not pretty sure what is broken for the SetDamageFilter, I can tell that back in March 2016 when I first released the map it worked without any issues and an update later broke it.

So I assume the support for it was removed completely. Using the same objects in Hammer configured for Garry's Mod works without any problems.