SqlServer-QA.net

Replication plays important role within the data-driven events in an Enterprise, vital to the sales-work force type of management. DBAs will always havea primary focus in providing protection for the data assets stored in SQL Server. Protection that covers the security and data recoverability is also equally important, during this process ...

When you have problems with SQL Server replication where the transactional replication is common case in setting up, eventually you will have problems when the data is growing up and any sudden changes in the ETL will also have affect on replication process. In this case I would suggest in referring to links ...

As a part of regular monthly meetings from Scottish Area SQL Server user group [Scottish Area SQL Server User Group: Wednesday 12th December 18:30 - 21:00 : Edinburgh] I have given a presentation on SQL Server Replication, type of SQL Server Replication, problems you may encounter setting up and configuring replication and where replication should ...

  SQL Server Compact edition is best used for replication purpose within the enterprise wide with a small footprint in-process database engine that allows developers to build robust applications for Windows Desktops and Mobile Devices. This download contains the files for SQL Server Compact 3.5 and Microsoft Synchronization Services ...

One of my Dev. DBA asked me this question about whether we need to use NOINIT or INIT for a differential backup schedule. Think about availability option in this case, you can overwrite the existing differential backup using INIT clause but when it comes to restore the combination of Full, Differential or set of Transaction log backups are ...