Monthly Archives: July 2018

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 , , , , | Leave a comment

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 , , | Leave a comment

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!