-
-
Recent Posts
Categories
- Certification (2)
- Cloud Computing (5)
- Community (47)
- Docker (1)
- Events (66)
- Inside SQLSaturday (1)
- Learning (4)
- Linux (27)
- Networking (8)
- Oracle (5)
- Personal Development (46)
- PowerShell (1)
- Public Speaking (1)
- Security (7)
- SharePoint (3)
- SQL (129)
- SQLSaturday (2)
- SQLServerPedia Syndication (166)
- SSIS (3)
- Storage (9)
- Systems Center (1)
- Uncategorized (1)
- Virtualization (14)
- Windows (32)
Tags
- 24HOP
- Active Directory
- AlwaysOn
- APT
- Automation
- Availability
- Availability Groups
- Backup and Recovery
- Blogger Table
- Business
- C#
- Charity
- Clustering
- Concurrency
- Connectivity
- Constraints
- Database
- DBMS_SCHEDULER
- Desktop
- Development
- Disable
- DMV
- DNS
- Dockercon
- dotnet
- Enable
- Error
- Escalation
- File-System
- GUI
- Humour
- Hyper-V
- Integrity
- Isolation Levels
- Jobs
- Kalen Delaney
- Linux
- Listener
- Locking
- Mirroring
- NETBIOS
- Nomcom
- Parallelism
- PASS Summit
- Performance
- Public Speaking
- Quorum
- RAC
- Reporting
- Rodney Landrum
- Ruben Pertusa Lopez
- Scale-Out
- Scheduling
- Schema
- Security
- Setup
- SharePoint Saturday
- Skype
- Snapshots
- SQLBits
- sqlcmd
- SQL Nexus
- SQLRally
- SQLSaturday
- SSMS
- Stored Procedure
- Systems Center
- T-SQL
- T-SQL Tuesday
- TCPIP
- Tuning
- Users
- VirtualBox
- Wait Stats
- WINE
Tag Archives: Mirroring
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 Automation, Backup and Recovery, Database, Mirroring, Reporting, Snapshots
5 Comments
Back to front mirror
SQL Server database mirroring was obviously a great feature first introduced in SQL 2005 and will improve even further in the next big release (Denali) but quite surprising to me is how drastically the order in which the transactions are … Continue reading
Posted in SQL, SQLServerPedia Syndication
Tagged Availability, Database, Mirroring
