VMware ESXi best practices: BIOS settings

2014-06-09T16:31:48+02:00Monday, 30 September, 2013|Categories: Technical|Tags: , , , |

In case you are planning to install VMware ESXi on a host server, you need to be aware of the VMware ESXi  best practices that get the most out of your system. You need to be able to identify the best options regarding the CPU cores and sockets, hyper threading, NUMA mode, Hardware assisted virtualization, [...]

Windows CMD commands in Win12 server core

2016-10-19T13:01:31+02:00Thursday, 25 July, 2013|Categories: Featured, Technical|Tags: , , , , , , , , , , |

Since windows 2008, server core has become a valuable option for deploying more secure and more stable windows servers. Although it is quite easy, many administrators avoid to deploy such solutions because they feel unsure on how to configure and manage such systems using windows CMD commands in the windows command prompt. The main idea [...]

WinSXS cleanup in Windows 2012 and Windows 8

2016-10-19T13:01:32+02:00Wednesday, 9 January, 2013|Categories: Featured, Technical|Tags: , , , , , , , , |

WinSXS folder is the component store of Windows vista and later operating systems. Windows OS stores all its core components to WinSXS directory. The WinSXS folder is the only location that the core system components found on the system and all the system files you see in their usual locations, in the windows directory structure, [...]

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

2016-10-19T13:01:33+02:00Monday, 7 January, 2013|Categories: Featured, Technical|Tags: , , , , , , , , |

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

2016-10-19T13:11:16+02:00Wednesday, 12 January, 2011|Categories: Technical|Tags: , , , , , , , , , |

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

2016-10-19T13:11:17+02:00Monday, 20 December, 2010|Categories: Technical|Tags: , , , , , , , , , |

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

2015-06-09T11:34:07+02:00Tuesday, 30 November, 2010|Categories: Technical|Tags: , , , , , , , , , |

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 [...]

A nice way to start on Linux

2016-10-19T13:11:23+02:00Monday, 29 November, 2010|Categories: Technical|Tags: |

I bought the first edition of this book to introduce myself to the world of Linux. It is well structured and quite understandable for someone who is taking his first steps in the Linux O/S. Covers basic theory like file system structure, booting and shutting down to more advanced like routing, performance analysis, etc If [...]

SQL Indexing and SQL Performance Part 1: SQL Storage and Indexing

2016-10-19T13:11:24+02:00Monday, 29 November, 2010|Categories: Featured, Technical|Tags: , , , , , , , |

Before we begin our journey in SQL Indexing it is important to understand how a SQL Server stores its data. Database FileGroups and Files A MS SQL database uses a .mdf file as the primary data file, a number of .ldf files as transaction logs, and optionally a number of .ndf files as secondary data files. These [...]