How to connect to the WSUS SQL Database

1. Install SQL Management Studio on the Server
2. Run it and use following string as your server:
    \\.\pipe\mssql$microsoft##ssee\sql\query

No Comments »

admin on November 29th 2012 in IT, MSSQL

Quick and Dirty MS Database Analysis

This method queries all tables in a database and it displays the top 10 rows.

Get all tables with the following query:
SELECT name FROM ssysobjects WHERE type = ‘u’;

Copy&Paste it into Excel A Column and put following Formula into B Column for each row:
="SELECT TOP 10 * FROM " & A1 &";"

Result will be something like this:
SELECT TOP 10 * FROM COMPANY; SELECT TOP 10 * FROM PEOPLE; SELECT TOP 10 * FROM BILLS;

Run this query in Microsoft Management Studio an analyse the result.

No Comments »

admin on February 4th 2012 in MSSQL

Backup and Restore MySQL Complete

I had to backup and restore a MySQL database on a debian linux machine to another server at work. First I tried to do it trough phpmyadmin which is not very efficient when it comes to big db. So I decided to do it through the MySQL command prompt.

Backup all dbs command into a dump file
mysqldump -u root -p –all-databases > xxxxxxx.sql

Restore all dbs command from a dump file
mysql –f -u root -p < xxxxxxx.sql

Of course you need to replace x with the filename you would like to use.

As always… it worked for me but there is no warranty. You need to decide yourself if you want to use it!

No Comments »

admin on May 4th 2008 in MySQL




Check out new movies online website. Download and buy movies now.
1