Database Design and Implementation

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)

2021-01-19

5,169 reads

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)

2021-01-11

1,554 reads

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.

2019-05-02

Blogs

T-SQL Tuesday Retrospective #015: Automation

By

In February 2011, Pat Wright invited us to talk about Automation: So the topic...

Daily Coping 12 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Updated Pluralsight Course – Managing the Kubernetes API Server and Pods

By

My updated course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! If...

Read the latest Blogs

Forums

SQL 2012 Standard - Index highly fragmented

By mjbc

Hi there, Complete newb.  Need some guidance. Running SQL 2012, running INFOR ERP.  Indexes...

Manual tasks in SSIS design

By Roust_m

Hi, I am getting CSV files with hundreds of columns many of which have...

Loading a csv file into sql server table

By Roust_m

Hi, I've created a simple dataflow with flat file source and sql server destination....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers