Tag Archives: SQLTip

How to Change the Service Account for Analysis Services

As part of a routine check, I found that one of our servers had an instance of Analysis Services (SSAS) running under a local service account. As many of our solution pull data from various sources, on other servers, there is … Continue reading

Posted in Programming | Tagged , , | Leave a comment

Filtering SQL Agent Jobs

I suspect that any developer who has been near a SQL Server for more than just a short while, you will be able to recognize a list of SQL Agent jobs that can no longer can be seen in its full … Continue reading

Posted in Programming | Tagged , , | Leave a comment

How to Process Multiple Dimensions via BIDS and SSMS

This is one of those tips I need to write down, before I forget… Sometimes Analysis Services acts up and you need to do a process full on all the dimensions in the database. When that happens I usually turned … Continue reading

Posted in Programming | Tagged , , | 1 Comment

Never loose your server list in SSMS again…

Having to install new laptops, re-install old ones, configuring virtual servers or whenever you get the opportunity to install SQL Server from scratch, you always end up with an empty list of servers, when you try to connect through SQL … Continue reading

Posted in Programming | Tagged , , | 3 Comments

SQL Server Quick Tip 26 – 30

[Blog]: So you think you need Enterprise Edition, huh? http://t.co/zRWoumqRQf #DBA #SQLServer #SQLTip #in — Jens Vestergaard (@vestergaardj) July 4, 2013 A ratio between the size of max_server_memory and the size of the buffer pool extension of 1:16 or less … Continue reading

Posted in Programming | Tagged , , | Leave a comment