Tag Archives: Reporting

What are the impersonation rights for my database users?

Posted on January 30, 2012 by

From time to time I get thrown the odd request to provide various bits of information from the SQL Server environment and most recently I was asked about a group of databases that required migrating to another instance. For some … Continue reading →

Posted in SQL, SQLServerPedia Syndication | Tagged , , , , , ,

T-SQL Tuesday #25 – The Best Tool You’ve Never Used

Posted on December 13, 2011 by

Wow, it’s been a long time since my last T-SQL Tuesday post and I have disappointingly missed it 5 times for one reason or another. Still, the important thing is that I am back people! This month’s T-SQL Tuesday is … Continue reading →

Posted in Events, SQL, SQLServerPedia Syndication, Storage, Windows | Tagged , , , | 4 Comments

Automating your snapshots

Posted on February 15, 2011 by

A little while ago I was talking to someone about possibilities of reporting from SQL Server to avoid impacting the production server and the very first thing that sprang to mind was for them to use snapshotting from a mirror. … Continue reading →

Posted in SQL, SQLServerPedia Syndication | Tagged , , , , , | 5 Comments