Replace Laptop’s Hard Driver with Intel SSD Driver By Using Intel’s Data Migration Software

Posted: January 30, 2013 | Author: | Filed under: My IT tools | Leave a comment

It is very easy to upgrade a laptop’s hard driver with Intel SSD with Intel® Data Migration Software.

I used one 160 GB Intel SSD drive to replace a 500 GB HD with 120 GB data on it from ASUS X53E Windows 7 Home Premium.

The cloning mode is manual to control the destination partition size and the other options you can leave it as default to proceed.
It takes a while to finish cloning the 120GB driver through a USB connection. After the cloning, I simply swap the driver with the SSD
and the machine is ready to run.
Download link for the software and manual:
http://downloadcenter.intel.com/Detail_Desc.aspx?agr=Y&DwnldID=19324

SQL Server Analysis Services Tutorial — From MSDN

Posted: January 29, 2013 | Author: | Filed under: SSAS 2008 | Leave a comment

http://msdn.microsoft.com/en-us/library/ms170208(v=sql.105).aspx

SSAS Errors: Errors in the metadata manager. The dimension with ID of ‘Something Name’ referenced by the ‘CubName’ cube, does not exist.

Posted: January 28, 2013 | Author: | Filed under: SQL Server 2008, SSAS 2008 | Leave a comment

The steps to fix the problem:

1. Stop SSAS service(any way you know);
2. Rename (or delete) the data file folder (example: …OLAP\Data\My Cub Name.0.db\”;
3. Start SSAS service and Connect through SSMS to delete the SSAS database.
4. Redeploy cub database from BIDS and it should work this time.

A useful post to help to solve this problem is from:

SSAS errors: Errors in the metadata manager. The dimension with ID of ‘xxx’ referenced by the ‘yyy’ cube, does not exist.

Get Stored Procedure Definition, Create_Date and Modify_Date (Created_Date and Modified_Date) by T-SQL

Posted: January 9, 2013 | Author: | Filed under: SQL Server 2005, SQL Server 2008, SQL Server 2012 | Leave a comment 
--use yourDB
--GO

SELECT
	o.name,
	o.TYPE,
	o.create_date,
	o.modify_date,
	m.definition
FROM sys.objects o
INNER JOIN sys.sql_modules m
	ON o.object_id = m.object_id
ORDER BY o.modify_date DESC