Monthly Archives: January 2017

SQL query to another server

How to send a query to another server, while being attached to the first server? There are two ways, from MSSQLSMS (Microsoft SQL Server Management Studio) : 1) Servers are linked : 2) Under MSSQLSMS all the servers we wish … Continue reading

Posted in WIN | Tagged , , | Comments Off on SQL query to another server

SQL query : computer name

1) How to get computer name using SQL query : select ServerProperty(‘ComputerNamePhysicalNetBIOS’); 2) And some additional info concerning SQL : select ServerProperty(‘ComputerNamePhysicalNetBIOS’),ServerProperty(‘Edition’); 3) Product version : select ServerProperty(‘ComputerNamePhysicalNetBIOS’),ServerProperty(‘MachineName’),ServerProperty(‘Edition’),ServerProperty(‘ProductLevel’); Nore : first two items usually give the same output, so I … Continue reading

Posted in WIN | Tagged , , | Comments Off on SQL query : computer name

SQL query : CPU and RAM that DB uses

Query depends on the SWL server version that is being queried. Query should always be done on “master” DB, soa s to gain data for the whole server : The data gained from sys.dm_os_sys_infodepend on the SQL server version (link) … Continue reading

Posted in WIN | Tagged , , , | Comments Off on SQL query : CPU and RAM that DB uses

Crochet 55 : head band

I had a bit of a grey wool handy, so….. 🙂 And the pattern I worked to :

Posted in Relaxation | Tagged , , | Comments Off on Crochet 55 : head band

WIN 2008 and a “Disc Cleanup” option which does not exist here

There is no option “Disc Cleanup” on WIN 2008. To activate it, the following must be done : 1. Activate option “Desktop Experience” (link), which necessitates server restart before it activates OR 2. Copying of two already existent files (link) … Continue reading

Posted in WIN | Tagged , , | Comments Off on WIN 2008 and a “Disc Cleanup” option which does not exist here

Web browser and a unwanted “startfenster.de” (browser hijacker)

My start conditions : WIN 7, IE 11, Chrome 54.0 If you have “caught” a unwanted addition in your web browser, of type : ” http://www.startfenster.de/suche/ as the homepage”, here is what is to be done : WIN OS From … Continue reading

Posted in WIN | Tagged , , | Comments Off on Web browser and a unwanted “startfenster.de” (browser hijacker)

SQL queries

I am starting to work a bit with MS SQL. Up until now all I have done were some small MySQL queries. Good link for beginners, like me. ***** A few things to begin with : SQL stands for Structured … Continue reading

Posted in WIN | Tagged , | Comments Off on SQL queries

Carrot cake

Ohh yes, and it turned out great! Dough : 4 whole eggs 2 cups of flour 2 cups of sugar 1/2 cups of sunflower oil grated carrot (I put about 1/2kg) 1 backing powder 100gr of raisins 2/3 cup of … Continue reading

Posted in Kitchen | Tagged , | Comments Off on Carrot cake