SQLvariations: SQL Server, a little PowerShell, maybe some Hyper-V Rotating Header Image

Posts from ‘December, 2009’

SSAS Server Cant See Its Own Cubes in SSMS

One of the servers can’t see it’s own cubes. As a work-around you can Right-Click on the SSMS icon and select > Run as Administrator to get SSMS to see it’s own cubes: If you skip step in the setup where it asked you to add current user to AS server admin role, then you would need to run SSMS as administrator.

T-SQL Tuesday Date, Time, tricks with the DateTime Data Type

Adam Machanic told us all about a new craze sweeping the SQL Blogosphere Nation last week and that is T-SQL Tuesdays.  Real quick, the way it works is that on Patch-Tuesday everyone who’s got something to say about the topic of the month releases a blog post about it and the “Host” of the topic [...]

Get Adobe Flash playerPlugin by wpburn.com wordpress themes