Including one command, SAVE TRANSACTION, that could be useful for multiple iterations of a task with error handling.
Monday, January 31, 2011
Some good pointers for tuning SSAS 2005 cubes here.
Friday, January 28, 2011
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
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.
Wednesday, January 26, 2011
The hidden gems among DMVs: sys.dm_os_sys_memory - Microsoft SQL Server Tips & Tricks - Site Home - MSDN Blogs
Some of the hidden gems are also here:
Thursday, January 20, 2011
Tuesday, January 18, 2011
Monday, January 10, 2011
Returns the set of members based on the member attribute in MDX.
Thursday, January 06, 2011
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.
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.
To retrieve the members, create a list of numbers ending at the CUBESETCOUNT() of above, and use the following formula:
Retrieves the first member of the set.
Wednesday, January 05, 2011
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.