Hey, Everyone… our annual get-together of SQL professionals is happening on May 7th, at UNF, here in Jacksonville. I will be speaking at 9 AM on breaking into the world of Azure & PowerBI, using (mostly) the skills you likely already have in SSMS. From 9 to 5 PM it is one of your very best opportunities to learn a lot of new things, develop professionally, meet new people, enjoy a free lunch and…have a great time!
SSRS Data Source Lister
Sometimes, you’re in the middle of doing something, and you need an answer. You google it and find such a great solution, you want to keep it handy for … whenever! Here is such a post. As the title of my post indicates, you can list out the Data Sources that exist on an SSRS server… and you can do so with this code…which i got entirely from http://gallery.technet.microsoft.com/scriptcenter/List-connection-strings-of-1a9a9adc. Thank you Olaf Helper!
SSAS not logging?
So you’ve followed all the advice and set up logging so that you can know who is using your cubes. Things are good. One day you wake up and see that your logs no longer are logging. You open your cube yourself and browse. Then you re-check your logs…no entries. You KNOW the cube is working. You KNEW the log WAS logging. Why not now? Continue reading “SSAS not logging?”
SSRS subscriptions not working
- The problem: SSRS Subscription is not sending out emails.
- Where to find a typical error-log: C:\SQLServer\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles Continue reading “SSRS subscriptions not working”
SSRS Report History – keep more than 60 days
Many may know that the following query can get information about the history of reports being called.
Continue reading “SSRS Report History – keep more than 60 days”