Category Archives: Computers

.NET Framework repair

Microsoft .NET Framework Repair Tool Version 2 of the Microsoft .NET Framework repair tool is available .NET Framework Setup Verification Tool User’s Guide ASoft .NET Version Detector…

Group Policy Debugging

http://support.microsoft.com/kb/325376 How to enable verbose startup, shutdown, logon, and logoff status Message To enable verbose status messages by using Group Policy Object Editor To enable verbose status messages by using Group Policy Object Editor, use the method that is appropriate to your situation: In a domain environment If you are in a domain environment and… Read More »

’ characters or similar on your WordPress site

If you see random â€™ characters or similar on your WordPress site its likely to be an encoding mismatch between your WordPress installation and your MySQL database server. I did the following to fix mine, your mileage may vary. 1. Confirm wp-config.php has the encoding set as UTF8.. /** Database Charset to use in creating database… Read More »

Show locked Tables, Views etc in Microsoft SQL

SELECT DISTINCT object_name(a.rsc_objid) AS object, a.req_spid, b.loginame FROM master.dbo.syslockinfo a (nolock) JOIN master.dbo.sysprocesses b (nolock) on a.req_spid=b.spid WHERE object_name(a.rsc_objid) IS not null ORDER BY object

Opening up SQL server in the Windows Server 2008 firewall

@echo ========= SQL Server Ports =================== @echo Enabling SQLServer default instance port 1433 netsh firewall set portopening TCP 1433 “SQLServer” @echo Enabling Dedicated Admin Connection port 1434 netsh firewall set portopening TCP 1434 “SQL Admin Connection” @echo Enabling conventional SQL Server Service Broker port 4022 netsh firewall set portopening TCP 4022 “SQL Service Broker” @echo… Read More »

David InfoCenter, Internet Explorer 10 (maybe?) and mailto links

David InfoCenter, Internet Explorer 10 (maybe?) and mailto links resulting in the following window… Windows Internet Explorer Could not perform this operation because the default mail client is not properly installed And once you press Ok, a hundred (or so) iexplorer.exe processes run. Cause I believe missing registry keys in HKEY_LOCAL_MACHINE\Software\Classes\mailto. Attached is a reg… Read More »

degree2decimal

DROP FUNCTION IF EXISTS `degree2decimal`; CREATE DEFINER = `root`@`localhost` FUNCTION `degree2decimal`(deg_coord float) RETURNS float BEGIN #converts NMEA/GPS Lat -Long to Decimal Degrees. Code comments are self explanatory. #The code is not graceful, but it works. declare degree INT; declare minutes2 FLOAT; declare dotdegree FLOAT; declare decimal2 FLOAT; set degree= (deg_coord/100); set minutes2 = deg_coord-(degree*100); set… Read More »

Common Places to look for Viruses

HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Winlogon REG_SZ : Shell : “C:\Users\Administrator\AppData\Roaming\dbu32.ocx,explorer.exe” There should be no Shell value

VSS Snapshot warning. File %BeBootDrive%\bootmgr is not present on the snapshot.

VSS Snapshot warning. File %BeBootDrive%\bootmgr is not present on the snapshot. Workaround: Exclude the ASR writer from the list of approved writers ASR writer id is ‘{BE000CBE-11FE-4426-9C58-531AA6355FC4}’. 1. Go to:  Start > Run, key in regedt32 press Enter. 2. Then go to the HKEY_LOCAL_MACHINE\SOFTWARE\Symantec\Backup Exec for Windows Servers \Engine\Shadow Copy Components\ 3. Then create a new Additional… Read More »

Find all the netblocks owned by a particular organisation

On 2013-03-20 at 11:55 +0100, DTNX Postmaster wrote: > I’ve looked up quite a few now, and they are all Crystone ranges, > belonging to their various European subsidiaries. There doesn’t seem to > be an easy way to show all IP ranges belonging to ‘CR422-RIPE’, but > that could very well be a lack… Read More »

Get the size of all the tables in the databate you’re currently using.

SELECT t.NAME AS TableName, p.rows AS RowCounts, SUM(a.total_pages) * 8 AS TotalSpaceKB, SUM(a.used_pages) * 8 AS UsedSpaceKB, (SUM(a.total_pages) – SUM(a.used_pages)) * 8 AS UnusedSpaceKB FROM sys.tables t INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id INNER JOIN sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id INNER JOIN sys.allocation_units a ON p.partition_id = a.container_id… Read More »

Printing not working on RDP session even though printers are visible in RD session (ie drivers installed and sent with session etc)

Cause: Besides having the role of Terminal Services in Application Mode installed, you also installed the role of a Domain Controller (DC) When a DC is being configured as a TS server, there is a standard warning message which states: “Installing Terminal Services on a Domain Controller is not recommended. Do you want to continue?”… Read More »

No more connections can be made – when joining domain

Check time on DC and workstation is within 5mins 😉 Also… One additional thing I found very handy was the ability to join the domain using a specific server. The best way I found to do this in our situation was with powershell. All systems were Windows 7. Open powershell Type add-computer -? Specifically: “add-computer… Read More »

In DNS zone domain.local, your local server is not in the name server records . Migration will fail without fixing this issue. Go to http://support.microsoft.com/kb/2578426 for more details.

Group Policy installation failed error 1274

You’re seeing the dreaded scourge of asynchronous policy processing. It’s not a “feature” (and was default-off in Windows 2000 but default-on in Windows XP and above) and causes exactly what you’re seeing– non-deterministic behavior with processing some types of GPO settings. In a GPO that applies to that computer, add the following setting: Computer Settings Administrative Templates… Read More »

Keeping FreeBSD’s base system and packages up-to-date

PART I. Keeping the FreeBSD base system up-to-date Some facts about FreeBSD’s base system: — once RELEASE is completed, there are only security fixes, there are no bug fixes — bugs in STABLE tree are fixed — security issues are also fixed in STABLE — the RELEASE branch allows to use binary updates via freebsd-update… Read More »