SQL SERVER – Unable to Start SQL When Service Account is Removed From Local Administrators Group. Why?

https://blog.sqlauthority.com/2017/07/12/sql-server-unable-start-sql-service-account-removed-local-administrators-group/ One of my clients wanted to secure their SQL Server. One of the rules was that wanted to avoid running SQL Server service with an account which is part of local “Administrators” group. They wanted to provide the minimal permissions needed for the SQL server service account for SQL Server to function. Below are […]

How to change the default MSSQL directory for database files?

https://support.plesk.com/hc/en-us/articles/115002175809-How-to-change-the-default-MSSQL-directory-for-database-files- QuestionThe default directory for storing database files of MS SQL is changed in SQL Management Studio > Database Settings > Database default locations to D:\MSSQL\DATA .However, new database files are being created and stored in %plesk_dir%\Databases\MSSQL\MSSQLXXX.MSSQLSERVER\MSSQL\DATAanyway.How to change the default directory for MS SQL?How to move SQL databases to other disk drive?AnswerBy default, the location for new databases in SQL […]

Check MSSQL status

CREATE TABLE #sp_who2 (SPID INT,Status VARCHAR(255),      Login  VARCHAR(255),HostName  VARCHAR(255),       BlkBy  VARCHAR(255),DBName  VARCHAR(255),       Command VARCHAR(255),CPUTime INT,       DiskIO INT,LastBatch VARCHAR(255),       ProgramName VARCHAR(255),SPID2 INT,       REQUESTID INT) INSERT INTO #sp_who2 EXEC sp_who2SELECT      * FROM        #sp_who2— Add any filtering of the results here :WHERE       DBName <> ‘master’— Add any sorting of the results here :ORDER BY    DBName ASC DROP TABLE #sp_who2 Source: https://www.sqlmatters.com/Articles/sp_who2%20-%20filtering%20and%20sorting%20the%20results.aspx

Những lời khuyên chân thành giúp thay đổi cuộc đời bạn

Source: https://quantrimang.com/nhung-loi-khuyen-chan-thanh-giup-thay-doi-cuoc-doi-ban-159909 Cuộc sống của bạn giống như những cuốn sách, có chương vui vẻ, hạnh phúc nhưng cũng có những chương đầy trầm lắng, biến động. Hãy vui vẻ đón nhận những thử thách những hạnh phúc, bớt than phiền từ cuộc sống. Đọc và cảm nhận những lời khuyên ý nghĩa từ Status hay […]