Author: volt
-
Wolfenstein – The New Order: Il soldato Blazkowicz torna al fronte
Era da un po’ che volevo scrivere di questo titolo anche se l’ho ormai concluso da qualche mese. In realtà è un titolo di prima fascia del 2014 ma con un po’ di pazienza, sfruttando i saldi di Steam, il prezzo è sceso e l’acquisto è diventato praticamente un obbligo. Da anni non giocavo con…
-
No Man’s Sky: esploratori di un universo sconosciuto
Cos’è “No Man’s Sky”? E’ un gioco di esplorazione spaziale in cui vestite i panni di un avventuriero, risvegliatosi dopo un incidente e completamente disperso su uno dei tanti pianeti di un’immensa galassia. A vostra disposizione avete sola la vostra astronave, da riparare, la vostra tuta di sopravvivenza con relativo zaino e un oggetto singolare,…
-
AlwaysOn : Manually add a new replica node using a custom backup path with custom credentials
Management Studio wizards are powerful and can do many things automatically… but sometimes you have to do something manually. In this case we have to do manually backup and restore steps before running the ‘Add node Wizard’ in Join mode. This because the add process cannot impersonate a custom user to access a remote backup…
-
MovieMania! v.1.0
UPDATE: v.1.0 is no longer supported and it’s no downlodable anymore. Go to MovieMania! v.2.0 FREE Movie Mania is a movie library manager, developed as a personal project. You can use it to catalog your downloaded movies, your DVDs and BlueRays. Choose a folder to scan and see how Movie Mania finds covers and informations…
-
Recover a database with a DAMAGED and/or LOST log file
In this procedure we’ll manage one of the worst situation a DBA has to manage: corrupted files and data loss. When this heppen usually the common way is restoring but we’ll use sql server features to reduce stop time (avoiding a complete restore) and data loss. Possible starting problems: Corrupted logfile Corrupted logfile during a…
-
Monitoring Wait Events of a single Session or Query in SQL Server
Using sys.dm_os_wait_stat is not useful for deep troubleshooting because this view contains wait events for ALL processes/queries running on your instance since last restart. Using command “DBCC SQLPERF (‘sys.dm_os_wait_stats’, CLEAR)” we can reset this view with no restart but on big and stressed instances with many processes and applications running this isn’t a real good…
-
How to script logins with the original password HASH and original SID
A quick tip useful to avoid problems during migrations. This query allow to script instance users with orginal SID and password HASH. This can be very useful to transfer logins to a new or different instance. All informations come from master database catalog. You have to be member of sysadmin role to run correctly this…
-
How to improve mysql performance using CACHING
A deep analisys of a performance bottleneck could be long and is based on different kind of data (OS metrics, IO performance tests, DB wait stats and so on…). Before starting with this (or simply after a new delivery) some simple checks could help you to correct rapidly some of the common (and bigger) bottlenecks…
-
Massive SQL Server Database Moving Using Detach – Attach: The Complete Procedure
This is a complete configurable metascript, prepared to create detach statements, file move statement and re-attach statements for every database in your instance. You have only to configure the final destination for datafiles and the database list you want to migrate. The final generated script for every database selected will be something like this (remembar…
-
Anayze SQL default trace to investigate instance events
Quering default trace is the best way to investigate unusual or critical events heppened in SQL server and not logged in errorlog files. It’s not difficult to find useful informations there but the trace is full of codes to translate to make it more readable and useful. This is my query, based on sys.fn_trace_gettable function…