Disk and mount points space and properties

Here is a piece of code which gives a good idea about the drives on your system, and also about the mountpoints.

gwmi -computername¬†Enter_Server_Name win32_volume|where-object {$_.filesystem -match “ntfs”}|ft name,Availability,BlockSize,Compressed,DirtyBitSet,IndexingEnabled,Label,LastErrorCode,PowerManagementCapabilities,Status,@{Name=’CapacityMB’;Expression={$_.Capacity/1MB} },@{Name=’FreeSpaceMB’;Expression={$_.FreeSpace/1MB} }

Availability – describes the availability and the status of the device. (For example, Offline)
BlockSize – Size in bytes of the blocks in this storage extent.
DirtyBitSet –

Continue reading […] Disk and mount points space and properties […]

 

Find the second work day of the month

Just some fun with T-SQL.
Recently someone asked me to write a code which answers the question if today is the second business day of the month or not.
Here is a version of the code. If you have better ideas for doing this, feel free to post a comment.

 

?View Code TSQLdeclare @SecondDayOfMonth datetime
declare @Year int
declare

Continue reading […] Find the second work day of the month […]

 

SQL SERVER TRANSACTION ISOLATION LEVELS

SQL SERVER TRANSACTION ISOLATION LEVELS

by Mukiibi Ivan

On a busy day, our streets are given order by the traffic police, they keep the traffic flowing and they also keep motorists safe. Maximum safety can be ensured by only allowing one person to use a junction at a time.
Unfortunately, if there is heavy traffic the safer and

Continue reading […] SQL SERVER TRANSACTION ISOLATION LEVELS […]