SysAdmin

How to import and export record from table to another MySQL without import ID

How to import and export record from table to another MySQL without import ID ? Come importare ed esportare record da una tabella mysql a un’altra senza importare l’ID? INSERT INTO databasename.TargetTable (column_list) SELECT column_list FROM databasename.SourceTable Example INSERT INTO newproject.content (desc,author,`fulltext`) SELECT desc,author,`fulltext` FROM oldproject.content Note If you have fulltext field in your column_list, …

How to import and export record from table to another MySQL without import IDLeggi altro »

Kill all processes for specific database on Microsoft SQL Server

Problem: How to kill all processes on Microsoft SQL Server database ? Solution: Applied to: Microsoft SQL Server Execute the follow query on master database and change ‘MyDB’ with your DB: DECLARE @kill varchar(8000) = ”; SELECT @kill = @kill + ‘kill ‘ + CONVERT(varchar(5), spid) + ‘;’ FROM master..sysprocesses WHERE dbid = db_id(‘MyDB’) EXEC(@kill); Best Regards, …

Kill all processes for specific database on Microsoft SQL ServerLeggi altro »

Windows 8.1 – How to view the password of a known Wi-Fi network / Visualizza password wifi

Problem: How to view the password of a known Wi-Fi network Solution: Applied to: Microsoft Windows 8.1 Windows 8.1 – How to view the password of a known Wi-Fi network Once you connect to a Wi-Fi network, Windows will automatically save the password, so that you don’t have to enter it at each connection. If you …

Windows 8.1 – How to view the password of a known Wi-Fi network / Visualizza password wifiLeggi altro »

Best Practices – How to calculate page file size (pagefile) on windows server 2008 R2 / 2012

Problem: How to calculate page file size Solution: Applied to: Microsoft Windows Server 2008 R2 and 2012 http://support.microsoft.com/kb/889654 Use one or more of the following methods to help you calculate page file size. Method 1: Use performance logs to understand the paging activity on your computer Click Start, point to Administrative Tools, and then click …

Best Practices – How to calculate page file size (pagefile) on windows server 2008 R2 / 2012Leggi altro »

e.preventDefault Internet Explorer 8 / 9 / 10 – Object doesn’t support property or method ‘preventDefault’

Problem: SCRIPT438: Object doesn’t support property or method ‘preventDefault’ Solution: Applied to: Internet Explorer 9 and Internet Explorer 10 (but it’s similar for the other). Put the following instructions on your javascript code: if (e.preventDefault) { e.preventDefault(); } else { e.returnValue = false; } If you need more information look on microsoft website (http://msdn.microsoft.com/en-us/library/ie/ms534372(v=vs.85).aspx) Best Regards, …

e.preventDefault Internet Explorer 8 / 9 / 10 – Object doesn’t support property or method ‘preventDefault’Leggi altro »

Reset AutoIncrement field in SQL Server 2008 R2 / 2013

Solution: Applied to: Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 (but it’s similar for the other). To reset auto incremental field in SQL Server you have to execute the following query: DBCC CHECKIDENT (mytable, RESEED, 0) Best Regards, ITquadro – specialized Blog ITquadro consulenti informatici specializzati in ambienti microsoft sql server. Ci …

Reset AutoIncrement field in SQL Server 2008 R2 / 2013Leggi altro »

How to delete folder “this is no longer located in”

Problem: When you try to delete folder (i.e. ABB) on windows you receive “This is no longer located in D:\Cartella1 Solution: Applied to: Microsoft Windows (XP/Vista/7/8) Open CMD (command prompt) as administrator. Go to folder execute DIR/A/P/X Copy alias (ABB~1) and execute command to rename folder execute REN ABB~1 PIPPO Now, it’s possibile to delete folder. …

How to delete folder “this is no longer located in”Leggi altro »