Forum Widgets
Latest Discussions
Windows could not start the SQL server (SQLEXPRESS) service (macOS)
I have a common problem that I just cannot figure out after scrolling through posts expressing a similar issue. I am currently running a macOS using a virtual machine that has Windows 11. Due to what I understand are compatibility issues in the CPU architecture, I downloaded SQL Server 2019 Localdb. After downloading the engine, I noticed that SQL Server (SQLEXPRESS) is stopped in SQL Server Configuration Manager, but when I try to right click and start, I get the message shown in the pictures with an operating system error 3. initerrlog: Could not open error log file 'C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Log\'. Operating system error = 3(The system cannot find the path specified.). I checked the file paths again and they are all correct. Also, I noticed that the startup parameters were not listed so corrected this issue by going to the Registry Editor and added the strings manually. They were added successfully in the Configuration Manager, but when I go to start the service I get the same error message as above saying that my request failed (Event ID: 17058), but this time the issue is I get an Access Denied: initerrlog: Could not open error log file ‘c:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Log\ERRORLOG’. Operating system error = 5(Access is denied). I went to folder security and granted full access to all the users, but that did not solve the problem. Any help would be much appreciated.Adventureworks data does not load in SSMS
Hello, I am a new member here so forgive me if I am not posting in the right spot. I have been trying to load data using a script for the AdventureWorks database. I used the creation script from the following link: https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssmsver After executing the script, I get "Query completed with errors", but I do not actually know what the errors are. The database was added and I see all of the tables, but when I query the tables, there is no data. For context, I am using a macOS and running a virtual machine with Windows 11 and SQL Server 2019. I am also using SSMS 2022.
Need Help To Get Last Record Based On Column Value
Hi , Below is the sample data, and I need to get the latest record based on last_modified_date, and [active/inactive] columns. ID, Name are the key columns and based on last modified date i need to get the last record If Any of these key columns have 'Active' status, irrespective of last modified date, pull that record else take the latest record of inactive record. the Ideal output should be: 111, AAA, Active,2024-04-21 (Since it has status of active on earlier dates)
Need tips for redesign existing ETL process rely on SQL DB Snapshot for error recovery
We have a long running (10+ hrs) legacy daily ETL process relying on SQL Server DB snapshots for error recovering. I like to get some suggestions on how to rewrite the ETL process wihtout depending on DB snapshot. Existing Logic in SSIS looks like this: ETL Step 1 ETL Step 2 CREATE DB SNAPSHOT of the necessary database(s) TRY ETL Step 3 ETL Step 4 … Last Step of ETL job CATCH Capture error details RESTORE DB SNAPSHOT(S) (taken above) FINALLY DROP DB SNAPSHOT(S) Other information/limitiations: The SQL Server is running on an Azure VM (IaaS). (single node SQL Server instance) The underlying database(s) are very big ( > 10TB each) and therefore taking DB snapshot (instant) is much quicker than taking DB backup There many other SQL databases hosted on that same SQL instance, therefore we can't do Azure VM-level restore. Not ready to migrate this SQL system to Azure PaaS SQL products ( multiple reasons, some are on MS side: such as Azure SQL MI can't support more than 16TB of data, some are on our side: legacy downstream Apps can't connect to Azure PaaS SQL DB) Can't add signficant time to the duration of the ETL job. (waiting additional 2~3 hours to make full DB backup of multiple 10TB+ databases during daily ETL process is not accepable) Job failure happens once every 3 months (or less) Longer recovery time (extra 2~3 hours) and even manual involvement from DBA team to recover from a job failure is acceptable.Integrating External Authentication with Symmetric Encryption in SQL Server
Hello everyone, I am exploring a method to enhance data security in SQL Server by combining symmetric encryption with external authentication (e.g., via a service like Facebook using OAuth). The idea is to condition access to symmetric keys or their usage on successful authentication through an external provider. After reviewing resources like the official SQL Server documentation (Always Encrypted, Extensible Key Management) and whitepapers, I couldn’t find any examples or mentions of such integration. Here are some questions I’m pondering: Is this approach feasible within SQL Server or a similar system? Are there any documented scenarios or implementations that explore similar concepts? What challenges or technical limitations might arise from such an architecture? I’d love to hear your thoughts, experiences, or insights on this idea. Thank you in advance for sharing your expertise! My Best regards Fred
Capturing Latest Effective Date of Current Instance of Position
I am having issues trying to formulate a JOIN statement within my query that will provide the values that I am needing for all employees. Specifically, situations where an employee held the position multiple times. Here my current statement segment: JOIN (SELECT R_POSITION, WORK_ASSIGNMNT, EMPLOYEE, MIN(EFFECT_DATE) AS EFFECT_DATE FROM HR_EMP_POSITIONS GROUP BY R_POSITION, WORK_ASSIGNMNT, EMPLOYEE) AS EP ON EP.R_POSITION = W.POSITION AND EP.EMPLOYEE = W.EMPLOYEE AND EP.WORK_ASSIGNMNT = W.WORK_ASSIGNMNT For my statement, I need to retrieve the latest EFFECT_DATE of the last time the employee held a specific position that matches their current position. Please find my sample document with the EP and W tables. My current statement works for employee A; however, for employee B it is providing the 10/16/2023 date when I need it to populate the 8/26/2024 date. Any ideas on what I can do to get the data that I need? I don't have any other fields that I can use to help refine the criteria.
Delete Statement slowness
Hello, We are running a delete statement on database every weekend where it deletes rows based on the 16 where conditions. It has to pass 16 where conditions before delete more than millions row. Since delete statement itself is resource consuming activity and takes time to delete more than a millions of data. Is it something these many where conditions causing this issue? our DB environment is like :- SQL Server 2022 Ent Version with latest patch TempDB files added considering the number of vCPUS on VM, also TempDB is on separate disk NDF Files of secondary filegroups on separate disk for better throughput MaxDOP is set to default Data and log files are on separate disks. Weekly DB maintenance plan is in place. regards, Nitin
What is the best practice to create documentation for our SQL Server
I know that we have to documents all our risk assessments and backup and recovery strategy but for Database Administrator to handover the task to other Database Admin, is there any best practice what to documents? Also I am aware of the 3rd party tool to help the documentation, but based on your experience what are the important things to document? Thank you
