Category Archives: WIN

MCSA 70-412 and new abbrevations

70-411 is done!!!! Now for the next one.Sigh. And OF COURSE new abbrevations : AD CS – AD certificate services AD FS – Active Directory federation services AD RMS – Active Directory Rights Management Service, encryption for MS Office documents, … Continue reading

Posted in WIN | Tagged , , | Leave a comment

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

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!

WIN server defragmentation, how to see the level

It is connected to my previous post. This is for WIN 2012 server. Level of (de)fragmentation can be seen in a number of ways : Way 1 : CLI (link) Note : this is applicable also to WIN 2003 server. … Continue reading

Posted in WIN | Tagged , | Comments Off on WIN server defragmentation, how to see the level