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,609 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,134 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

SQL Saturday Baton Rouge 2025

By

SQL Saturday Baton Rouge is a great event hosted on LSU’s campus that has...

Responsible AI: Why Leaders Need More Than Just Guardrails

By

In the rush to adopt artificial intelligence, many organizations have quickly built ethical frameworks,...

TempDB Performance Tuning in SQL Server 2022 vs 2016 vs 2019

By

📘 What Is TempDB and Why It Matters TempDB is a shared system database in SQL...

Read the latest Blogs

Forums

How to optimize queries using AI (SQL Expert)

By Daniel Calbimonte

Comments posted to this topic are about the item How to optimize queries using...

How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory

By Chandan Shukla

Comments posted to this topic are about the item How a Legacy Logic Choked...

Planning for the Right Emergency Response

By Grant Fritchey

Comments posted to this topic are about the item Planning for the Right Emergency...

Visit the forum

Question of the Day

Capacity Planning for an Existing SQL Server Workload?

You're tasked with planning capacity for a new SQL Server database workload. Which of the following is the most accurate way to determine how much CPU, memory, and I/O throughput your workload requires?  What single or multiple tools would you use to answer the questions around resource needs?

See possible answers