data – SQL Padawan

Troubleshooting Transactional Replication – part 1

The common way to replicate data and objects from one server to another is using transactional replication. As you know, SQL Server processes

In a post about how update works I showed what happened when run an update with the same values. SQL Server

When thinking about migration the most common issue is downtime. There are some methods that require downtime like backup/restore or

All system databases, except the resource database, can be moved to new locations to help balance I/O load. To move

SQL Server stores data in heaps or b-tree structures. Heaps are unordered set and balanced trees are ordered by their