Machine Learning – Introduction
Machine Learning : it is a system where system will learn how the pattern is going and accordingly we can predict the future information. There are two types in...
2021-04-27 (first published: 2020-04-26)
448 reads
Stairway to Microsoft Azure SQL Database Part 1 : Deployment Options
Recently I started working with Azure SQL Database. It took some time for me to understand the concepts of the Azure SQL database. Earlier I have experience in AWS...
2020-04-26
17 reads
Stairway to Microsoft Azure SQL Database Part 1 : Deployment Options
Recently I started working with Azure SQL Database. It took some time for me to understand the concepts of the Azure SQL database. Earlier I have experience in AWS...
2020-04-26
314 reads
I’m Speaking at #DataWeekender
With all our in-person events cancelled for the foreseeable future, I was so excited to find that some community folks are not sitting back and waiting for the social...
2020-04-25
28 reads
Daily Coping 24 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-24
36 reads
Data Bits – Episode 7 – Mary Elizabeth McNeely
20+ year Oracle DBA Mary Elizabeth stopped by the Data Bits virtual studio today! Quotables: “Corona Curls”, “rolling around in the food” and “Capitalist Pirate” You can reach Mary...
2020-04-24
21 reads
Working from Home Effectively
Some of us have been lucky enough to have already been working from home (WFH) prior to the world events. This has allowed most of us the ability to...
2020-04-24
138 reads
Working from Home Effectively
Some of us have been lucky enough to have already been working from home (WFH) prior to the world events. This has allowed most of us the ability to...
2020-05-06 (first published: 2020-04-24)
610 reads
Join the Best Worst Code Contest today at 5pm BST / Noon Eastern #BestWorstCode
I have an idea! Let’s have a “Worst Code Contest.” Why do this? Bad code is really fun — at least, when you write it on purpose. And other...
2020-04-24
41 reads
Launch of YouTube Video Channel
Dear Friends We are launching the YouTube Channel “Decode ITES”. Decode ITES will be sharing technical videos over multiple IT infra skills like SQL Server, Postgres, Oracle, Windows, Public...
2020-04-24
90 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
The Range of Customers
Comments posted to this topic are about the item The Range of Customers
Question of the Day
The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers