Tag Archives: administration

Tracking Logins with Extended Events

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as#SQLNewBloggers. I was building a question the other day on Extended Events and needed to build a new session. One of … Continue reading

Posted in Blog | Tagged , , , , | 4 Comments

The Writeable Warm Standby

I saw a question recently that went like this: I get one full backup from FTP. I’ll get daily log backups through FTP after this, but never another full. I need to restore this daily log backup and allow the … Continue reading

Posted in Blog | Tagged , , , | Comments Off on The Writeable Warm Standby

Virtual Failback

I saw a very interesting tweet from Scott Stauffer asking this: “… looking for quick’n’easy way to make workload virtual w/ fail-fast method to physical if performance doesn’t meet expectation.” This was part of a conversation Scott was having in looking to … Continue reading

Posted in Editorial | Tagged , | Comments Off on Virtual Failback

Learn to Use Filegroups

This editorial was originally published on May 12, 2011. It is being re-run as Steve is away at SQL Relay today. In SQL Server, filegroups are a management technique that I don’t see many people using. It’s amazing how many … Continue reading

Posted in Editorial | Tagged , | Comments Off on Learn to Use Filegroups