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

16 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

42 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

309 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

35 reads

Blogs

Azure SQL Database – Contained user Model

By

I always follow a contained user model when setting up users within my Azure...

Logging Messages with Raiserror – #SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Daily Coping 8 Mar 2021

By

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

Read the latest Blogs

Forums

Wait for query to finish before returning results

By oRBIT

When I do "select * from ... " from a large table, the result...

Reading a Specific File from an S3 bucket Using Python

By prashant239

Comments posted to this topic are about the item Reading a Specific File from...

Distributed SQL Databases

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Distributed SQL Databases

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers