How can I see data stored in MDF data pages ?

-- Just an example using a simple word ('pablo')

USE tempdb

CREATE TABLE p1(
nom CHAR(20)
)


INSERT INTO p1(nom) VALUES('pablo')
SELECT * FROM p1

SELECT *
FROM sysindexes
WHERE id = OBJECT_ID('p1')

--It will do conversion for FIRST (0xnn) field to DECIMAL
DBCC TRACEON(3604)

DBCC PAGE (tempdb,1,34,1)

--disabling trace indicators DBCC TRACESTATUS (3604)
DBCC TRACEoff (3604)