Daily Coping 29 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-29
20 reads
SKLearn – Python
4 Steps: Import Class: or from sklearn.linear model import logistic regression instantiate / estimates or logreg=logistic regression Fit model with data [ Model Training ] logreg.fit(x,y) Predict response: logreg.predict(x)
2020-04-28
37 reads
Clustered Index Key – Natural or Surrogate?
This article will follow a practical approach to choose the right candidate for clustered index. It'll investigate through the best practices recommended for clustered index, with the help of...
2020-05-13 (first published: 2020-04-28)
861 reads
Daily Coping 28 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-28
27 reads
Checking for SQL Server Updates with dbatools
It turns out I was doing this all wrong for months. For the longest time, I’ve been checking my SQL Server instances to see what needs patching with Test-DbaBuild...
2021-04-26 (first published: 2020-04-28)
962 reads
Installing SQL Server 2019 on Azure VM
Unfortunately, this is not an on-premises SQL Server install because I do not have the right operating system available for SQL Server 2019, which includes the below: Windows 2016...
2020-04-28
62 reads
Checking for SQL Server Updates with dbatools
It turns out I was doing this all wrong for months.
For the longest time, I’ve been checking my SQL Server instances to see what needs patching with Test-DbaBuild from...
2020-04-28
82 reads
ML Models
In this series I would be talking mostly about Python and R, we would understand the different ML model supported in Python. Python is a great open source language...
2020-04-27
25 reads
SSDT: Scripting static data from SQL Server (video)
Out of the box, SSDT covers objects on a database level, like tables, stored procedures, views, functions, etc. That means schema only. In many cases, there is a need...
2020-04-27
107 reads
Register for Data Platform Discovery on Apr 29
The agenda is out for the US Data Platform Discovery Day. It’s online, and takes place this Wednesday, April 29, 2020. You can register and check out all the...
2020-04-27
15 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