Vinay Thakur

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

15 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

7 reads

POWERSHELL -SQL Assessment

June/July 2019 Microsoft – powershell is providing another great feature with SMO and SQL Server module as SQL Assessment. This is a great feature where Microsoft- SQL Server is...

2020-01-01

33 reads

Next Powershell 6+ (CORE) and 7

Powershell is no longer been installed or delivered with windows bundle after 5.x and new powershell would be independent of windows/operating system. powershell would be a separate system /world...

2019-12-21

49 reads

Cursor Dynamic SQL

Today was working on SQL Server cursor standard cursor deification would be like this: sqlcursor from (Azure Data Studio) ———————————————————————————————————————– — Declare a cursor for a Table or a View ‘TableOrViewName’ in schema ‘dbo’ DECLARE @ColumnName1 NVARCHAR(50), @ColumnName2 NVARCHAR(50) DECLARE db_cursor CURSOR FOR SELECT name FROM dbo.TableOrViewName OPEN db_cursor FETCH NEXT FROM db_cursor INTO @ColumnName1, @ColumnName2 WHILE @@FETCH_STATUS = 0...

2019-11-19

304 reads

Transaction log Information gathering

Here are the different ways to know the tlog file related information sys.dm_db_log_stats – Provide summary of tlog information SELECT * FROM sys.dm_db_log_stats(db_id()) sys.dm_db_log_info -DMV function for VLF information...

2019-11-14

33 reads

Blogs

Migrating SQL Server container images to the Github Container Registry

By

A couple of months ago Docker announced that they would be implementing a 6...

Daily Coping 29 Oct 2020

By

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

What do they want to hear?

By

I was helping my 16yo write his first college essay the other day. He’s...

Read the latest Blogs

Forums

Looking for good beginner Data Base Administration book for advanced developer

By Lord Slaagh

Hello SSC, I have been a SQL developer for close to 20 years. I...

Import a PBIX file into Azure Analysis Services

By imani_technology

I want to import a Power BI PBIX file into Azure Analysis Services. I...

Using ADF Data Flow Derived Column transform against nested Delta structures

By cubemaster

I'm trying (without success) to use a derived column transform within an ADF Data...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Funny code

See possible answers