OLAP vs ROLAP vs MOLAP vs HOLAP vs DOLAP vs WOLAP

  • OLAP – OnLine Analytical Processing
  • ROLAP – Relational OnLine Analytical Processing
  • MOLAP – Multidimensional OnLine Analytical Processing
  • HOLAP – Hybrid OnLine Analytical Processing
  • DOLAP – Desktop/Database OnLine Analytical Processing
  • WOLAP – Web Enabled OnLine Analytical Processing

Read more here – https://social.technet.microsoft.com/wiki/contents/articles/19898.differences-between-olap-rolap-molap-and-holap.aspx

Get Last Modified Date without downloading the file in PowerShell

Compatibility: v5.x
[code]
$zipfile = “https://www…./xyz/test.zip”

add-type @”
using System.Net;
using System.Security.Cryptography.X509Certificates;
public class TrustAllCertsPolicy : ICertificatePolicy {
public bool CheckValidationResult(
ServicePoint srvPoint, X509Certificate certificate,
WebRequest request, int certificateProblem) {
return true;
}
}
“@

$AllProtocols = [System.Net.SecurityProtocolType]’Ssl3,Tls,Tls11,Tls12′
[System.Net.ServicePointManager]::SecurityProtocol = $AllProtocols
[System.Net.ServicePointManager]::CertificatePolicy = New-Object TrustAllCertsPolicy

#$res = Invoke-WebRequest -Uri $zipfile

$webRequest = [System.Net.HttpWebRequest]::Create($zipfile)
$webRequest.Method = “GET”
[System.Net.HttpWebResponse]$webResponse = $webRequest.GetResponse()

Write-Output $webResponse.LastModified
[/code]

Getting SQL Server result set in PowerShell

Compatibility: v5.x
If you are a .NET developer then you are already familiar with this code Smile

[code]
$connectionString = “Data Source=localhost;Integrated Security=SSPI;Initial Catalog=AdventureWorks2016CTP3”
$dt = New-Object System.Data.DataTable
$da = New-Object System.Data.SqlClient.SqlDataAdapter(“SELECT TOP 10 * FROM Person.Address”, $connectionString)
$da.Fill($dt)

Write-Output $dt.Rows[0][“AddressLine1”]

# or

ForEach ($dr in $dt.Rows) {
Write-Output $dr[“AddressLine1”]
}
[/code]