I had a case recently about their server that have zero 0 space remaining in their drive C. i have seen this issue before and it involves the dump files collected every time the server is restarted.
The path to the dump files can be “C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log\Polybase\dump”
Another path is “X:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log”
Recently i have searched if there was a way to turn it off
Some have version folders
Version
Path
SQL Server 2019
C:\Windows\SysWOW64\SQLServerManager15.msc
SQL Server 2017
C:\Windows\SysWOW64\SQLServerManager14.msc
SQL Server 2016
C:\Windows\SysWOW64\SQLServerManager13.msc
SQL Server 2014
C:\Windows\SysWOW64\SQLServerManager12.msc
SQL Server 2012
C:\Windows\SysWOW64\SQLServerManager11.msc
net start “SQL Server (MSSQLSERVER)”
next i found is the data collector
USE msdb; GO EXEC dbo.sp_syscollector_disable_collector;
Hey guys, i have been experimenting with smtp and gmail for sending to clients using php. Found this wonderful article and thought of saving it here on my blog as a keepsafe. Unfortunately, bobcares does like his blogs to be posted anywhere else. Such a shame.
Anyways, hope you enjoyed the research. It helped me through mine.
Leave some comments blow.
Coffee Cup
phpmailer-smtp-error-password-command-failed
Stuck with PHPMailer – SMTP error password command failed? We can help you.
We may come across this error when we try to send mail using phpmailer().
We can check whether phpmailer is set as SMTP with SSL.
This will work if our SMTP server is Gmail.
Solution 4: Change SMTPSecure value from SSL to TLS in phpmailer() code.
Solution 5: In the case of Gsuite
In such a case, we have to solve it as the Administrator.
Go to Admin panel >> Security with Shield icon >> Basic settings
Then go to the Less secure apps section
Now we select one of the Radio Button:
a) Disable access to less secure apps for all users (Recommended) b) Allow users to manage their access to less secure apps c) Enforce access to less secure apps for all users (Not Recommended)
Generally, if option a) does not work, it will start to work with the c) option.
Solution 6: In the case of cPanel/WHM servers
This is related to a security feature in WHM/cPanel.
Firstly, log in to CPanel
Navigate to Tweak Settings > All > “Restrict outgoing SMTP to root, Exim, and mailman”
Instead of -password: Fetch password from the file so it is not visible in the command line. When <filename> is stdin, the user will be prompted for the password. [Firebird 2.5]
Database Shutdown
When a database has been shut down, only SYSDBA and the database owner are able to connect to the database in order to perform administrative tasks.
Options
-at[tach] <seconds>
Used with the -shut option. Waits <seconds> seconds for all current connections to end. If after <seconds> seconds there are still connections open, the shutdown will be cancelled and return an error.
-f[orce] <seconds>
Used with the -shut option. Waits <seconds> seconds for all connections and transactions to end. After this time, all connections and transactions are cancelled and the database is shut down. Use with caution.
-o[nline]
If a -shut operation is pending, it is cancelled. Otherwise, takes a database back online
-sh[ut]
Shut down database. Must be used together with -attach, -force or -tran
-shut {normal | multi | single | full}-online {normal | multi | single | full}
Firebird 2.0 and later: New shutdown modes:NORMAL: Database is active and online MULTI: Only connection from SYSDBA and the Database Owner will be allowed (compatible mode with Firebird 1.0/1.5) SINGLE: Only one SYSDBA or Database Owner connection will be allowed FULL: Exclusive shutdown: Database is completely offline, no connections will be allowed (it is now possible to access the database file safely on a file basis, e.g. for backups)Use -shut to “go down” the scale of shutting down and -online to “go up” that scale.
-tr[an] <seconds>
Used with the -shut option. Waits <seconds> seconds for all running transactions to end. If after <seconds> seconds there are still running transactions, the shutdown will be cancelled.
Examples
Shut down database, wait 60 seconds until all connections are closed
Blogger – collaboration / click per view / online courses
Property Management – shove snow / mow loan / doing maintenance / show apartments / get landlord / collect cash
Drop shipping – no handling fees / marketing / advertising / list amazon / eBay / manufacturer / send to customer / sell using own brand / online store / market place / Lazada and Shopee
Affiliate Marketing – indirect influencer / niche / affiliate / click bait / amazon / follow link / blog or social media / talk makeup put links / clink juncsion
Errand / Services – grocery / chores / dry cleaning / super assistant to busy boss / DTI / payroll
Interior Design – design for clients / consultation
Photography – stock photos / decent camera
Advertising – newspaper commercials / book or website / put qr code / google ads / seo
Free Premium – model certain features are free and certain features are not. Gmail storage limit / WordPress platform with add-in template and plug-ins
Subscription – Milkman deliver milk and take the money. Recipe / Nike sign0up / Coffee patrons
To earn money we have 7 options starting with R. When i first heard this one I was amazed on how simple it is. A lesson worth hearing him in person on Youtube
RATE – This pertains to the selling price of items.
RENUMERATION – This refers to profession such as doctor or lawyer
REPLICATION – Refers to man and machine or automation. the lesser the workforce, the more money the business can save
RENT – This refers to rental income or property appreciation.
ROYALTY – This refers to a product from your talent. It may be a game such as Candy Crush, or a YouTube video and blog
RIGHTS – This refers to franchises, brand and logo
RETURNS – This refers to stock market, gold or silver , properties , interest , dividends and appreciation
These are tried and tested rules for the rich and those who want to become one. All of these rules we need to keep near our financial wallets in order to survive. There they are
Start your purpose for wallet fattening – Save 10% from 100% income. So far this is the hardest part and we start with this one. A famous rich person once said, it’s either you increase your income or you shrink to your income.
Control thy expenditures – Budgets are good in these situations. We need to sacrifice today, for our financial situation to improve in the future.
Put each coin to labor – This means to have investments in things that produce more money. A simple example of this is the bank account. But nowadays, people invest in digital investments that give 2% to 3% interest.
Guard thy treasure from loss – The people we lend money must have the power to repay it back. We need security to the risk. We can do this by issuing a collateral.
Make thy dwelling a profitable investment – If you buy a house, make sure you do not overpay for it. As a rule of thumb, you need to provide security and make wifey happy.
Ensure a future income – We also need to plan for the future. Invest or become a money lender. That is called leverage. It can also give protection to the family.
Increase they ability to learn – Cultivate skills and build confidence in yourself. Learn from the masters you want to reach.
Recently i encountered a problem that doesn’t allow me to add a shared printer. It seems to be new so it might have something to do with the windows update.
Then i found the solutions. Its to add a registry entry. here it is :
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Print\RpcAuthnLevelPrivacyEnabled to 0
Recently I have download Microsoft SQL Server for a small interesting project I was working. Then all of a sudden, my hard disk space became 0 in my Drive C.
Puzzled for a few days a encountered a blog post that featured a nifty little software that I will now keep in my software belt.
It shows you the disk size of each folder in your pc. Quite a good find. The name of the software is TreeSize Free version.
So just in case you are working on a project in Microsoft SQL Server, be sure that the hard disk space will be close to zero, unless you can clean the dump folder.