Ozzie.eu

Reference Architecture for Private Cloud

A lot of companies still make the finantial compromise on private cloud, rather than public or hybrid ones, either because of regulatory affair or simply because there is a lack of trust on external suppliers.

Microsoft has released a whole set of documents about designing, implementing and securing a private cloud:

Overview of Private Cloud Architecture

Private Cloud Technical Overview

What is Infrastructure as a Service?

Private Cloud Reference Model

Private Cloud Principles, Patterns and Concepts

Private Cloud Planning Guide for Infrastructure as a Service (IaaS)

Private Cloud Planning Guide for Service Delivery

Private Cloud Planning Guide for Operations

Private Cloud Planning Guide for Systems Management

Cloud Computing Security Architecture

A Solution for Private Cloud Security

I was also made aware, by Microsoft’s security newsletter, of the "A Solution for Private Cloud Security" series of three papers on private cloud security. 

Finally, heading over to the Cloud and Datacenter Solutions Hub, there’s lots and lots of material to read.

Geeky pics for SQL Server fans

Reset Forgotten MySQL Root Password

Following my recent post about getting locked out of MSSQL, I might as well post one about MySQL:

http://www.itsprite.com/linuxreset-forgotten-mysql-root-password/

Locked out of MS SQL Server - solution

Reading this post from SQLServer Central, I remembered reading the documentation:

Connect to SQL Server When System Administrators Are Locked Out

It’s still valid for MSSQL2014.

oldoldlisbon:

| Fotografia da construção da estátua de Marquês de Pombal localizada em Praça do Marquês de Pombal - Lisboa (portugal)(1934)

| Photograph of the construction of the statue of the Marquis of Pombal

Reminds me of Gulliver and the Lilliputian people :)

New Version: SQL Server Maintenance Solution

Ola Hallengren released a new version of SQL Server Maintenance Solution:

The new version has support for backup to Azure Blob Storage.

Here is how it works:

EXECUTE dbo.DatabaseBackup @Databases = ‘USER_DATABASES’,

@URL = ‘https://myaccount.blob.core.windows.net/mycontainer’,

@Credential = ‘MyCredential’,

@BackupType = ‘FULL’,

@Compress = ‘Y’

and with encryption:

EXECUTE dbo.DatabaseBackup @Databases = ‘USER_DATABASES’,

@URL = ‘https://myaccount.blob.core.windows.net/mycontainer’,

@Credential = ‘MyCredential’,

@BackupType = ‘FULL’,

@Compress = ‘Y’,

@Encrypt = ‘Y’,

@EncryptionAlgorithm = ‘AES_256’,

@ServerCertificate = ‘MyCertificate’,

@Verify = ‘Y’

Backup to Azure Blob Storage is available in SQL Server 2012 (SP1 CU2 and later) and SQL Server 2014.

The new version also has some minor bug fixes and improvements.

The SQL Server Maintenance Solution comprises scripts for running backups, integrity checks, and index and statistics maintenance on all editions of Microsoft SQL Server.

Are these the only options in life?