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

14 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

6 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

SQL Clone Works with FILESTREAM

By

SQL Clone is an amazing product that virtualizes your data, allowing multiple instances to...

Fun and profit with UTF-8

By

When SQL Server 2019 was announced, it brought with it UTF-8 support. Also available...

Data Platform MVP 2020

By

I am humbled to be among so many great professionals and honored at the...

Read the latest Blogs

Forums

Removing TDE from a Database: Level 4 Stairway to TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE from a Database:...

Database Modeling - Relationships

By ukashishgarg

Comments posted to this topic are about the item Database Modeling - Relationships, which...

Read database objects relationship in easy steps

By ukashishgarg

Comments posted to this topic are about the item Read database objects relationship in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers