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,605 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,117 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

My first year on full disability, wow!

By

What a year … At the end of May 2024, I went on full...

Getting References for GenAI Results

By

I wrote an editorial on the view of GenAI tech from execs and someone...

SQL Server 2025 Is Here – AI Just Changed Everything!

By

🔟 Top 10 Features of SQL Server 2025 #SQLServer2025 #MicrosoftSQL #DatabaseUpdates #SQLAI #SQLFeatures #SQLServerCopilot #VectorSearch...

Read the latest Blogs

Forums

How to convert this to datetime format?

By water490

hi everyone I have a CSV that is storing date as "20180919T201400+0000".  I am...

Managing Fabric Lakehouse objects with the new CLI: Data Engineering with Fabric

By John Miner

Comments posted to this topic are about the item Managing Fabric Lakehouse objects with...

IT Unionization

By Steve Jones - SSC Editor

Comments posted to this topic are about the item IT Unionization

Visit the forum

Question of the Day

How Many Nested Triggers?

I have DDL trigger code that I'm working on in SQL Server 2022, but I am concerned that we might end up with multiple triggers firing and the response to the user is delayed. If I want to check how many triggers have fired, or are nested, how can I do this in my code?

See possible answers