Netezza Administration : Getting each Database size

Run query ! Just like MAGIC !

-

SELECT current_timestamp AS SAMPLE_TIME

       ,t. database AS DATABASE_NAME

       , round(nvl (SUM (d.used_bytes)/1024 /1024,0),2)      AS USED_MB

       , round(nvl (SUM (d.allocated_bytes)/1024 /1024,0),2) AS ALLOCATED_MB

      FROM _V_SYS_OBJECT_DSLICE_INFO d

INNER JOIN _V_OBJ_RELATION_XDB t

        ON t.objid = d.tblid

WHERE t.objid > 200000

  AND d.tblid > 200000

GROUP BY rollup (DATABASE_NAME)

ORDER BY DATABASE_NAME nulls last;

-

It will only shows database that is in use and ignore the one that is NULL basically.

Windows Administration : Server 2012 .Net Framework 3.5

You will not find any installation of .NET Framework 3.5 in a fresh install copy of your new server running on 2012. What can you do if you really needs it, perhaps some legacy application still needs it ? Let's see .

To install .NET Framework 3.5 to your machine :

1. Make sure you have a copy of Microsoft Windows Server 2012 ISO available or a physical disk.

We will need the file from the directory "sources\sxs"

Please drop me a PM if you need the sources file.

2. Physical access to your machine (if you are using disk) or remote access will do.

3. Powershell installed in the machine. (Yes! I like Powerful sea-shell :D )

4. Mount the ISO or put in the disk into the server.

In 2012, mounting a ISO is as simple as double clicking it, you will find it mapped to a drive letter.

5. Run this command into Powershell

Install-WindowsFeature -Name Net-Framework-Core -source [MappedDrive]:\source\sxs

6. Voila. Like magic your .NET Framework 3.5 is installed !