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

Archives: October 2011

Four faces of an Employee

Whoever starts their career in any domain/technology, initially they will have two faces.

First face of an employee is to take care of his/him family & family related commitments and the second
face of him/her is to fulfill the expectation of the Organization they work.

But third and forth faces… Read more

2 comments, 753 reads

Posted in LivingForSqlServer on 31 October 2011

Document Your Day

You should be documenting your day, your week, your month, on a regular basis. Take a few minutes when you accomplish something and make a blog entry. This is a great way for you to keep track of what you’ve accomplished during the year, and be ready to talk about… Read more

3 comments, 965 reads

Posted in The Voice of the DBA on 31 October 2011

Miss SQLBits 9? No problem, all videos are online

All the videos for this popular conference are online or will be soon (48 of them). Take a look at the recorded sessions at http://sqlbits.com/content/Event9.  All are free to watch!  The one’s on my list to watch (because I’m interested in SQL Server 2012/Data Warehouse/SSAS):

  • Basic BISM
  • Handling Advanced…

Read more

1 comments, 951 reads

Posted in James Serra's Blog on 31 October 2011

Everybody Needs a Test Harness

When you’re developing new Transact-SQL code or modifying some existing code, do you just launch directly into programming?

I know that I did just that, for years.  It wasn’t until I was trying to performance tune some existing code that I realized I hadn’t actually taken caching of data and… Read more

1 comments, 634 reads

Posted in Kevin E. Kline on 31 October 2011

The Showdown

Today we have a guest post from Steve Jones.

I survived SQL in the City in LA, and thanks to everyone that came. Alien Brad looked normal, but it also appears that he’s learned to imitate humans. Or maybe Brad escaped and made his way to LA. I’m not… Read more

0 comments, 574 reads

Posted in SQL Aloha on 31 October 2011

PASS Board Of Elections: Rob Farley

Be Part Of The Solution, Not The Problem

<disclaimer >

Now that BoD season is in full swing and I’m not running for the board I am going to cover the candidates I think would be good for the BoD. Make no mistake about it, these are endorsements. I have… Read more

0 comments, 832 reads

Posted in SQL Man of Mystery on 31 October 2011

Managing SQL Server in a Virtual World (rough) Notes, Thanks to Quest Presenter Jason Hall

Managing SQL Server in a Virtual World Notes (View Complete Slide Show)
Hosted by MVP Kevin Kline, Quest Software
Guest presenter Jason Hall, SQL Server consultant to Quest software

How to optimize your SQL Server licensing with VMware, since most SQL VMs are on VMware ESX platform: http://communities.vmware.com/message/1075017 Read more

0 comments, 1,220 reads

Posted in The Database Hive for SQL Server DBAs on 31 October 2011

PASS Summit 2012

Yes, I know you just got back from the 2011 Summit.  Kinda like I just got back from vacation.  But that doesn’t mean I haven’t already started thinking about my next vacation.  And you should be thinking about next year’s summit.  Why?  Because until November 15, 2011, you can register Read more

0 comments, 536 reads

Posted in Cleveland DBA on 31 October 2011

Two of a Kind

Here’s one that I haven’t run into before. A colleague scheduled a meeting with someone else in the organization to work through a problem that keeps coming up and seems to be of those problems where everyone wants someone else to do the work. The other person declined the meeting… Read more

0 comments, 578 reads

Posted in SQLAndy on 31 October 2011

Haunting a Database Near You

Today, we have a special Halloween edition.  For me, Halloween and computer geek go quite well together.  And thinking about it, I wanted to try to better understand if there was a correlation.  As a DBA, have you wondered the same thing?

Well, I have a short list of five… Read more

0 comments, 707 reads

Posted in SQL RNNR on 31 October 2011

Tales from the Query Processor

http://www.flickr.com/photos/socal_jim/2070088596/
Hello Dear Reader!  I've been a bit behind on the blogging but wanted to give you a bit of a treat.  Today is Halloween in the USA.  This is probably my favorite Holiday.  The family and I always love the fall, and this is one of the few holiday's…

Read more

2 comments, 406 reads

Posted in SQLBalls on 31 October 2011

Logical CPU, Physical CPU and hyper threading

Those who are fan of Glenn Berry’s DMV queries would have come across below query at-least once.

-- Hardware information from SQL Server 2008

-- (Cannot distinguish between HT and multi-core)

SELECT cpu_count AS [Logical CPU Count], hyperthread_ratio AS [Hyperthread Ratio],

cpu_count/hyperthread_ratio AS [Physical CPU Count] Read more

3 comments, 4,976 reads

Posted in LivingForSqlServer on 30 October 2011

Creating a Table Report with Dynamic Columns

Over time, similar reports may be designed from variations of common queries and datasets.  Creating one report to meet all these requirements can minimize development time and maintenance overhead.  By evaluating existing reports and making modifications, future requirements can be met without creating yet another report.  Parameters and expressions may… Read more

2 comments, 1,010 reads

Posted in SQL Server BI Blog on 30 October 2011

Finding orphaned database users

Database users can become orphaned for a few reasons. For example, a database restore to another instance or deleting the corresponding SQL login would have the effect of leaving a database user orphaned. Development/testing SQL servers may also experience this due to the number of ad-hoc updates that may occur… Read more

0 comments, 615 reads

Posted in SQL Server Rocks! on 29 October 2011

DATABASE_OBJECT_CHANGE_GROUP do not audit SP or other object

Deepak Kumar (friend of mine and founder of http://www.sqlknowledge.com )  were chatting yesterday. We were discussing about audit feature in SQL 2008, Deepak has enabled this feature for one of his client since month. And when he was looking at the log he found that there were entries but they…

Read more

Updatable Subscriptions Removed in SQL Server 2012

After spending some time looking at SQL Server 2012 CTP3, it appears as if Transactional Publication with Updatable Subscriptions will officially be removed in SQL Server 2012.  According to Books Online, Microsoft is recommending that users switch to Peer-to-Peer Replication instead.  This is a shame considering Peer-to-Peer is an… Read more

0 comments, 773 reads

Posted in SQLREPL on 29 October 2011

Updatable Subscriptions Deprecated in SQL Server 2012

After spending some time looking at SQL Server 2012 CTP3, it appears as if Transactional Publication with Updatable Subscriptions will officially be deprecated in SQL Server 2012.  According to Books Online, Microsoft is recommending that users switch to Peer-to-Peer Replication instead.  This is a shame considering Peer-to-Peer is an… Read more

1 comments, 1,690 reads

Posted in SQLREPL on 29 October 2011

How to hide Calculated Members in MDX SSAS

With some calculated members in MDX it only makes sense to see the calculation if a certain Hierarchy is used.

For example:

Aggregate(YTD([Date].[Calendar].CurrentMember),[Internet Sales Amount])

This calculation only works in the Date.Calendar Hierarchy. I wanted to show the end users a message informing them about this and hide the calculation… Read more

0 comments, 930 reads

Posted in Mike Davis SQL on 28 October 2011

PASS Summit 2001 In Review…WOW!!!

It has been a couple of weeks and I have had time to get back in the groove at a new job as Senior SQL Server DBA, after trying Informatica Administrator via Enterprise Architect for about 3 months. Long story, but I am glad to be back as a DBA.… Read more

0 comments, 524 reads

Posted in The Smiling DBA on 28 October 2011

SQL Server Analysis Services Performance Guide published

Another must read white-paper: Analysis Services 2008 R2 Performance Guide.

This white paper describes how business intelligence developers can apply query and processing performance-tuning techniques to their Microsoft SQL Server 2008 R2 Analysis Services OLAP solutions.  It applies to SQL Server 2005, SQL Server 2008, and SQL Server 2008… Read more

0 comments, 1,371 reads

Posted in James Serra's Blog on 28 October 2011

Older posts