User contributions
Jump to navigation
Jump to search
- 00:44, 9 November 2019 diff hist +314 N Use Samba to copy file to Windows Created page with "<blockquote><pre> smbclient //<WINDOWSSERVERNAME>/<SHAREDIRNAME> -A myauth.auth -c "put <sourcefilename> <windowspathname><destinationfilename>" </pre></blockquote> myauth.au..." current
- 00:44, 9 November 2019 diff hist +116 N Yesterday's Date Created page with "<blockquote><pre> date -d '1 day ago' </pre></blockquote> <blockquote><pre> date -d 'yesterday' </pre></blockquote>" current
- 00:44, 9 November 2019 diff hist +138 N Check O/S Version Created page with "uname -a Also ... '''Linux:''' cat/etc/issue '''AIX:''' oslevel oslevel -r (shows technology level) oslevel -s (shows service pack}" current
- 00:44, 9 November 2019 diff hist +225 N Chmod Created page with "Instead of having to work out the numeric settings for chmod, the following conventions can be "literally" used: <blockquote><pre> chmod u+rwx chmod g+rwx chmod o+rwx chmod..." current
- 00:43, 9 November 2019 diff hist +174 Tasks current
- 00:41, 9 November 2019 diff hist +368 N TSM Command Line Restore Created page with "To restore files through TSM command line and pick what is needed. Note: destfile not required if restoring to original source directory. <blockquote><pre> dsmc restore "/pat..." current
- 00:41, 9 November 2019 diff hist +53 N Tasks Created page with "TSM Command Line Restore"
- 00:40, 9 November 2019 diff hist +35 MediaWiki:Sidebar current
- 00:38, 9 November 2019 diff hist +1,187 N Random Image Generator Created page with "On my [http://www.nazimcricket.com website] I had been using a third party Javascript random image generator which scrolled through my /images folder and displayed a random im..." current
- 00:38, 9 November 2019 diff hist +813 N Global Parameters Created page with "New to MySQL, but will make notes for my benefit, and for the odd person who stumbles on this post via Google. I need to write a few cron scripts for a MySQL database and I do..." current
- 00:37, 9 November 2019 diff hist +43 Gen-Tasks current
- 00:37, 9 November 2019 diff hist +442 N Spooling Out Created page with "Thanks to my friend LW for helping sort this one out. You can increase the verboseness (is that a word?) of a batch output logfile in MySQL, by repeating the "-v" switch...." current
- 00:36, 9 November 2019 diff hist +5,611 N Script to Backup and Restore a MySQL Database Created page with "'''Requirements'''<br> * Obtain a simple backup of a Production MySQL database. * Send backup to TSM Tape Storage Device. * Copy the files to a Non-Production MySQL database s..." current
- 00:36, 9 November 2019 diff hist +227 N Gen-Tasks Created page with " Script to Backup and Restore a MySQL Database Spooling Out === MySQL and PHP (The Perfect Match) ===..."
- 00:34, 9 November 2019 diff hist +9 MediaWiki:Sidebar
- 00:33, 9 November 2019 diff hist +36 MediaWiki:Sidebar
- 00:31, 9 November 2019 diff hist 0 MediaWiki:Sidebar
- 00:31, 9 November 2019 diff hist 0 MediaWiki:Sidebar
- 00:29, 9 November 2019 diff hist +2,598 N Email Results of a Database Export Created page with "Had to write a batch script to check on the status of a nightly database export and email out the Status. Some of what I've done may not be perfect, but it does the job nice..." current
- 00:29, 9 November 2019 diff hist +1,371 N Services Manipulation Created page with "To stop, start or check status of a Service remotely, you can use the sc utility as follows: <blockquote><pre> sc \\servername stop ServiceName sc \\servername start Service..." current
- 00:29, 9 November 2019 diff hist +412 N Count Network Connections Created page with "To get a count of the number of network connections on a Windows server, you can use the following batch script: <blockquote><pre> REM list network connections and write them..." current
- 00:28, 9 November 2019 diff hist +786 N Tree Directory Listing Created page with "A good way to list your files and folders. '''Syntax''' <blockquote><pre> Drive:\Path Drive Letter and Directory Name /f Displays File Names in each Director..." current
- 00:28, 9 November 2019 diff hist +62 N Check Server UpTime Created page with "<blockquote><pre> systeminfo | find "Time" </pre></blockquote>" current
- 00:28, 9 November 2019 diff hist +285 N General Created page with " Email Results of a Database Export Services Manipulation Count Network Connections | Count Network Con..." current
- 00:27, 9 November 2019 diff hist +31 MediaWiki:Sidebar
- 00:25, 9 November 2019 diff hist +93 N Check Database Uptime Created page with "<blockquote><pre> SELECT sqlserver_start_time FROM sys.dm_os_sys_info; </pre></blockquote>" current
- 00:25, 9 November 2019 diff hist +55 N Check Database Version Created page with "<blockquote><pre> SELECT @@version; </pre></blockquote>" current
- 00:24, 9 November 2019 diff hist +451 N Clone Role with Securables Created page with "<blockquote><pre> declare @RoleName varchar(50) = '<ROLE_NAME>' declare @Script varchar(max) = 'CREATE ROLE ' + @RoleName + char(13) select @script = @script + 'GRANT ' + p.p..." current
- 00:24, 9 November 2019 diff hist +791 N Check Mirror Status Created page with "A handy SQL contributed by Andrew R. <blockquote><pre> SELECT left(a.name,50) 'Database' , CASE b.status WHEN 0 THEN 'Suspended' WHEN 1 THEN 'Disconnected'..." current
- 00:24, 9 November 2019 diff hist +1,016 N Querying Active Directory Members for SQL Server Databases Created page with "This is a rather convoluted way of approaching the task required, but does also provide a degree of flexibility. I needed to write a script to obtain a list of members of use..." current
- 00:23, 9 November 2019 diff hist +126 Various-Tasks current
- 00:23, 9 November 2019 diff hist +206 N Various-Tasks Created page with "Clone Role with Securables Check Database Version Check Database Uptime Check Mirr..."
- 00:22, 9 November 2019 diff hist 0 MediaWiki:Sidebar
- 00:21, 9 November 2019 diff hist +46 MediaWiki:Sidebar
- 00:19, 9 November 2019 diff hist 0 Creating an Oracle Database with Apex on AWS RDS current
- 00:19, 9 November 2019 diff hist +4,893 Creating an Oracle Database with Apex on AWS RDS
- 00:18, 9 November 2019 diff hist 0 N File:Ss9.png current
- 00:18, 9 November 2019 diff hist 0 N File:Ss8.png current
- 00:18, 9 November 2019 diff hist 0 N File:Ss7.png current
- 00:18, 9 November 2019 diff hist 0 N File:Ss6.png current
- 00:17, 9 November 2019 diff hist 0 N File:Ss5.png current
- 00:17, 9 November 2019 diff hist 0 N File:Ss4.png current
- 00:17, 9 November 2019 diff hist 0 N File:Ss3.png current
- 00:17, 9 November 2019 diff hist 0 N File:Ss2.png current
- 00:17, 9 November 2019 diff hist 0 N File:Ss1.png current
- 00:16, 9 November 2019 diff hist 0 N File:Og5.png current
- 00:16, 9 November 2019 diff hist 0 N File:Og4.png current
- 00:16, 9 November 2019 diff hist 0 N File:Og3.png current
- 00:16, 9 November 2019 diff hist 0 N File:Og2.png current
- 00:15, 9 November 2019 diff hist -8 Creating an Oracle Database with Apex on AWS RDS