list of all the tables in SSAS

To get a list of all the tables in SSAS, execute this in an MDX window:
SELECT * FROM $system.dbschema_tables
where Table_type = 'schema'

List compressed SQL tables

select 
 '[' + s.name + '].[' + o.name + ']' as TblName
 ,p.data_compression_desc
from 
 sys.partitions p
 join sys.objects o
  on p.object_id = o.object_id
 join sys.schemas s
  on o.schema_id = s.schema_id
where
 p.data_compression != 0

THE EVOLUTION OF THE WEB

Great visualization. Doesn't render correctly in IE. You'll need to use another browser like Safari.

Get the user list for an Active Directory group

dsquery group -samid SecurityGroup | dsget group -members -expand | findstr /i ",OU=UserAccounts," | dsget user -samid > c:\SecurityGroup_userlist.txt

Using SQL to generate cygwin curl command line to render all SSRS reports to a file on disk

use [ReportServer]
go

-- http://server/ReportServer?REPORT_PATH&rs:Command=Render&rs:Format=PDF&myparam1=Value1&myparam2=Value2
-- http://server/ReportServer?REPORT_PATH&rs:Command=Render&rs:Format=CSV&rc:FieldDelimiter=%09

SELECT
	'curl --ntlm -u "ntlmDomain\ntlmUserName:Password" "'
	+ replace(replace('http://server/ReportServer?REPORT_PATH&rs:Command=Render&rs:Format=CSV&rc:FieldDelimiter=%09', 'REPORT_PATH', c.Path),' ', '%20')
	+ '" > "' + replace(c.Path, '/', '_') + '.txt"'
FROM 
	[dbo].[Catalog] c
WHERE 
	Type = 2
	--and Path like '/BetaSite/%'

Programatically rendering SSRS reports and writing them to a file

http://geekswithblogs.net/bsherwin/archive/2007/04/29/112094.aspx
http://bytes.com/topic/sql-server/answers/728883-using-rs-exe-export-report-command-line-urgent
http://msdn.microsoft.com/en-us/library/ms162839.aspx
http://weblogs.sqlteam.com/tarad/archive/2005/01/05/3944.aspx
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=110451

SSRS rendering



http://MYSERVER/ReportServer?MyReport&rs:Command=Render&rs:Format=CSV&rc:FieldDelimiter=%09

http://MYSERVER/ReportServer?MyReport&rs:Command=Render&rs:Format=PDF&myparam1=Value1&myparam2=Value2



SQL Server: How to Figure out Peak/Off-Peak Hours of Production Databases

Bubble Heatmp in SSRS

selecting data from Excel tables using VBA

'select an entire column (data only)
s.Range("Table1[Column2]").Select
'select an entire column (data plus header)
s.Range("Table1[[#All],[Column1]]").Select
'select entire data section of table
s.Range("Table1").Select
'select entire table
s.Range("Table1[#All]").Select