Monday, January 31, 2011

Rollback Transaction in SQL Server

Including one command, SAVE TRANSACTION, that could be useful for multiple iterations of a task with error handling.

Rollback Transaction in SQL Server

Business Intelligence: SSAS 2005: Cube Performance Tuning Lessons

Some good pointers for tuning SSAS 2005 cubes here.

Business Intelligence: SSAS 2005: Cube Performance Tuning Lessons

Friday, January 28, 2011

SQL Server - New Drives Use 4K Sector Size - CSS SQL Server Engineers - Site Home - MSDN Blogs

Bob Dorr talks about drive sectors, new standards, and implications on SQL Server.  Somehow this seems to me to be a conspiracy to sell SQL bundled with appliance hardware that is already configured for SQL. I can see why there is a move to a SQL operating system and dedicated appliances rather than dealing with all the intricacies of the o/s and 3rd-party hardware, firmware updates, drive arrays and configuration, memory settings, disk alignment, partitioning, raid configurations, etc.

The implications of incorrect drive sector settings?  Risk of losing data, slow performance and not being able to restore databases to upgraded hardware.

In a lengthy discussion this past week I was reminded that Jan 2011 is when the hard drive manufactures agreed to focus on drives with sector sizes of 4K.    I have read all the latest materials about this over the past week and you can too.  Just search for 512e or Advanced Format Sector sizes and you will find the same articles I read.  I concentrated on articles by Seagate, Western Digital and other manufactures.

Why am I talking about this on a SQL Server blog? - The change has impact to your SQL Servers.   There are two areas you need to be aware of.  PERFORMANCE and DATA INTEGRITY

SQL Server - New Drives Use 4K Sector Size - CSS SQL Server Engineers - Site Home - MSDN Blogs

TwInbox - Use Twitter directly from Outlook.

Twinbox + Access Linked Table to Outlook Folder = Quick and dirty Twitter mining.

If you want to archive your twitter posts, search posts offline, or just hack around with the data, Access allows you to link to Outlook folders, including your Twinbox folders.

If you are using Twitter and Outlook and haven’t tried Twinbox, you’re missing out.

http://msdn.microsoft.com/en-us/library/aa164914(v=office.10).aspx 

TwInbox - Use Twitter directly from Outlook.

Thursday, January 20, 2011

Programming Solution

Taking the U out of CRUD for performance reasons.

So, to conclude, we can say that if we have to do many updates in a very large table (table with several million rows), we can avoid update statement and use select and insert.

Programming Solution

Monday, January 10, 2011

Exists + Descendants function

Returns the set of members based on the member attribute in MDX.

EXISTS(DESCENDANTS([Account].[COA],,leaves),  [Account].[AccountType].[Revenue])

IBM Information Management Software for z/OS Solutions Information Center

Thursday, January 06, 2011

VBA Functions in MDX | Programming Solution

Left, Right and Contains in MDX.

There are some VBA functions that are implemented in MDX code base and so they are faster than using VBA functions. We can call them “internal VBA” as by Irina Gorbach. Here we will see some example of such “internal VBA” in MDX.

VBA Functions in MDX | Programming Solution

How to Use Excel's CUBESET Function | eHow.com

For Cube function reporting in Excel, one function that doesn’t get translated during a pivot table formula convert is CUBESET.

Here is a way to get the leaves (lowest levels) of a dimension using the cube set formula in Excel 2007/2010.

=CUBESET(connectionstring,filter([Account].[AcctHier].members,isleaf([Account].[AcctHier].currentmember))","Account Leaves")

To retrieve the members, create a list of numbers ending at the CUBESETCOUNT() of above, and use the following formula:

=CUBERANKEDMEMBER(connectionstring,

CUBESET(connectionstring,filter([Account].[AcctHier].members,isleaf([Account].[AcctHier].currentmember))","Account Leaves")

,1))

Retrieves the first member of the set.

How to Use Excel's CUBESET Function | eHow.com

Wednesday, January 05, 2011

Download details: Infrastructure Planning and Design

 

The Infrastructure Planning and Design (IPD) guides are the next version of Windows Server System Reference Architecture. The guides in this series help clarify and streamline design processes for Microsoft infrastructure technologies, with each guide addressing a unique infrastructure technology or scenario.

Download details: Infrastructure Planning and Design