Additional Articles

How to ACTUALLY save money in the cloud with SQL Server

We have all heard migrating to the cloud can save you money and there are several ways moving your SQL Server workloads to the cloud can save your organization money. But, there are also missteps that can eat away at the savings, performance and even your availability creating instead an expensive, ineffective, difficult to manage cloud infrastructure.

2020-04-14

Working with SQL Cursors

In SQL cursors serve as a pointer that enables application programming language to deal with query results one row at a time. This article quickly explores the concept behind and show how to declare cursors, open, retrieve data from them, and then close them

2020-04-08

Database DevOps is gaining popularity

Fourty-six percent of the State of Database DevOps survey respondents advised they are performing some form of deployment automation. This figure has risen year on year as the conversation of DevOps in Database development continues, and the benefits become more apparent. If you are interested in more insight, you can download a copy of the 2020 State of Database DevOps report here.

Download now

2020-04-07

Blogs

What I learned from “The boy who cried wolf”

By

I was thinking about the story The boy who cried wolf earlier today and...

Automate deployment of Azure services with ARM Template

By

Automation is a useful thing. It allows to avoid many mistakes and saves a...

Daily Coping 28 May 2020

By

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

Read the latest Blogs

Forums

Just want record counts from two tables with 1:Many relationship

By jeffshelix

select count (H.Customs_Entry_Num) ,count(L.Customs_Entry_Num) FROM ADHOC.ATS_ESH H -- this table has only unique Entry...

Daily Coping 28 May 2020

By Steve Jones - SSC Editor

Today’s tip is to recall three things you’ve done that you are really proud...

Daily Coping 27 May 2020

By Steve Jones - SSC Editor

Today’s tip is to do something special today and revisit it in your memory...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers