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;
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
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.
This question was raised to me recently and it peeked my interest to solve and find out how to do this. After digging around i found 2 working codes for my case.
To explain further my tables are generated dynamically so the column widths and gaps differ by each refresh of the table
Recently I purchased a new laptop and had tried to install a lot of my legacy software. One of them suddenly popped out a message saying ” Error 432. Setup has detected that unInstallShield is in use. Please close unInstallShield and restart setup. “
You need to be logged in as the computer’s Administrator.
Delete an instance of the file IsUninst.exe from the C:\Windows directory. If the file cannot be deleted, you need to reboot the machine and try again.
I have included a picture to show where the file is located
There was a requirement before that the webpage needs to be converted to any language that the guest will be coming from.
So I got digging and found the code that will let Google translate convert it on the fly. Take note that this might need a few web source tinkering.
Here it is :
And the output you will see is :
I’m not sure why I cannot copy and paste code to WordPress for now. I am suspecting that you cannot copy <DIV> statements. But soon I will know why. But for now, a screenshot will do.
Now, of course, there is a downside to using this one. The translation going back from Chinese-to-English for example might not yield the same result. Just be careful if you are using words like Parent’s Portal that might be translated as an intergalactic dimension.
Just to be safe, we can keep it to plain or simple words that google can understand.
Hi guys, I’m happy to be back inspired to make my own youtube channel and promoting the sharing of knowledge to those who try to survive in this COVID-19 pandemic.
When you see my first video, the screen on Powerpoint seems to have empty spaces on the left and right side of the screen, so I had to research how to make it look like the DVD player version once I upload it to youtube.
My goal is to use PowerPoint presentations and background music to share what I know and how to solve daily problems in computers.
Here are the steps :
Select the Design tab of the toolbar ribbon.
Select the Slide Size Slide Size icon near the far right end of the toolbar.
Select Standard (4:3 aspect ratio) or Widescreen (16:9) or Custom Slide Size.
Now your excel should look like this one
And for those who are curious on what software I use to convert Powerpoint into Movie is that i use Ppt To Video Convert.
Comment below and let me know there’s anything I can help.
