A fundamental skill for DBAs is to have a firm understanding of the SQL Server database engine's system databases. Tim Chapman discusses these system databases.

If any database uses replication on the server instance, you must also back up the distribution system database. Backups of these system databases let you restore and recover the [!INCLUDE ssNoVersion ...

SQL Server, düzgün çalışabilmesi ve kullanıcı veritabanlarının sağlıklı yönetilebilmesi için bazı temel sistem veritabanlarına ihtiyaç duyar. Sistem veritabanlarının her biri, SQL Server'ın sağlıklı ...

SQL Server has supported VLDBs (very large databases) for some time now. Back in the SQL Server 2000 days, I recall hearing multi-terabyte databases were unusual but doable. Now, they are commonplace, ...

With the latest public preview available, it's time to see if you want to upgrade to the most cloud-connected version of SQL Server so far.

Without awareness and understanding about these challenges - and their potential consequences - an organization's upgrade to SQL Server 2012/2014 can be costly, inefficient, and plagued by system ...

SQL databases have constraints on data types and consistency. NoSQL does away with them for the sake of speed, flexibility, and scale.