Tag Archives: Reporting

What are the impersonation rights for my database users?

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

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

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