#mssql

New blog post! I recently got to use both of the tools I published on Codeberg (Axmar and Tessera) during an engagement, and so I decided to make a brief writeup as a case study of what these tools can do. https://ti-kallisti.com/tales/schedule.html #infosec #pentesting #redteam #redteaming #Microsoft #ActiveDirectory #MSSQL

Yo #Database nerds! Quick question - would approx 8 seconds be a reasonable transaction time when returning 5 million rows of a single column over a VPN connection ? Standalone Windows Server VM (ew), spinning rust SAS drives , generally well performing all round. Loads of ram and cores, but guess what... it's SQLExpress so no matter what I give it it won't be used. I think 8 seconds is OK.... I'm right, right? Please note I am not asking for ways to improve this, I am asking if this would be considered acceptable given the constraints. Basically, I need to tell some software developers to make their database calls more efficient and not blame the servers. (If your application needs to make loads of database calls returning every result in the table so the client application can do some work, maybe investigate ways to improve this!!! (Oh, and don't use MSSQL (and definitely not SQLExpress))) #SysAdmin #MSSQL #SQLExpress