Vinay Thakur


Blog Post

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

36 reads

Blog Post

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

24 reads

Blog Post

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

112 reads

Blog Post

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

67 reads

Blog Post

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

340 reads

Blog Post

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

111 reads

Blogs

The Book of Redgate: Products

By

We are product focused at Redgate Software. Here is another of our values that...

KDA: Echoes of Deception - Case 7

By

A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...

Do This Before You Contact Your SQL Server Consultant

By

Say you need outside help. You’ve exhausted all the things that you could do...

Read the latest Blogs

Forums

Implicit Conversions Cripple SQL Server

By sabyda

Comments posted to this topic are about the item Implicit Conversions Cripple SQL Server

BIT_COUNT() III

By Steve Jones - SSC Editor

Comments posted to this topic are about the item BIT_COUNT() III

The Mythical Bus Accident

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Mythical Bus Accident

Visit the forum

Question of the Day

BIT_COUNT() III

In SQL Server 2025, I run this code:

select bit_count(-1)
What is returned?

See possible answers