Many times you do not initially install SSAS when you build your Sql Server instance. This posting will show you how to install. There will be future articles concerning Tabular Models and the cool things you can do with them.
Continue reading How to install SSAS (Sql Server Analysis Services)
Do you need to find the last restart time/date of your Sql Server, but only have access through Sql Server Management Studio? Running the query below will tell you the last time the service has been restarted.
Continue reading How to find last restart of Sql Server
Have you ever tried to schedule a task with Windows Task Scheduler, but it does not run? Instead you get this friendly error message:
Task Scheduler failed to start “\Task Name” task for user “Domain\username”. Additional Data: Error Value: 2147943785.
Continue reading Task Scheduler failed to start: 2147943785