Tag Archives: SQLTip

Filtering Tables in #SQLServer Management Studio

As a quick tip, this on is one of these tool tips, that just makes your everyday much easier. Sometimes, more than often, you run into databases that contains a huge number of tables – all listed alphabetically. This can, at … Continue reading

Posted in Community, Entry Level, Programming | Tagged , , | 1 Comment

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 lose 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