WinSXS cleanup in Microsoft Windows (Server and Desktop)

WinSXS folder is the component store of Windows vista and later operating systems. Windows OS stores all its core components within WinSXS directory. WinSXS folder is the only place where OS components are stored; everything else is just hard links. To prove this, use the fsutil to check the hardlinks of a system file. So, [...]

Πως θα προστατευθείτε από το ransomware

Έχετε ακούσει για κακόβουλο λογισμικό; Αν και τρομακτικό - όχι σαν το ransomware; Εκεί οι εγκληματίες σας κλειδώνουν από τα δεδομένα σας και πρέπει να πληρώσετε για να αποκτήσετε ξανά πρόσβαση σε αυτά. Το νέο μας βίντεο έχει τρεις τρόπους με τους οποίους μπορείτε να προστατεύσετε την επιχείρησή σας από ransomware. [...]

SNR margin, line attenuation, ADSL / VDSL and a slow internet speed

Slow internet speed is often a result of a bad attenuation and SNR margin figure. If you are one of those people who have problems with their internet speed, then you are in the right place. Have you installed an ADSL / VDSL line recently, and you get a slow internet speed? Often the line [...]

Setting up Windows 2012 storage virtualization. A software RAID solution or more?

A new feature in windows 2012 installed by default in all server editions! Microsoft calls it Storage Virtualization and the idea behind it is somewhat familiar to most administrators that have worked on a hardware RAID controller before. In fact disk virtualization is working like a software RAID with better scalability, resiliency and optimization. The [...]

SQL Indexing and SQL Performance Part 4: Design Considerations

In the previous part of the blog post series you’ve seen that the query optimizer examines query predicates in order to analyze statistics for useful indexes in the execution plan decision process. Since indexes are quite important to the query optimization process, the first design tip is to consider WHERE, JOIN, MERGE, ORDER BY and [...]

SQL Indexing and SQL Performance Part 3: Queries, indexes and the query optimizer

Which columns should you choose for indexing? To decide on the columns of an index you have to consider the most frequent queries running against your tables. You have to examine the WHERE and JOIN clauses (ORDER BY and GROUP BY also benefit from indexes), since SQL query optimizer will try to find the best [...]

SQL Indexing and SQL Performance Part 2: Clustered and Non-Clustered

So, why do you need to index your tables? Because without an index the SQL server has to scan the entire table to return the requested data. It is like the index page in a book. You check within the index for the keyword you want to learn about. From that point forward, you jump directly to [...]