I've built a MySQL database from a Windows Event Viewer, trying to track down the last event for each possible level of event. For example, the last event for level Warning on 8/2/2025 might be 10016 (Distributed COM). (The database was populated by a powershell script, courtesy Google's AI.:

# Define the log name (e.g., 'System', 'Application', 'Security')
$LogName = 'System' 

# Define the path for the output CSV file
$OutputPath = "EventLog_24hr_Format.csv"

# Get events from the specified log and select/format properties
Get-WinEvent -LogName $LogName | Select-Object -Property @{Name='TimeCreated';Expression={$_.TimeCreated.ToString('yyyy-MM-dd HH:mm:ss')}},
    LevelDisplayName,
    Id,
    TaskDisplayName,
    ProviderName | 
    Export-Csv -Path $OutputPath -NoTypeInformation

) Here's what I know does NOT work: select datestamp, leveldisplayname, max(timecreated), id from all_events group by datestamp, leveldisplayname LIMIT 0, 10 because Error Code: 1055. Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'events.all_events.Id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by So, how do I get the last event id for each day, level combination?

I'm trying to view SQL Server logs on a specific server and is missing Windows NT section in same. Though other server are showing that section. In the screenshot shared below, I highlighted section that I'm not getting for one of the SQL Server instances. **Question** - Is there any configuration or any required steps, for enabling **Windows NT** section in SQL Server Logs? Server details with the issues: Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64) Sep 24 2019 13:48:23 Copyright (C) 2019 Microsoft Corporation Standard Edition (64-bit) on Windows Server 2019 Standard 10.0 (Build 17763: ) (Hypervisor) Server details having no issue or the screen server details Microsoft SQL Server 2016 (SP2-CU11-GDR) (KB4535706) - 13.0.5622.0 (X64) Dec 15 2019 08:03:11 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2012 R2 Datacenter 6.3 (Build 9600: ) (Hypervisor)

recently i'm working on mongo db and I'm trying to check the performance of mongodb with 2 million record. I need to clear cache every time I start the test. I don't want to restart the computer/server each time I want to run the test. I tried to clear collections cache but the result wasn't as I expected. Is there a way to clear cache like the way exist in linux ?

I am getting an error when attempting to upgrade a PostgreSQL installation. The full error is: >A data directory is registered in \*\*\*unknown variable postgresqlini\*\*\* but is neither empty or a recognized data directory I've already had a look at [this issue](https://dba.stackexchange.com/questions/224062/install-postgresql-in-unattended-error) , which seems to be the only other one I can find which is related, but it did not help me. As you can see, my paths are surrounded by quotation marks. Here is the full command that is run (separated to multiple lines to make it readable)

"C:\ProgramData\Package Cache\44103BBE02C9C99CB868F4767B0CC3B5D50B6C09\postgresql-10.11-1-windows-x64.exe"
--unattendedmodeui minimal
--mode unattended
--servicename RM_Postgresql
--servicepassword xyz
--superpassword xyz
--prefix "C:\Program Files\\company\postgres"
--datadir "C:\Program Files\\company\data"
--disable-components stackbuilder

This command is part of an installer which launches the PostgreSQL installer. I've been running the same command for nearly 2 years without any issues (using different versions of PostgreSQL on different computers). For some reason, it seems to now be failing on one of our machines, and I am unsure as to why. The currently installed version of PostgreSQL on the computer where it is failing is 10.6-1, and I am attempting to update to 10.11-1 if that makes any difference. This now seems to cause issue with the previous installation as well:

initializeDatabase fail on opening postgres msg=could not connect to server: Connection refused (0x0000274D/10061)
	Is the server running on host "localhost" (::1) and accepting
	TCP/IP connections on port 5432?
could not connect to server: Connection refused (0x0000274D/10061)
	Is the server running on host "localhost" (127.0.0.1) and accepting
	TCP/IP connections on port 5432?
QPSQL: Unable to connect

I have no idea how this happens, but in SSMS (version 21) occasionally the line endings go wrong. I’m teaching online to users with Windows and SSMS and suddenly they get errors with the GO keyword. This is apparently due to the fact the line endings have got mixed and there isn’t the proper CRLF line ending around the GO keyword. This is with new files created in SSMS on Windows, so I don’t see where the other line endings are coming from. More importantly, I can’t find a simple way of fixing these line endings. I can open the file in another text editor, such as Pulsar, and fix it that way, but I can’t ask the students to do that; besides, there must be a way within SSMS to do this.

I have just built a SQL Server 2022 Always on Availability group with 3 Nodes at HQ and 1 Node at DR. During our testing phase I have noticed every time I rebooted the primary without failing over or moving the cluster resources from the primary I get error 1069 and 1205 in the cluster. My cluster validation came without any error but with some warnings as it is a multi subnet cluster and there was nothing on the cluster logs or sql error logs. Before I contact Microsoft support I wanted to check if the errors were intended behavior of the cluster. The availability group always automatically failed over every time I rebooted the primary to simulate a failure. Error 1069: > Cluster resource 'ABC_LIVEDB' of type 'SQL Server Availability Group' > in clustered role 'ABC_LIVEDB' failed. Error 1205: > The Cluster service failed to bring clustered role 'ABC_LIVEDB' > completely online or offline. One or more resources may be in a failed > state. This may impact the availability of the clustered role. I greatly appreciate the guidance.

When I installed SSMS21 on windows 2022 server I noticed the extremely disruptive new feature where it will not use the open and logged in instance of SSMS when I double click a .sql file. Instead, it opens a new instance is SSMS, taking forever and eating resources. I tried lots of registry hacks posted here and there on the internet, and even enlisted the help of chatgpt and copilot to try to fix it. No success. Imagine my surprise when Brent sent me this link https://14days.brentozar.com/ssms.mp4 showing him double clicking on a sql file and it using the open instance of SSMS 21! According to Brent, the only difference here is he is using Windows 2025. Unfortunately, I do not have access to windows 2025 yet. I build a clean VM with the following specs: Windows Server 2022 Standard 21H2 OS Build 20348.3807 SSMS SQL Server Management Studio 21.3.7+3.36221.1 I launch SSMS and log in to the database. Then I use windows explorer to find my sql files and double click on one. A brand new instance is SSMS slowly launches! Grrrr! I know it can work because I see Brent's video. Anyone know the magic sauce to make it work for me?

I am having MySQL 5.1 installed on windows box. Now I would like to upgrade to latest MySQL 5.6 version. I am planning to install MySQL 5.6 in the same server with same port 3306. After installation, I will map the new installation data directory to the older data directory which is used by MySQL 5.1. After this, I will upgrade using mysql_upgrade.exe. Will this plan work out or not ? Also let me know if any precautions to be taken care. Edit: This is production server and the DB is of huge size 100 GB, so we are not able to go with backup and restore mechanism which is time consuming process.

I am using mongo db with replica sets. I am starting the mongodb using command prompt. Python Script:

os.system('start mongod --configsvr --dbpath C:\mongoConfigData/configdb1 --replSet conf --port 27019')
os.system('start mongod --configsvr --dbpath C:\mongoConfigData/configdb2 --replSet conf --port 27020')
os.system('start mongod --configsvr --dbpath C:\mongoConfigData/configdb3 --replSet conf --port 27021')
  
os.system('start mongos --configdb "conf/localhost:27019,localhost:27020,localhost:27021" --logpath E:\mongoSLogs\mongoLog.log  --port 26060')
  
os.system('start mongod --replSet conf --shardsvr   --dbpath E:\data --storageEngine wiredTiger --wiredTigerJournalCompressor zlib --wiredTigerCollectionBlockCompressor zlib --wiredTigerCacheSizeGB 7 --port 27010 ')

os.system('start mongod --replSet conf --shardsvr  --dbpath F:\data --storageEngine wiredTiger --wiredTigerJournalCompressor zlib --wiredTigerCollectionBlockCompressor zlib --wiredTigerCacheSizeGB 7 --port 27011 ')

os.system('start mongod --replSet conf --shardsvr  --dbpath G:\data --storageEngine wiredTiger --wiredTigerJournalCompressor zlib --wiredTigerCollectionBlockCompressor zlib --wiredTigerCacheSizeGB 7 --port 27012 ')

I want to start the mongodb as a windows service. Let me know how to convert the above in to windows service

2020-08-23 17:22:36 5688 [Note] Plugin 'FEDERATED' is disabled. 2020-08-23 17:22:36 5688 [Note] InnoDB: Using atomics to ref count buffer pool pages 2020-08-23 17:22:36 5688 [Note] InnoDB: The InnoDB memory heap is disabled 2020-08-23 17:22:36 5688 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2020-08-23 17:22:36 5688 [Note] InnoDB: Memory barrier is not used 2020-08-23 17:22:36 5688 [Note] InnoDB: Compressed tables use zlib 1.2.3 2020-08-23 17:22:36 5688 [Note] InnoDB: Not using CPU crc32 instructions 2020-08-23 17:22:36 5688 [Note] InnoDB: Initializing buffer pool, size = 32.0M 2020-08-23 17:22:36 5688 [Note] InnoDB: Completed initialization of buffer pool 2020-08-23 17:22:37 5688 [Note] InnoDB: Highest supported file format is Barracuda. 2020-08-23 17:22:37 5688 [Note] InnoDB: The log sequence numbers 1771332 and 1771332 in ibdata files do not match the log sequence number 24084333 in the ib_logfiles! 2020-08-23 17:22:37 5688 [Note] InnoDB: Database was not shutdown normally! 2020-08-23 17:22:37 5688 [Note] InnoDB: Starting crash recovery. 2020-08-23 17:22:37 5688 [Note] InnoDB: Reading tablespace information from the .ibd files... 2020-08-23 17:22:38 1640 InnoDB: Operating system error number 5 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. It may also be you have created a subdirectory InnoDB: of the same name as a data file. InnoDB: Error: could not open single-table tablespace file table_a.ibd InnoDB: We do not continue the crash recovery, because the table may become InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it. InnoDB: To fix the problem and start mysqld: InnoDB: 1) If there is a permission problem in the file and mysqld cannot InnoDB: open the file, you should modify the permissions. InnoDB: 2) If the table is not needed, or you can restore it from a backup, InnoDB: then you can remove the .ibd file, and InnoDB will do a normal InnoDB: crash recovery and ignore that table. InnoDB: 3) If the file system or the disk is broken, and you cannot remove InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf InnoDB: and force InnoDB to continue crash recovery here. I'm using VM and OS is Windows Server 2016 and Uniform Server. If I set innodb_force_recovery > 0, nothing gets updated in db. I have started mysql and apache as admin, also I have tried deleting ib_logfile* and still nothing works. In the other case, even if both mysql and apache are running, the web page shows like request can't be handled and these errors will be in mysql error log. How can this be resolved?

Now do I move a tablespace on a windows installation of postgres? This thread shows how to do it on unix, not windows. The tablespace was originally created with this command... CREATE TABLESPACE tabspace2 OWNER theowner LOCATION 'e:/pgdata2/fdb'; The command ALTER TABLESPACE allows the name to be edited, but I need to change the file location. Work from the previous thread, I can get the oid from SELECT oid,spcname FROM pg_tablespace WHERE spcname = 'tabspace2'; Digging through my postgres installation I've found this folder where the bottom level foldername matches the oid c:\pg_data\14\data\pg_tblspc\57620. The icon for this folder has a little blue arrow in the bottom left corner - indicating (I think) that the folder is a link. I believe that this links to the location on e: that was specified when the table space was created. The trail starts to run cold here, I think windows links can only be dropped or created (not edited), so how can I move the tablespace? It's currently populated with live data, so I'm trying to establish the correct methodology *before* I start fiddling. Any help appreciated.

Does anyone know how to check from T-SQL code in a stored procedure if a SQL user have read access to a WIN folder that is mapped to the SQL server? Thx Erik

I am trying to run an MSSQL script using sqlcmd on Windows 10. The command is something like this:

sqlcmd -S "host" -U "user" -P "password" -d "database" -C -i "script.sql" -I

where the values here are dummy values. I’m getting the message:

Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server :  Data source name not found and no default driver specified.

I didn’t set up the system, so I don’t know how everything has been installed, but I assume that the sqlcmd was installed with SQLServer Express. When I check the version, I get:

Microsoft (R) SQL Server Command Line Tool
Version 14.0.2052.1 NT
Copyright (C) 2017 Microsoft Corporation. All rights reserved.

I checked the installed drivers and got: I don’t know where to go from here. Is it possible to get sqlcmd to use the relevant driver? Why is it looking for version 13 anyway?

We are facing below errors on MySQL Enterprise Monitor.. While deleting a connection from MySQL Instances it is displaying following error messages. Also it is not deleted event it displays success message. >Cannot shutdown a shutdown connection >Connection refused: connect Any way of doing this? Any table in DB storing information in MySQL databases. MySQL 5.6.21 Windows Platform

As part of a project for a customer of mine, they've given me the complete backup of a physical server (taken by Veeam) which I have then used to make a Bare Metal recovery onto a test VM host I have here (VMWare Workstation Pro) That's all gone fine and windows starts up with all data intact. I'm having issues getting Oracle going though (yes, this is Oracle running on Windows) From what I can tell, all datafiles and log files are in place. However when I try to start Oracle, this happens

> startup
ORACLE instance started.

Total System Global Area 1.6034E+10 bytes
Fixed Size                  2191576 bytes
Variable Size            1.0972E+10 bytes
Database Buffers         5033164800 bytes
Redo Buffers               26554368 bytes
Database mounted.
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: 'F:\DB_DATA\LSTEG\SYSTEM01.DBF'
ORA-01207: file is more recent than control file - old control file

EDIT After speaking with the customer again, they've told me that the DBF / LOG files are screwed by the backup. Their expectation is that the current database be "trashed" and the schemas to be recreated and then the actual database backup dmp files to be reimported But how do you remove all existing schemas if you can't even start the db?

I am attempting to copy off approximately 220 gigs of database MDF and LDF files from a MS SQL server 2000 install in order to transfer ownership to a third party. The error I get when I try to stop the database using the enterprise manager is > Error 1051: A Stop Control Has Been Sent To A Service Which Other Running Services Are Dependent On Going to the service and looking at the dependencies tab does not show any other services running in relation to it. If I stop the actual Windows service, and try to copy it tells me that the databases are still in use. I have changed the service from automatic to manual and rebooted, and it still insists the files are in use. I don't particularly care about copying the log files, but how can I resolve the error to do a clean shutdown and be able to copy off at least the MDF files?

I'm having an error 1045: Access denied for user 'mysqlsuperuser'@'test.internal.cloudapp.net' (using password: YES) when trying to connect Here is the mysqldump command on my ps1 file. $command = [string]::format(""{0}" -u {1} -p{2} -h {3} --default-character-set=utf8mb4 --quick --master-data=2 --single-transaction --routines --databases test1 --add-drop-database --result-file="{5}" ", $mysqlDumpLocation, $databaseUsername, $databasePassword, $databaseIp, $database.DatabaseName, $saveFilePath); But when I try to remove the {2} which is the DB password, then execute the ps1 file. When it prompt me for the password, it goes through.

I have downloaded Cassandra from here https://www.apache.org/dyn/closer.lua/cassandra/5.0.4/apache-cassandra-5.0.4-bin.tar.gz , i have extracted it and set the environment variable as well, but when i run Cassandra or cqlsh i get `is not recognized as an internal or external command, operable program or batch file.` I did look into it's bin folder, and i don't see any exe or bat file's, So how do i run in in Windows? is there something i'm missing? is there any other link's to download it?

I'm trying to find the total size on the hard disk that all of my MySQL Workbench databases are using. Does anyone know of an easy way to figure this out? If nothing else, the default location mysql/workbench uses for saving the raw data on a windows machine? Thanks in advance! Quintis

I have a webapp I'm developing using Symfony 6.4 and Postgres 15. My Employer has given me a windows machine that is locked down and I can not get raised privileges. Anytime i want anything done i have to go through service desk. I have noticed that my PHP/Symfony app runs poorly compared to another (contract) developer who uses a linux distribution - so i figured I would set up WSL2 with ubuntu and try a full app set up there to see if there is a performance issue. I would really like my WSL Postgres AND my Windows Postgres to be accessible in pgAdmin4. I need them both for now while I complete this investigation. Without the admin privileges I cannot stop the windows PostgreSQL service. Has anybody achieved this, or knows how to achieve this? * I have the postgres installed on WSL2 Ubuntu * I have opened the conf file and set listen_addresses = 'localhost' * I have also tried 127.0.0.1 * I have tried setting the port on ubuntu to 5431 (instead of 2) Results: