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
51 reads
Blog Posts
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
29 reads
Daily Coping 27 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-27
4 reads
Explain RDBMS and History of SQL Server?
RDBMS means Relations Database Management System. RDBMS is one of the DBMS types where data is stored in 2 dimension structures called “Table”. RDBMS stores data in table format...
2020-04-27
74 reads
It’s 2020, Do I really need to DBCC CHECKDB?
I’ll start by saying that I swear I posted this at some point in the past but I don’t see it looking back at old posts. This is from...
2020-04-27 (first published: 2020-04-15)
1,538 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
11 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
6 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
102 reads
T-SQL Tuesday Live–28 Apr 2020
Once again, I’ll be live tomorrow, ready to just chat, shoot the breeze, answer tech questions, anything. No agenda, but I’m on for an hour. If you’re bored, struggling,...
2020-04-27
5 reads
What is the datatype SQL_VARIANT
The SQL_VARIANT data type is an interesting beast. It is a data type that can store most types of data. ... Continue reading
2020-04-27 (first published: 2020-04-16)
599 reads
Blogs
SQL Server 2025 GAs Today
By Steve Jones
If you aren’t watching the Ignite keynotes today, then you might have missed the...
Run SQL Server 2025 and SQL Server Management Studio on macOS Tahoe
Short version You want to get this running as fast as possible. Do these...
The Roundup for T-SQL Tuesday #192
By Steve Jones
Last week I asked you to write about SQL Server 2025 and what things...
Forums
SQL Server 2025 has arrived!
Comments posted to this topic are about the item SQL Server 2025 has arrived!
Don't Create Workslop
Comments posted to this topic are about the item Don't Create Workslop
What is the original database name?
Comments posted to this topic are about the item What is the original database...
Question of the Day
What is the original database name?
What is returned when this code is run?
SELECT ORIGINAL_DB_NAME()See possible answers