relational databases

External Article

Introduction to SQL for Cosmos DB

  • Article

This article by Adam Aspin reviews the Azure Cosmos DB SQL API from the perspective of the relational database developer. More specifically it will show you how to leverage your Structured Query Language skills to exploit the core possibilities of Cosmos DB as a NoSQL document database.

2019-03-25

219 reads

External Article

SQL Server on Amazon Web Services (AWS)

  • Article

Relational Database Service (RDS) and Amazon Elastic Compute Cloud (EC2) are two different approaches, with their own advantages and limitations, for making Microsoft SQL Server (MS SQL Server) available and maintaining MS SQL Server databases on Amazon Web Services (AWS).

2018-11-28

2,382 reads

External Article

Mixing MongoDB and Relational Databases in the Enterprise

  • Article

Your Agile developers want MongoDB, or a similar document database: your Ops people are concerned about security and backup, and Governance are muttering about transactionality and data transfer between systems. Do you restrict your developers from rapidly-evolving the data design for their domain or do you embrace the joys of NoSQL unconditionally? If you accept a polyglot database environment, where the NoSQL lambs coexist with the relational lions, how do you provide tools and common database concepts that everyone can use and understand?

2017-11-10

3,389 reads

External Article

How to Avoid Conditional JOINs in T-SQL

  • Article

Relational databases go out of their way to execute SQL, however bad the crimes against Codd and relational theory within the query might be. The 'conditional join' can be executed, but at great cost. As always, it is much better to sit back and restate the problem in a set-based way - Dwain Camps explains.

2015-10-02

7,474 reads

Technical Article

RE: delete rows less than 30 days

  • Reply

Heres a copy of the column in question.  AUDITTIMESTAMP 1087846893579 1087924923734 1104764681188 1104732392516 1087846893610 1104741005453 1087846893657 1104693744344 1104741246891 1087846893735I'm using this statement to see the dates, but I can't get it to work with deleting any records over 30 days old.  SELECT DATEADD(hh, - 05, DATEADD(ss, AUDITTIMESTAMP / 1000, '01/01/1970')) AS ts, * Thanks   

2005-05-06

Blogs

What Do I Do to Relax?

By

I’ve republished an editorial today from another author, called What do you do to...

Daily Coping 9 Dec 2022

By

Today’s coping tip is to find out something new about someone you care about....

Advent of Code 2022

By

Foreword Advent of Code is an annual event in which participants solve a series of...

Read the latest Blogs

Forums

các thế mai vàng đẹp và ý nghĩa phong thủy của chúng

By tt140411

các thế mai vàng đẹp và ý nghĩa phong thủy của chúng Trong giai...

Poking the Bear

By Grant Fritchey

Comments posted to this topic are about the item Poking the Bear

SSRS - Add end date for all SSRS subscriptions

By pwalter83

Hi, Could you please advice if it is possible to add an end date...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Temp Alias

See possible answers