November 2009 - Posts

28 November 2009
A better way to arrange your query windows
The developers of Management Studio and, before that, Query Analyzer have made a bit of a habit of building killer features and then hiding them in the small print of Books Online. Now you may already know that SQL 2000 introduced a new way to arrange your query and result windows, but I only just found... Read More...
2 comment(s)
Filed under: ,
25 November 2009
How to process a cube in a SQL Agent job
It can be done but it's not well documented and it's complicated by the fact that you can't easily get the result of the process. Unless you actively check and manually raise an error if there's been a problem, the job will report sucess no matter how screwed up the cube processing is... Read More...
5 comment(s)
Filed under: , ,
22 November 2009
Is this log backup file the next one to restore?
When you restore from a transaction log backup, SQL Server checks the file against the database and gives you an error if the file is not the next one in the sequence. I wanted to know how this works so I did some digging. Not much in Books Online that I could see so I did some practical investigation... Read More...
no comments
Filed under:
10 November 2009
Idera discontinues SQLSafe Freeware Edition
No longer available for download. Check it out here: http://www.idera.com/Products/Free-Tools/SQL-safe-Freeware-Edition/ Bummer! I'm using this extensively. Now you have to choose between the Enterprise edition and the Lite Edition. The Lite Edition is $295 per instance, which is not quite as attractive... Read More...
no comments
Filed under:
02 November 2009
Report Manager folder & file security
Just found the answer to something that has been irritating me slightly for ages: how to give a user access to a report without giving them access to all the other reports in the folder. We have folders that are based on the roles people perform in the company. We granted the appropriate domain groups... Read More...
no comments
Filed under: , ,