1. ChatGPT

    CVE-2024-21333: Critical SQL Server Vulnerability and Mitigation Strategies

    On July 9, 2024, Microsoft addressed a critical security vulnerability identified as CVE-2024-21333, which affects the SQL Server Native Client OLE DB Provider. This vulnerability poses a significant risk, enabling potential attackers to execute arbitrary code on affected systems. Overview of...
  2. ChatGPT

    Critical CVE-2024-21332 Update: Addressing SQL Server Vulnerability

    Overview On July 9, 2024, a significant security update from Microsoft has drawn attention within the IT community, particularly amongst Windows users and professionals handling SQL Server environments. This update addresses a potential Remote Code Execution (RCE) vulnerability identified as...
  3. ChatGPT

    CVE-2024-38087: Critical SQL Server OLE DB Vulnerability Explained

    The cybersecurity landscape is constantly evolving, and vulnerabilities in software can pose serious risks to organizations and individuals alike. One such concern is the recently identified CVE-2024-38087, which pertains to the SQL Server Native Client OLE DB provider. This article delves into...
  4. ChatGPT

    CVE-2024-38088: Key Insights on SQL Server OLE DB Vulnerability and Mitigation

    Understanding CVE-2024-38088: SQL Server Native Client OLE DB Provider Remote Code Execution Vulnerability On July 9, 2024, Microsoft published details about a critical vulnerability identified as CVE-2024-38088 that affects the SQL Server Native Client OLE DB Provider. This vulnerability can be...
  5. ChatGPT

    Step-by-Step Guide to Install SQL Server Management Studio on Windows 11

    Microsoft's SQL Server Management Studio (SSMS) is a powerful tool that allows Windows users to connect to SQL Server instances, execute queries, and manage databases. For those who are new to the world of SQL Server, this guide will provide detailed, step-by-step instructions on how to install...
  6. D

    Cant Find Scheduled task that is Backing up SLQ Db

    Hi experts. Windows Server 2019 This is a SQL Server and the database shows o be getting backed up daily. But I cannot find the scheduled Task that is performing the scheduled backup. The backup runs at 12 am based on info I retrieve from SQL Server. How can I sift thru the hundreds of...
  7. G

    Help with Windows Server 2022 Licenses Requirement!

    Hi All, I wonder if you could help me with how many windows server 2022 and SQL server licenses I need for the following: 1x Active Directory 2x Management 3x Vmware vcenter 4x Windows 1x DHCP 2x Printing server! 3x Files servers 4x VEEAM (Log backup) 5x App servers 6x App servers Not sure...
  8. T

    Actions taken during Disaster Recovery for client whose IBM Megaraid controller has failed

    Subject: Actions taken during Disaster Recovery for client whose IBM Megaraid controller has failed Good day from Singapore, We have a client, an engineering company, in Woodlands Link Singapore. They have an old IBM System X server (hereinafter referred to as the Old Server). Their IBM...
  9. T

    Windows 11 grant rights to share to local service account

    I have a windows server 2012, I have a folder that I need to grant access to a local service account. Cant seem to do it through gui. The service account is NT Service\MSSQLSERVER. Is this possible?
  10. J

    Windows 10 Convert DateTime is failing with following in Power Shell using SQLSERVER

    It tried to convert following time in Power Shell Script '2022-01-02T11:43:23.100Z' using Convert Function, and Cast. The tried same in SSMS and passed. Both SSMS and Power shell were connect to same instance of SQL Server 14.0.1000. Error message indicates in Power shell it is failing in...
  11. News

    Announcing Windows 10 Insider Preview Build 19042.608 (20H2)

    Hello Windows Insiders, today we’re releasing 20H2 Build 19042.608 (KB4580364) to the Release Preview Channel for those Insiders who are on 20H2 (Windows 10 October 2020 Update). This update will also go out to Windows Insiders in the Beta Channel later today. UPDATE 4:45pm (Pacific): This is...
  12. News

    KB3203693 - “A digitally signed driver is required” warning when you install SQL Server packages in Windows Server 2016 and Windows 10

    KB3203693 - “A digitally signed driver is required” warning when you install SQL Server packages in Windows Server 2016 and Windows 10 Continue reading...
  13. M

    Windows 7 Static IP installed. No longer to able to see Workgroup

    We have a small workgroup of 4 computers. Just got a Static IP installed on the router for RDC work at home. Only my computer has the static IP. When my internet access is in DCHP mode, I can utilize the SQL server on our machine running IIS via our intranet, and I can see all other computers...
  14. X

    Help understanding Windows Server CALs

    Hello gentlemen/ladies, I come to you seeking help with a windows server problem. I recently started helping a small company with their IT equipment and there is a problem I am facing right now. They have bought an ERP software which is a client-server solution, running on top of Microsoft SQL...
  15. R

    How to scrub or clean out company data before selling server

    I'm looking to sell a used Dell Poweredge T310 server with Server 2008 Standard SP2 and MS SQL Server 2008 R2 on it. I'd like to sell the server as-is, with the OS and installed programs. I've scrubbed many Windows XP through 10 PCs for sale but never a server. -The merits of selling this...
  16. AyyyJono

    ApplicationData Shortcut to itself?

    I've recently come across something that has perplexed me and I do not understand the reason for it. Under C:\Users there is a shortcut called All Users. This takes me to C:\ProgramData. In ProgramData there is a shortcut for Desktop, Documents, Start Menu, Templates but oddly, ApplicationData...
  17. Metria

    Server 2012R2 RDS All on one VM

    I know, it's not the suggested way of doing things but it has worked for years. I have an 2012R2 Standard with RDS, and Domain Contoller all in one. It has worked for years. I changed ISP's, and moved it to a new static address, tried the original and have tried restoring several backups...
  18. F

    Windows 2008 R2 disconnects

    Hello we have a Windows Server 2008 R2 with SQL Server 2008 R2. We have. months having disconnections during certain hours, We called the ISP and since they changed the administration some problems began to occur, We used for example a primary DNS and Secondary addresses that were provided to us...
  19. News

    How to Determine Activity on Each Processor in SQL Server

    The contents of the SELECT, WHERE and ORDER BY clauses are all a matter of determining the story you need to tell. Continue reading...
  20. News

    Announcing Windows Server 2019 Insider Preview Build 17692

    Hello Windows Insiders! Today we are pleased to release a new build of the Windows Server vNext Long-Term Servicing Channel (LTSC) release that contains both the Desktop Experience and Server Core in all 18 server languages, as well as a new build of the next Windows Server Semi-Annual Channel...