Skip to content

SYN, SYN-ACK, ACK

Henrik Damgaard

Categories

  • Active Directory (1)
  • MySQL (1)
  • Other (2)
  • PHP (1)
  • Scripting (8)
    • PowerShell (8)
  • System Center Operations Manager (4)
  • Ubuntu (1)
    • GNOME (1)
  • Windows (11)
    • Client (6)
      • Internet Explorer (1)
    • Server (4)
  • WordPress (2)

Anything in here will be replaced on browsers that support the canvas element

  • PowerShell
  • Windows Client
  • Scripting
  • Windows Server
  • EventLog
  • 2007 R2
  • SCOM
  • System Center Operations Manager
  • OpsMgr
  • Windows
  • Command line
  • WordPress
  • database
  • remote
  • COM
  • Attribute
  • PHP
  • Install
  • Virtual Machine
  • FTP
  • Internet Explorer 9
  • Windows Explorer
  • ValidateCount
  • ValidateLength
  • ValidatePattern
  • ValidateRange
  • ValidateSet
  • ValidateScript
  • Events
  • IE9

Visitors

RECENT POSTS

  • How to Change File Properties (ReadOnly, CreationTime etc.) Using PowerShell
  • Hyper-V on Windows 8 (Pro or Enterprise)
  • PDF Search missing in Windows 7 (64-Bit)
  • Running a headless VirtualBox
  • Atheros AR5007 failed to connect (WiFi/Internet)

QR Code

RSS SYN, SYN-ACK, ACK

  • How to Change File Properties (ReadOnly, CreationTime etc.) Using PowerShell 11/04/2013
    Changing file properties is quite easy with PowerShell.   Remove ReadOnly attribute: Set-ItemProperty -Path 'C:\Program Files\desktop.ini' -Name IsReadOnly -Value $false   Change CreationTime (90 days back in time): Set-ItemProperty -Path 'C:\Program Files\desktop.ini' -Name CreationTime -Value ((Get-Date).AddDays(-90))      
    Henrik Damgaard
  • Hyper-V on Windows 8 (Pro or Enterprise) 24/03/2013
    Looking for a hypervisor on Windows 8? Look no further. If your Windows 8 is Pro or Enterprise Hyper-V is available as a feature, and can be enabled easily as long as your system complies with there requirements: Windows 8 Pro or Windows 8 Enterprise (64-bit Operating System) Minimum of 4GB of RAM Hardware Assisted Virtualization […]
    Henrik Damgaard
  • PDF Search missing in Windows 7 (64-Bit) 02/03/2013
    For some reason the 64-bit versions of Windows has a problem indexing PDF files. Windows Search uses IFilter to help it index files, and the PDF IFilter for 64-bit Windows is missing. (This probably applies to 64-bit Vista and 64-bit XP as well). To detect whether a computer has the IFilter installed or not open […]
    Henrik Damgaard
  • Running a headless VirtualBox 05/02/2013
      Use this command to start headless VirtualBox named NameOfVirtualBox: Start /b 'C:\Program Files\Oracle\VirtualBox\VBoxHeadless.exe' -s "NameOfVirtualBox" Or using PowerShell: Start-Process -FilePath 'C:\Program Files\Oracle\VirtualBox\VBoxHeadless.exe' -ArgumentList @("-s","NameOfVirtualBox") -NoNewWindow   Note: If you close your command prompt the processes with your headless VirtualBox will get killed.   Link to VirtualBox manual : http://www.virtualbox.org/manual/ch07.html#vboxheadless
    Henrik Damgaard
  • Atheros AR5007 failed to connect (WiFi/Internet) 10/01/2013
    Problem: This behaviour is seen when connecting a Vista computer with Atheros AR5007 Wireless LAN adapter installed to a new wireless accesspoint. (In this case a HP laptop computer with preinstalled Vista Home Premium connecting to Cisco Linksys EA6500). When inspecting network configuration you will find DHCP-address is assigned correctly – BUT no traffic is recieved […]
    Henrik Damgaard
  • Easy validating parameter input using ValidateCount, ValidateLength, ValidatePattern, ValidateRange, ValidateSet and ValidateScript in PowerShell 14/08/2012
    Windows PowerShell introduced parameter validation which drastically reduces lines of validation code – and replaces it with a couple of markup tags:   ValidateCount (int minLength, int maxlength) How many arguments are allowed for a parameter. [ValidateCount(1,3)] [String[]] $Collection ValidateLength (int minLength, int maxlength) Length (in characters) of a parameter argument. [ValidateLength(1,8)] [String[]] $Phone ValidatePattern (string regexString, Named Parameters) Valid patterns […]
    Henrik Damgaard
  • SCOM Health Service Events when troubleshooting certificate authentication 11/08/2012
    These Events are common when troubleshooting problems related to Health Service certificates i System Center Operations Manager 2007:   21021 – Could not load Certificate Check if certificate exists and the Health Service has permissions to read it.   20052 – Certificate not loaded (name does not match) Make sure Issued To match the actual […]
    Henrik Damgaard
  • Browse FTP site in Windows Explorer (triggered from Internet Explorer 9) 08/08/2012
    By default the option to view FTP site in Windows Explorer is hidden in Internet Explorer 9 (IE9). To enable it you have to go to Internet Options -> Advanced -> Enable FTP Folder View as shown below: Once this option is enabled you should see Open FTP Site in Windows Explorer in the View-menu. (Keep in mind […]
    Henrik Damgaard
  • Blue Screen of Death (BSoD) when putting Windows 7 to sleep 30/07/2012
    All of a sudden my Windows 7 ended up crashing with Blue Screen of Death when put to sleep, and I started investigating this behavior. After a couple of crashes a pattern started to emerge: Blue Screen of Death was only an issue when the laptop was running on batteries – and NOT when AC was […]
    Henrik Damgaard
  • Write Event to Windows Event Log using PowerShell 27/06/2012
      Creating an EventLog entry using PowerShell is shown below: Write-EventLog -LogName 'Application' -Source 'MyEventSource' -EventID 1000 -EntryType Warning -Message "This is a test of writing to the Event Log using PowerShell."   Note: The Event Source needs to be created before writing entries to the Event Log. (See this post for further info: Create […]
    Henrik Damgaard

Tags

  • 2007 R2
  • Adobe
  • AR5007
  • Atheros
  • Attribute
  • Certificates
  • COM
  • Command line
  • database
  • Driver
  • Enterprise
  • EventLog
  • Events
  • Feature
  • FTP
  • Health Service
  • HP
  • Hypervisor
  • iFilter
  • Install
  • Laptop
  • Network
  • OpsMgr
  • PHP
  • PowerShell
  • Pro
  • remote
  • SCOM
  • Scripting
  • System Center Operations Manager
  • ValidateCount
  • ValidateLength
  • ValidatePattern
  • ValidateRange
  • ValidateScript
  • ValidateSet
  • Virtual Machine
  • Vista
  • WiFi
  • Windows
  • Windows 8
  • Windows Client
  • Windows Server
  • Wireless
  • WordPress

Tag: Select

Get size of MySQL database using SELECT statement

Use this MySQL to get size of database:

 

SELECT table_schema "DatabaseName", SUM(index_length+data_length)/1024/1024 "DatabaseSizeMB" FROM information_schema.TABLES GROUP BY table_schema;

 

 

Posted on 27/01/201229/02/2012Author Henrik DamgaardCategories MySQLTags database, MySQL, Select, SizeLeave a comment on Get size of MySQL database using SELECT statement
Proudly powered by WordPress
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok