Author Archive

SSRS Reports Issue after Migration: Invalid object name ‘ReportServerTempDB.dbo.TempCatalog’   4 comments

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 »

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 »

Learn n Win : Presenting on “SQL Server Dump Analysis” at PASS DBA Virtual Chapter   6 comments

pass_vc_dba_logoI am excited to be speaking at PASS DBA Virtual Chapter on Wednesday Jan 14th. Here is the topic, abstract and schedule of the session:

 SQL SERVER DUMP ANALYSIS (SPONSORED BY DELL SOFTWARE)

While dealing with SQL Server administration, you might have come across scenarios when a  session terminates abruptly, SQL Server instance crashes, SQL Server cluster fails over without a  graceful message. Most often, it leaves a dump file behind which is unfortunately not in a human readable format. In this one hour session, you will learn the basics of a dump file, the tools available for reading thru a dump, the different types of dumps and demos on various debugger commands, how to analyze a dump file to establish the root cause.

DateJanuary 14th 12:00 noon Mountain time (click here to see it in your local time)

If you are a SQL Server DBA willing to dig into dump files which you can’t read just like you read the ERRORLOG, come and join us on this Wednesday Jan 14th to find the exciting stuff. This is a FREE session, you just need to be a member of PASS in order to register. You also stand a chance to win a $100 gift card from Amazon once you register for the session. The winner will be declared through a draw.

Registration: You must register if you want to attend. You can register here

We already have a number of registrants. Hurry up and do share and tweet about this.

See you on Wednesday!
Happy learning!!

Why is affinity mask negative in sp_configure   Leave a comment

While looking at a SQL server health report, I found affinity mask parameter in sp_configure output showing a negative value.

 

name                                minimum     maximum     config_value run_value
----------------------------------- ----------- ----------- ------------ -----------
affinity mask                       -2147483648 2147483647  -1066394617  -1066394617

 

This output was from a SQL Server 2008 R2 instance running on Windows Server 2008 R2.

 

Affinity mask is a SQL Server configuration option which is used to assign processors to specific threads for improved performance. To know more about affinity mask, read this. Usually, the value for affinity mask is a positive integer (decimal format) in sp_configure. The article in previous link shows an example of binary bit mask and corresponding decimal value to be set in sp_configure. Read the rest of this entry »

We didn’t know that   Leave a comment

When we setup this blog, we didn’t know that this very first post will be so popular that it will alone have one-third of the total views on the site, that it will rank# 1 in the major search engines (as of today), see here and here. And we didn’t know that it has been **two wonderful years**, it just feels like yesterday that we setup this blog. Time flies! J

Yes, we are celebrating two years of http://sqlactions.com today, April 15th 2014. On behalf of the authors of sqlactions Manish, Karthic and Prashant, we would like to thank all our blog readers for the continued support. The increased no. of site views and followers, the technical discussion thru blog comments and some readers contacting us for their urgent productions issues… all have been phenomenal in the past two years.

As we go on this journey of SQL Server, we promise to publish the same quality blogs, covering more topics, latest versions and more of video blogs. If there is any special topic you would like us to blog about, please feel free to contact us.

To cherish the moment, here are top 10 blogs on sqlactions.com which were most viewed and most popular so far.

  1. Collection and Reporting of Perfmon data for SQL Server “Capacity Planning” and “Trend Analysis”
  2. Automated Reports for SQL Server Perfmon data
  3. How to create custom schedule for SQL Server Agent Job
  4. A read operation on a large object failed while sending data to the client
  5. SQL Agent Job reports error “SQLServerAgent is not currently running ” Though Agent Service is running
  6. Part-1 How to build SQL Server Failover Cluster Lab on Windows 8 – Also see part-2 and part-3
  7. DBCC MEMORYSTATUS : How is Stolen Potential calculated
  8. Latch Timeout: To worry or not to?
  9. Simple backup Strategy for Distribution database
  10. [Part-1]Let’s drill why you “Cannot generate SSPI context” – Also see part-2

Happy reading!!

 

Posted April 15, 2014 by Prashant Kumar in Celebration

Tagged with , , , ,

Strange errors with SQL Server 2008 setup   Leave a comment

This is a quick post to let you know about two strange errors I recently encountered during SQL Server 2008 setup and the steps on how to resolve them.

 

1.    Installation of SQL Server client tools (SSMS) fails with this error message:

 

 

SSMS error

Read the rest of this entry »