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, 1,530 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, 2,361 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…
1 comments, 2,002 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, 1,426 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, 1,343 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, 1,837 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, 2,485 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, 1,238 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, 1,478 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, 1,656 reads
Posted in SQL RNNR on 31 October 2011
Tales from the Query Processor
http://www.flickr.com/photos/socal_jim/2070088596/ |
2 comments, 1,230 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, 10,095 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, 2,282 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, 1,403 reads
Posted in SQL Server Rocks! on 29 October 2011
DATABASE_OBJECT_CHANGE_GROUP do not audit SP or other object
0 comments, 1,506 reads
Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 29 October 2011
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, 1,752 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
2 comments, 3,622 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, 2,160 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
3 comments, 1,467 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, 2,296 reads
Posted in James Serra's Blog on 28 October 2011