Powershell script to manipulate SQL Server backup files   Leave a comment


Scenario

I use Ola Hallengren’s famous backup solution to back up my SQL Server databases. The destination for full backups is a directory on local disk; let’s say D:\SQLBackup\

If you are familiar with Ola’s backup scripts, you know the full path for backup file looks something like:

D:\SQLBackup\InstanceName\DatabaseName\FULL\InstanceName_DatabaseName_FULL_yyyymmdd_hhmiss.bak

where InstanceName is a placeholder for the name of the SQL server instance, similarly, DatabaseName is for the Database Name. Read the rest of this entry »

[Part-5]Private Cloud: Some common issues and troubleshooting tips   Leave a comment


This is the fifth and final post in the series of blog posts on how to build own Private Cloud using Windows Azure Pack (WAP).

 Here is a list of topics for the entire series:

 

1. PrivateCloud_Icon[Part-1]Private Cloud: Introduction and installation of pre-requisites

[Part-2]Private Cloud: Configure SCVMM and SPF

[Part-3]Private Cloud: Install and Configure WAP

[Part-4]Private Cloud: Demo of provisioning VM and SQL DB using Tenant portal.

[Part-5]Private Cloud: Some common issues and troubleshooting tips.

 

In this blog I will provide some troubleshooting tips e.g. where to look in case of any error and few scenarios.

When it comes to troubleshooting, usually, the following questions comes into mind:

  1. Log files: Where and what to look at?
  2. Troubleshooting example
  3. Common issues/errors

I am going to cover the above mentioned topics in this blog post. Read the rest of this entry »

[Part-4]Private Cloud: Demo of provisioning VM and SQL DB using Tenant portal   1 comment


This is fourth post in the series of blog posts on how to build own Private Cloud using Windows Azure Pack (WAP). 

Here is a list of topics for the entire series:

 

[Part-1]Private Cloud: Introduction and installation of pre-requisites

[Part-2]Private Cloud: Configure SCVMM and SPF

[Part-3]Private Cloud: Install and Configure WAP

[Part-4]Private Cloud: Demo of provisioning VM and SQL DB using Tenant portal.

[Part-5]Private Cloud: Some common issues and troubleshooting tips.

 

In this blog post, we will create a plan, assign this plan to the user and then provision a Virtual Machine and a Database.

Before we proceed, let me explain what is a plan and why do we need to assign a user to it. Read the rest of this entry »

[Part-3]Private Cloud: Install and Configure WAP   2 comments


This is third post in the series of blog posts on how to build own Private Cloud using Windows Azure Pack (WAP).

 

Here is a list of topics for the entire series:

 

[Part-1]Private Cloud: Introduction and installation of pre-requisites

[Part-2]Private Cloud: Configure SCVMM and SPF

[Part-3]Private Cloud: Install and Configure WAP

[Part-4]Private Cloud: Demo of provisioning VM and SQL DB using Tenant portal.

[Part-5]Private Cloud: Some common issues and troubleshooting tips.

 

In this blog post, we will install and configure WAP followed by configuration of SPF, SCVMM and SQL Server on WAP. I have divided it in two sections:

Section-1: Install and Configure Windows Azure Pack

  • Installing Windows Azure Pack: Online installation
  • Installing Windows Azure Pack: Offline installation
  • Configure Windows Azure Pack

Section-2: Configure SPF, SCVMM and SQL Server on Window Azure Pack

  • Configure SPF and SCVMM on Windows Azure Pack
  • Configure SQL Server on Windows Azure Pack

Read the rest of this entry »

[Part-2]Private Cloud: Configure SCVMM and SPF   3 comments


This is second post in the series of blog posts on how to build own Private Cloud using Windows Azure Pack (WAP).

 

Here is a list of topics for the entire series:

 

[Part-1]Private Cloud: Introduction and installation of pre-requisites

[Part-2]Private Cloud: Configure SCVMM and SPF

[Part-3]Private Cloud: Install and Configure WAP

[Part-4]Private Cloud: Demo of provisioning VM and SQL DB using Tenant portal.

[Part-5]Private Cloud: Some common issues and troubleshooting tips.

 

In the first part of the series, we installed SCVMM and SPF. Now, we will configure SCVMM to make it cloud aware followed by configuration of SPF. Here is a quick overview of what we are going to do in this post:

 

1.   Configure System Center virtual machine manager (SCVMM)

1.1. Create and add a sysprep VHD file to VMM library

1.2. Add a physical host to VMM

1.3. Create a hardware profile for your VM’s.

1.4. Create a VM template and attach hardware profile and sysprep VHD to template

1.5. Create a logical network

1.6. Create a cloud and attach all the above details to cloud.

 

2.   Configure Service Provider Foundation (SPF)

Read the rest of this entry »

[Part-1]Private Cloud: Introduction and installation of pre-requisites   4 comments


Today, I am going to kick off an interesting series of blog posts on how to build own Private Cloud using Windows Azure Pack (WAP).

 

The series will be divided into the following five posts:

 

[Part-1]Private Cloud: Introduction and installation of pre-requisites

[Part-2]Private Cloud: Configure SCVMM and SPF

[Part-3]Private Cloud: Install and Configure WAP

[Part-4]Private Cloud: Demo of provisioning VM and SQL DB using Tenant portal.

[Part-5]Private Cloud: Some common issues and troubleshooting tips.

 

Let’s have a quick introduction to Windows Azure Pack (WAP) before you proceed further.

Read the rest of this entry »

Jan 14th 2015: PASS DBA VC Presentation on SQL Server Dump Analysis   2 comments


Further to my blog post I would like to thank you all for attending my recent presentation on SQL Server Dump Analysis for PASS DBA Virtual Chapter on  Jan 14th 2015.

The presentation was well received with a good number of attendees joining the session. Post presentation, I was asked to present extended multiple deep-dive sessions which I will be planning  for.

For those, who either could not attend or want to see it again, I have embedded the presentation materials in this post.

Here are the slides of the presentation:

Read the rest of this entry »

Follow

Get every new post delivered to your Inbox.

Join 1,183 other followers