Database Design and Implementation

SQLServerCentral Article

Mathematicians and SQL

  • Article

Georg Ferdinand Ludwig Philipp Cantor is considered the creator of set theory, and his theories are the basis for the naïve set theory you learned in school. But there are lots of other mathematicians you should know, such as Hilbert, Frege, Russell, Zermelo and Dedekind. They made a lot of contributions, too. Hilbert Hilbert is […]

4.33 (3)

You rated this post out of 5. Change rating

2021-01-19

5,604 reads

SQLServerCentral Article

Data Element Names and Scoping Rules in SQL

  • Article

How you name data elements in databases and applications programs has often been a matter of personal taste. Decades ago, when I worked for state government, there is a COBOL programmer who would pick a theme for his programs. The paragraphs and variables would be named based on the current theme. One of his programs […]

4.2 (5)

You rated this post out of 5. Change rating

2021-01-11

2,115 reads

Technical Article

Designing Highly Scalable Database Architectures

  • DatabaseWeekly

While architecting cloud native applications, you need to ensure that your system is highly available, performant, scalable, fault tolerant, and has the capability to recover from a disaster scenario. In this article, Samir Behara discusses the options available when designing the database architecture to achieve scalability.

You rated this post out of 5. Change rating

2019-05-02

Blogs

What’s new in SQL Server 2025 CTP 2.0

By

Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...

Monday Monitor Tips: Beyond SQL Server

By

Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...

T-SQL REST API Integration in SQL Server 2025: Streamlining T-SQL Snapshot Backups

By

In this post, I’ll walk you through a T-SQL script that creates application-consistent snapshots...

Read the latest Blogs

Forums

Connect tabular model to excel via Power BI semantic model

By Bhagat

I have a tabular cube, with myself included in one of the roles. I...

New lightweight pure‑T‑SQL unit‑testing framework (T‑TEST) — feedback welcome

By uratol

  Hi all, I’ve just open‑sourced T‑TEST, a tiny alternative to tSQLt that lives...

Helpful Management Studio Settings and Features

By Tony Savoie

Comments posted to this topic are about the item Helpful Management Studio Settings and...

Visit the forum

Question of the Day

The Minimal Linked Server

What is the minimal number of parameters to add a linked server with sp_addlinkedserver?

See possible answers