When you install VisualHG in Windows 8 you have to run from a command prompt (as administrator): “C:\Program Files (x86)\Microsoft Visual Studio 11.0\Common7\IDE\devenv” /setup
after this just open VS as usual.
Sometimes we just need to query our development DB.
So now we have a websql DB and we need to perform the same operation. Chrome’s developer tools only show you the data, there is no way (afk) to query it.
WebSQL is SQLite, so just load Firefox with SQLite Manager Add-on and open the database.
In a Windows system the database is located somewhere like “C:\Users\USER\AppData\Local\Google\Chrome\User Data\Default\databases\http_localhost_0\SOMEFILE”
This way you are able to query the data.
See now why you must very careful with kind of data you store in websql (or other web storage).
My suggestion:
USE AdventureWorks2008R2;
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE AdventureWorks2008R2
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (AdventureWorks2008R2_Log, 1);
GO
-- Reset the database recovery model.
ALTER DATABASE AdventureWorks2008R2
SET RECOVERY FULL;
GO
from : http://msdn.microsoft.com/en-us/library/ms189493.aspx
you may want to backup first
More solutions in:
http://stackoverflow.com/questions/56628/how-do-you-clear-the-transaction-log-in-a-sql-server-2005-database/7952692#7952692
For several years I have been a huge Resharper’s fan, but now with the new version and a new license I start to look for a cheaper solution and came across with this free alternative from DevExpress, CodeRush Xpress.
Take a look at this:
http://msdn.microsoft.com/en-us/vstudio//ee663901.aspx
Modules for PHP script using system process interfaces Fedora 17
#yum install php-process
in my dev machine (Fedora Core 17):
Fatal error: Class ‘DOMDocument’ not found in /var/www/html/(…)/XmlFileLoader.php on line 214
solution:
#yum install php-xml
depois reiniciar o Apache:
#service httpd restart
sudo add-apt-repository ppa:webupd8team/gnome3
sudo apt-get update
sudo apt-get install mgse-bottompanel mgse-menu mgse-windowlist gnome-shell-classic-systray
Fica aqui um pequeno aplicativo para descobrir passwords WPA padrão de redes Thomson.
Usem apenas para as redes para as quais tenham autorização.
A primeira execução demora um pouco. As chaves são pré-geradas nesta primeira inicialização e é criado um ficheiro com essas chaves.
Ficam os dois links (com chaves já geradas, apenas o aplicativo):
Apenas aplicativo: Thomson.zip – 7.4 KB
Aplicativo + ficheiro de passwords: Thomson-password-generator.zip – 143.8 MB
function get_tableGeomDims(tablename in VARCHAR2)
return integer
is
vsize integer;
begin
SELECT count( * )
INTO
vsize
FROM user_sdo_geom_metadata
,table(user_sdo_geom_metadata.diminfo)
WHERE UPPER(table_name) = UPPER(tablename);
return vsize;
end get_tableGeomDims;
Permitirá saber as dimensões permitidas numa tabela. Consegue-se assim saber de numa tabela os dados são 1,2,3 ou 4D.