sql

  1. A

    Case for homelab

    Hi, Im in the process of looking for a new build, to act as a home server lab. The lab is mostly running idle, but i sometimes have to spawn several big K8S clusters, with virtually redundant SQL clusters for testing = 100GB ram consumed. So im planning on buying this: 1 x AMD Ryzen 7800X3D (In...
  2. E

    From spinners to SSD

    Hi Folks. I have a SQL Server database running on a virtualized Windows Server 2012 R2 (VMware ESXi). I have a task from Accountancy to boost the performance of the database. The database has about 70GB and the RAM allocated is about 90GB. The virtual machine is spinning on SAS Disks 10k -...
  3. T

    Advise on server for Business Intelligence training

    Hi all I am currently in the process of starting up at consultancy within the data Engineering / Architecture and Business Intelligence area. One leg of my invisioned business would be training in the use of SQL Server, and excel, for analytics staff in larger companies. I would like to build...
  4. MrCalvin

    Power-Loss-protected cache size on SSD: Yes, finally someone reveals the size (Kingston)

    Beside the obvious reason of PLP it should also help synchronous I/O performance e.g. SQL (and all ESX guest writes I believe!), as when data are written to the quick PLP protected disk-cache the disk rightfully can report back that the data IS written to the disk and the system can move on. But...
  5. Hjalti Atlason

    WPF application and Powershell

    Hey guys I was wondering if anyone is doing any WPF application programming and gathering data with Powershell and store in a database ? As a sysadmin i really like gathering information with powershell but would like to store the information in a database (SQL express). Been thinking if...