Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: November 2012

PowerPivot for Excel "Not loaded. The Managed Add-in Loader failed to initialize."

Error when trying to enable the PowerPivot for Excel add-in for Office 2010 reads:
"Not loaded.  The Managed Add-in Loader failed to initialize."



If the installation of the PowerPivot for Excel add-in succeeded, the add-in should be enabled in the Excel Add-ins options panel.  If not, you might see the…

Read more

0 comments, 2,440 reads

Posted in SQL Tact on 30 November 2012

Speaking at SQLPASS Performance Virtual Chapter Winter 2012 Performance Palooza

I am pleased to announce that I am speaking Thursday, December 6, at the SQLPASS Performance Virtual Chapter Winter 2012 Performance Palooza!

I have the 6pm session slot, and am speaking on one of my favorite topics, Virtualizing Business-Critical SQL Servers. I will be focusing on architecting the infrastructure for… Read more

0 comments, 510 reads

Posted in Technobabble by Klee from @kleegeek on 30 November 2012

Reblog: November 23 to November 29

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… Read more

0 comments, 599 reads

Posted in StrateSQL on 30 November 2012

Power View for Multidimensional Models – Preview Available

Microsoft introduced an interactive data exploration, visualization and presentation experience called Power View with SQL Server 2012.  Power View can only consume data from tabular models.  At the PASS Summit (see PASS 2012 Announcements) it was revealed that you would soon be able to use Power View on a… Read more

3 comments, 1,189 reads

Posted in James Serra's Blog on 30 November 2012

Sharing the Love

Just a few blog posts that you ought to go and read.

First up, Tom LaRock maintains a listing of SQL bloggers split up into various cleverly named groups to show you where to go to get good information. This really is an excellent collection of bloggers. It’s the people… Read more

2 comments, 752 reads

Posted in The Scary DBA on 30 November 2012

Rules of Holes #7: Some Will Look Down on You.

I've been extoling the Rules of Holes, hoping to give you both courage to get out of your Hole, and solace for having allowed yourself to get in a Hole in the first place. How about the others, the folks that see that you are up to your neck, the…

Read more

0 comments, 541 reads

Posted in SQLSequel on 30 November 2012

Tables without a Primary Key

As well as creating the script for yesterday’s post on finding Tables without a Clustered Index I tweaked the script slightly to get all tables without a primary key.  A Primary Key constraint enforces uniqueness of a record in a table.  I am extremely anal with this particular standard…

Read more

6 comments, 3,475 reads

Posted in SQL Server 365 on 30 November 2012

SQL Saturday in Washington D.C. December 8, 2012

This is my first time attending a SQL Saturday event and I’m quite excited. If you live in or near the D.C. Metro area I hope to see you there. If you have not registered, you still have a chance: http://sqlsaturday.com/173/eventhome.aspx I’ve put together a short list of the sessions…

Read more

2 comments, 477 reads

Posted in TheSqlPro.com - Ayman El-Ghazali on 30 November 2012

New Book: Knight’s SSIS 2012 24-Hour Trainer

I’m very excited to announce that you can now purchase my latest release book:Knight’s Microsoft SQL Server 2012 Integration Services 24-Hour Trainer. The 24-Hour series of books offered by Wrox is a great way to get kick started into learning a new tool. Not only are the lessons… Read more

0 comments, 1,772 reads

Posted in Devin Knight on 30 November 2012

Backup History

This is a quick rewrite of the script I just posted a few days ago.  The script had a few flaws if trying to run it on a SQL 2005 box.  I have updated it to run against SQL 2005 and up.

This version is done using Dynamic SQL to… Read more

5 comments, 1,417 reads

Posted in SQL RNNR on 30 November 2012

SQL Server Thumbnail Metrics – OS Memory

I’m gathering a few metrics around the Internet for SQL Server from people that I think really know how to run a SQL Server. This is a series of posts that I’m making to gather these metrics up for easy access later.

Host Memory

The short metric is:

Leave 4GB… Read more

1 comments, 1,807 reads

Posted in The Voice of the DBA on 29 November 2012

Reasons not to upgrade to SQL Server 2012

As exciting as SQL Server 2012 is, with its multitude of new features, it’s not always possible to upgrade right away.  Here are some reasons that may cause you to delay your upgrade:

Training – Your developers and dba’s will need to learn the new features of SQL Server… Read more

5 comments, 1,551 reads

Posted in James Serra's Blog on 29 November 2012

Interview questions for SQL Server Performance Tuning Specialists

If you are the regular reader of my blog posts, you could easily judge in which topics i spend much time these days.

I have converted some of my learning as questions and posted it here. These are not necessarily be the interview questions.

I am sure that this will help us to assess our knowledge and hope this… Read more

3 comments, 5,869 reads

Posted in LivingForSqlServer on 29 November 2012

HDInsight: Trying again

And I thought this would be so easy.

Latest attempt. I just did an uninstall of HDInsight. Then I found all the Hadoop folders on the drive and removed them. I validated that there were no services left running or anything else that might interfere with a fresh install. Then,… Read more

4 comments, 933 reads

Posted in The Scary DBA on 29 November 2012

Tables without a Clustered Index


Yesterday while adding some new logic to an existing process I noticed an unacceptable level of performance degradation with the routine.  Investigation led me to find that a new table had slipped through the net and been created without a clustered index.  Needless to say adding a clustered…

Read more

1 comments, 630 reads

Posted in SQL Server 365 on 29 November 2012

Chicago: The Travels of a SQL Server Consultant

As regular readers of my blog will now as part of role as a SQL Server consultant and SQL Server trainer I get to travel a fair bit. Well last week I was off on my travels again on a multi-stop tour of the mid-west USA. Taking in Chicago, Milwaukee,… Read more

0 comments, 966 reads

Posted in The SQL DBA in the UK on 29 November 2012

Plan cache bloat by SQLAgent (Prior to SQL2008) !

Recently I was checking the plan cache utilization with the help of the below query which I normally use for this purpose. This is written by Glenn Berry(B/T) and is available along with his SQL Server 2005 Diagnostic Information Queries.All credit goes to him.

SELECT TOP(50)…

Read more

0 comments, 1,316 reads

Posted in SQLSailor.com on 29 November 2012

Older posts