Tag Archives: administration

Creating a Database Snapshot

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I’ve rarely dealt with database snapshots, outside of lab experimentation. They didn’t exist when I did most of my … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

Disabling SQL Server Network Protocols

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran across a question on network protocols recently, which is something I rarely deal with. Often the default … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Disabling SQL Server Network Protocols

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