Welcome to MSDN Blogs Sign in | Join | Help

May 2009 - Posts

Processor at 100% after Installing SCCM (or anything else).

Posted Sunday, May 31, 2009 12:34 PM by boduff
I've recently been installing a lot of MS Server products into a lab. One thing I noticed is immediately after the install the server is nearly useless, especially if its a Virtual Server with only one core. The reason for me was after the install the Read More...
0 Comments

SSRS 2008 Event in Cork

Posted Saturday, May 30, 2009 8:57 AM by boduff
If anyone is in Cork on Thursday 4th June, I'll be presenting a seminar on Reporting services 2008 Architecture and Report Builder 2.0 for the MTUG. Well be covering: - Key Engine Changes in 2008 - Rendering Improvements - A Walk through of how to sue Read More...
1 Comments

Troubleshooting AD Extension. The dreaded Error 8206

Posted Thursday, May 21, 2009 6:21 PM by boduff
I’m a SQL/Apps dude, not an Infrastructure guy. My weakness is I love technology so much I dabble in things that I should definitely leave to more expert specialists: windows, active directory, Group Policy, Exchange, ISA Server, networking, patch management, Read More...
1 Comments

DB Restore causes cache flush in SQL 2005

Posted Tuesday, May 19, 2009 9:50 AM by boduff
Ok, I’m sure many people already know this , but I just found out the hard way. When you perform a restore or certain reconfigure options, the entire plan cache is flushed – not only just the database. This might wreck havoc with shared environments or Read More...
1 Comments

Using a SAN to Initialize Replication

Posted Saturday, May 16, 2009 10:50 AM by boduff
I've chatted to a few customers about the possibnility of using a SAN based snapshot to initialise transactional replication. This can be fantastic when you are using a replica to provide "near real time" reporting. Up until now, documentation has been Read More...
1 Comments
Filed under: ,

Disk Partition Alignment De-Mystified

Posted Thursday, May 14, 2009 6:29 PM by boduff
Jimmy May has compiled a great white paper on Disk Partition Alignment Best Practices for SQL Server along with Denny Lee http://msdn.microsoft.com/en-us/library/dd758814.aspx This is a must read for anyone configuring a disk subsystem for SQL Server. Read More...
1 Comments

Dimensional Modelling and Cube Building 101

Posted Thursday, May 07, 2009 9:15 AM by boduff
Thanks to everyone who came to the Dublin SQL users Group session on Tuesday. I hope that we addressed some aspects of “cube fear” that is common in even very experienced relational professionals. For me just being comfortable building that first cube Read More...
1 Comments
Filed under: , ,

Attachment(s): SSAS 101.zip
 
Page view tracker