Learn about the core SQL Server concepts to build your skill set including the architecture, database design, development, administration and more.

Discussion on Normalization and Database Design Concepts

by Sucharita Das

SQLServerCentral

Normalization

Introduction Relational database design helps to create a set of relations and tables, which are connected with each other through some defined relationships. The main purpose of relational database design is to preserve the information and minimize data redundancy. We need to follow some design guidelines for relational schemas to maintain the quality of the […]

Shared Security

by Steve Jones

SQLServerCentral

Security

Anytime shared security is in use, there is a problem.

DBA in training: SQL Server under the hood

by Additional Articles

SimpleTalk

SQL
Training

In this article of the series, Pamela Mooney explains the architecture of SQL Server under the hood, including some query anti-patterns to avoid.

Being Professional

by Steve Jones

SQLServerCentral

Career Growth

Being a professional is less about rules and more about respect.

Implementation of Normalization in SQL Server

by Sucharita Das

SQLServerCentral

Introduction In my last article, Discussion on Normalization and Database Design Concepts, I discussed about the normalization concepts. Here, I will take one table in SQL Server and implement different normal forms. As we move up the higher normal forms, we end up on more number of tables. Implementation of Normal Forms Let us start […]

Resolve Git Merge Conflict for SSIS Projects

by Additional Articles

MSSQLTips.com

DevOps and Continuous Delivery (CI/CD)

When working on an SSIS project with multiple developers, a merge conflict can occur in the git repository. In this tip we'll show you how to resolve this type of conflict and provide alternative options.

Securing SQL Server with DoD guidelines

by Additional Articles

Redgate

Vendors/3rd-party Products

Making sure your SQL Servers are secured against malicious users is difficult. The United States Defense Information Systems Agency (DISA) publishes a set of guidelines for organizations securing different pieces of software that connect to the US Department of Defense’s networks (DoD). Whether you’re working with the DoD or not, these Security Technical Implementation Guides (STIGs) are a good resource to help you understand potential security vulnerabilities and mitigate them.