Windows

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 »

How to shrink transaction log on mirror database (Microsoft SQL Server).

Solution: Applied to: Microsoft SQL Server 2008 R2 (but it’s similar for the other). To shrink transaction log manually on mirror database (Microsoft SQL Server) you have to follow these steps: Verify mirroring database: database must be in Principal, Synchronized state. Execute query: USE Databasename BACKUP LOG Databasename TO DISK = N’D:\Backup\DatabaseName_log.bak’ GO DBCC SHRINKFILE(‘DatabaseLogicalName_Log’, 1) …

How to shrink transaction log on mirror database (Microsoft SQL Server).Leggi altro »

Bring online database (access denied) Microsoft SQL Server 2012 BI – Accesso negato mettendo online un database

Problem: If you try to bring online a database and you receive “access denied” probably it’s possible, if you are an administrator with grant rights, that .mdf file doesn’t have right permissions. In my case the problem was NT Service/MSSQLSERVER or NT Service/MSSQLSERVER$IstanceName Solution: right click on .mdf file –> Properties –> Security — Edit –> …

Bring online database (access denied) Microsoft SQL Server 2012 BI – Accesso negato mettendo online un databaseLeggi altro »