Query Store: Exploring new features in SQL Server – vNext   Leave a comment


Troubleshooting performance problem is one of the challenging and most often faced situation in DBA’s life. Following diagram shows three major scenarios where DBA’s get involved and spend nights troubleshooting performance problems.

Note: This is with community technical preview 2 of SQL Server 2016, things may change with the RTM release

18

Read the rest of this entry »

SSRS Reports Issue after Migration: Invalid object name ‘ReportServerTempDB.dbo.TempCatalog’   Leave a comment


I recently migrated one of our SQL Server Database Engine and SSRS instances from SQL Server 2008 to SQL Server 2014. Post migration, when I tried to browse the SSRS reports, I get this error:

Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: 
An error occurred within the report server database.  
This may be due to a connection failure, timeout or low disk condition within the database
. ---> System.Data.SqlClient.SqlException: 
Invalid object name 'ReportServerTempDB.dbo.TempCatalog'.
Could not use view or function 'ExtendedCatalog' because of binding errors.

Read the rest of this entry »

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 »

Follow

Get every new post delivered to your Inbox.

Join 1,191 other followers