Category Archives: WIN

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

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

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

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

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

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

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

Installation on WIN server 2012 R2

If you have a WIN 2012 R2 server, which is on a local LAN, and during (any) installation gives the error of not being able to download from https://go.microsoft.com, do the following : 1. Set gateway on server 2. Set … Continue reading

Posted in WIN | Tagged , | Leave a comment

How to view WIN OS version, if there are WMI problems

Since it is a production server, no WMI restart! So I have to get OS version with alternate methods, that is CLI. Note : cmd start as Administrator account Way 1 C:\Users\veldaebel>ver Microsoft Windows [Version 6.0.6002] So, it works, but … Continue reading

Posted in WIN | Tagged , | Leave a comment

How to see existing “Scheduled Tasks”

WIN 2003 First way 1. Connect via Remote Desktop-om to your Win 2003 server 2. Go to folder C:\WINDOWS\Tasks and see what is all there, but use “Advanced/View Log” . Second way From command line, on WIN 2003 server : … Continue reading

Posted in WIN | Tagged , , | Leave a comment