Author Archives: velda.ebel

Zabbix and SNMP for disk monitoring on WIN 2008 server

WIN 2008 server 1. Install SNMP service on WIN 2008 (it is a “Feature”) 2. Restart WIN server (so SNMP can be configured) 3. Configure SNMP service (community, define SNMP/Zabbix server, give read-only rights) Zabbix server – basics 1. Set … Continue reading

Posted in WIN | Tagged , , , , | Comments Off on Zabbix and SNMP for disk monitoring on WIN 2008 server

SQL DB structure

Excellent link concerning the strategy, design and DB forming. Short and to the point explanation in a youtube tutorial. Primary Key Each table should have a column (or a set of columns), called primary key, that uniquely identifies every records … Continue reading

Posted in WIN | Tagged , , | Comments Off on SQL DB structure

Creation of a MS SQL test DB and DB security

OpΕ‘te stavke : You can do only three things with any database object, other than actually use it; you can create it, alter it, or drop it to get rid of it. Unless permissions are explicitly assigned, only members of … Continue reading

Posted in WIN | Tagged , , , | Comments Off on Creation of a MS SQL test DB and DB security

SQL query by using MS SQL SMS (1)

Before writing a query you should point it to a certain DB (By default it is DB master). There are two ways to do this : 1. 2. Type inside the query (first line) : USE your-DB-name

Posted in WIN | Tagged , | Comments Off on SQL query by using MS SQL SMS (1)

Initial settings for MS SQL SMS

Go to Tools/Options and set some basic stuff : *Letter size (I like medium) *Line numeration (good idea!) *Auto-correct/finish for commands (so you do not have to type it all) : Good youtube link. Adding comments : *If it is … Continue reading

Posted in WIN | Tagged , | Comments Off on Initial settings for MS SQL SMS

SQL 2008 installation errors

Unable to start T-SQL Debugging. Could not connect to computer (“*”). Since my VM is not in a AD, this is solved by starting SQL SMSS as administrator πŸ™‚ Database diagram support objects cannot be installed because this database does … Continue reading

Posted in WIN | Tagged , , | Comments Off on SQL 2008 installation errors

SQL for beginners, SQL 2008 installation on WIN 2012 R2

So my new job πŸ™‚ I should learn SQL. And since I am a total tabula rasa (for SQL), this is for total beginners πŸ˜‰ SQL is a language for accessing databases. It can add tables/rows/columns, data, and do queries. … Continue reading

Posted in WIN | Tagged , , | Comments Off on SQL for beginners, SQL 2008 installation on WIN 2012 R2

Crochet 81 : reddish doily

It turned out soooo cute! I only need to see what am I going to do with it πŸ™‚ And pattern I used :

Posted in Relaxation | Tagged , | Comments Off on Crochet 81 : reddish doily

Crochet 80 : purple triangular schawl

It turned out great πŸ™‚ The edge is done in purely purple. And here it is : And pattern I used :

Posted in Relaxation | Tagged , , , | Comments Off on Crochet 80 : purple triangular schawl

Skype for Business – gets on my nerves!

It is my PC : WIN 7 with Office 2016. Well, it installed itself, and did not ask for permission πŸ™ And will not let me uninstall it! It is not under “Programs and Features”. Since I do not have … Continue reading

Posted in WIN | Tagged | Comments Off on Skype for Business – gets on my nerves!