I was working on a problem today where I needed to pick out a department and a sub issue that were attached to each other as a single code in a comment.
I first went to use the traditional SUSTRING(comment_string, 1, 5) IN (my list of codes) but it was slow.
So off to work, I learned something new via #stackoverflow and learned to make a sarge-able LIKE with what ever I want in the narrower results.
Do I know anybody who ever set up #MSSQL on a Linux box?
I already tried two different (officially supported) versions of Ubuntu and this piece of shit always dies when trying to run mssql-conf setup.
The "error log" contains a lot of shit that isn't actually errors, any error in there isn't of interest, the JSON files it stores for the crash point towards .dll files that obviously don't exist on a *nix box, strace gives me nothing of value and the core dumps aren't fucking core dumpsโฆ ๐คฎ
๐จ Latest issue of my curated #cybersecurity and #infosec list of resources for week #02/2024 is out! It includes the following and much more:
โ ๐ ๐ฝ Halara probes breach after hacker leaks data for 950,000 people
โ ๐ ๐ฅ #Mandiant's X Account Was Hacked Using Brute-Force Attack
โ ๐ ๐ต๐พ #Paraguay warns of Black Hunt #ransomware attacks after Tigo Business #breach
โ ๐บ๐ธ ๐ธ US SECโs X account hacked to announce fake #Bitcoin ETF approval
โ ๐ ๐จ๐ฆ Toronto Zoo: Ransomware attack had no impact on animal #wellbeing
โ ๐ Mortgage firm loanDepot #cyberattack impacts IT systems, payment portal
โ ๐ซ๐ฎ ๐ธ #Finland warns of Akira ransomware wiping NAS and tape #backup devices
โ ๐ฉ๐ฐ ๐ท๐บ #Sandworm probably wasnโt behind Danish critical infrastructure cyberattack, report says
โ ๐บ๐ฆ ๐ท๐บ Pro-Ukraine hackers breach Russian ISP in revenge for #KyivStar attack
โ ๐ซ๐ท ๐บ๐ธ French Computer Hacker Jailed in US
โ ๐ณ๐ฌ โ๏ธ Nigerian gets 10 years for laundering millions stolen from elderly
โ ๐น๐ท Turkish Hackers Exploiting Poorly Secured #MSSQL Servers Across the Globe
โ ๐น๐ท ๐ณ๐ฑ Turkish #Cyberspies Targeting Netherlands
โ โ๏ธ ๐ช๐บ #Microsoft Lets Cloud Users Keep Personal Data Within #Europe to Ease #Privacy Fears
โ ๐บ๐ธ ๐จ๐ณ #AI is helping US spies catch stealthy Chinese hacking ops, #NSA official says
โ ๐ฑ๐ง โ๏ธ Beirut Airport Screens Hacked with Anti-Hezbollah Message
โ ๐ธ๐ฆ Saudi Ministry exposed sensitive data for 15 months
โ ๐ฌ๐ท #Greece to Establish New Authority to Counter Cyber-Attacks
โ ๐ฉน #Siemens, #SchneiderElectric Release First #ICS Patch Tuesday Advisories of 2024
โ ๐ โ๏ธ New #Python-based FBot Hacking Toolkit Aims at #Cloud and #SaaS Platforms
โ ๐ฆ ๐บ #YouTube Videos Promoting Cracked Software Distribute Lumma Stealer
โ ๐ฆ ๐ง #Linux devices are under attack by a never-before-seen worm
โ ๐ฆ ๐ณ๐ฑ Dutch Engineer Used Water Pump to Get Billion-Dollar #Stuxnet#Malware Into Iranian Nuclear Facility
โ ๐ก ๐ DSA removal from #OpenSSH
โ ๐ฉน #PatchTuesday
โ ๐ ๐ Actively exploited 0-days in #Ivanti VPN are letting hackers #backdoor networks
โ ๐ ๐ง Hackers can infect network-connected wrenches to install ransomware
โ ๐จ๐ณ ๐ #AirDrop cracked by #China, revealing phone number and email address of sender
โ ๐ฉน #QNAP Patches High-Severity Flaws in QTS, Video Station, QuMagie, Netatalk Products
โ ๐ ๐ KyberSlash attacks put #quantum#encryption projects at risk
Subscribe to the #infosecMASHUP newsletter to have it piping hot in your inbox every week-end โฌ๏ธ
Speaking as someone that's primarily used #MySQL, are any of the other #SQL dialects REALLY so different that job ads need to specify which one? I've never had any actual problems the few times I've worked with #PostgreSQL or #MSSQL.
Also bestenfalls(?) pro DB-Typ&Version ein Docker-Image auf eigenem Port. Gern direkt mit initialen DBs&Tabellen aus nem zentralen SQL-Dump. Dann kann ich ein PHP Script damit connecten und iterieren.
Sowas muss doch schonmal jemand gemacht haben und ein docker-compose dafรผr besitzen, zB fรผr QA/Testing? Finde aber nix.
While the connection dialog (https://github.com/rusanu/dataconnectiondialog) wouldn't allow me to select SQL Server Authentication initially, editing the FOCA.exe.config to set Integrated Security=false in connectionString (which allows using something different than Windows Authentication/NTLM) fixed that issue.
Unfortunately, after logging in with user name to "SA" and logging in with the password, it instantly crashes. Starting it again, it instantly hangs. It does work through #wine though.