- Follow Vinay Thakur on WordPress.com
Blog Hits
- 119,545 hits
Categories
- Add/remove (9)
- AI (5)
- Automation (2)
- Azure (5)
- Backup and Restore (15)
- Basic (14)
- BI (3)
- BIGDATA (6)
- Books (6)
- Bug (7)
- Cloud (7)
- Computers and Internet (29)
- Containerization (2)
- Database System (3)
- DB Design (3)
- DeadLock (3)
- Denali (36)
- DevOps (1)
- Disaster Recovery (18)
- DMV (6)
- Docker Swarm (2)
- Error Log (8)
- Experts (9)
- FileStream (1)
- Free Stuff (7)
- Future DBA (17)
- General (32)
- High Avaliability (23)
- History (3)
- Imp dates (3)
- Index (5)
- Installation (14)
- Internal (13)
- Isolation Level (2)
- Kubernetes/Docker/Container (8)
- Limitation (9)
- Linux (1)
- Lock/Blocking (7)
- Log Shipping (1)
- Memory (6)
- Migration (3)
- MongoDB (6)
- MySQL (26)
- News (4)
- NoSQL (10)
- Open Source (2)
- oracle (1)
- Others (105)
- Performance Tuning (26)
- Personal (5)
- Powershell (33)
- Python (2)
- RDBMS (8)
- Replication (20)
- Security (1)
- Software (4)
- sql 2016 (10)
- Sql server 2014 (2)
- SQL Server 2017 (9)
- SQL Server 2019 (6)
- SQLonLinux (8)
- SSRS (1)
- TempDB (5)
- Tool (14)
- Training (2)
- Transaction Log (13)
- Troubleshooting (50)
- vNext (4)
- Webcast (9)
- What I learned today (78)
- Whats New (48)
- Whitepapers (9)
Archives
- November 2021 (1)
- June 2021 (1)
- April 2020 (3)
- January 2020 (2)
- December 2019 (1)
- November 2019 (9)
- October 2019 (4)
- September 2019 (1)
- August 2019 (1)
- March 2019 (2)
- February 2019 (2)
- January 2019 (5)
- December 2018 (6)
- October 2018 (2)
- September 2018 (7)
- July 2018 (3)
- May 2018 (25)
- February 2018 (1)
- January 2018 (2)
- August 2017 (2)
- May 2017 (2)
- April 2017 (1)
- March 2017 (2)
- February 2017 (1)
- October 2016 (2)
- September 2016 (9)
- May 2016 (1)
- April 2016 (1)
- January 2016 (2)
- December 2015 (1)
- July 2015 (1)
- May 2015 (1)
- December 2014 (1)
- February 2014 (2)
- October 2013 (3)
- June 2013 (1)
- May 2013 (1)
- January 2013 (1)
- October 2012 (1)
- September 2012 (3)
- August 2012 (1)
- July 2012 (2)
- June 2012 (1)
- May 2012 (31)
- April 2012 (3)
- March 2012 (3)
- February 2012 (3)
- January 2012 (2)
- December 2011 (4)
- November 2011 (33)
- October 2011 (1)
- September 2011 (1)
- August 2011 (4)
- July 2011 (1)
- June 2011 (5)
- May 2011 (2)
- April 2011 (31)
- March 2011 (3)
- January 2011 (1)
- November 2010 (3)
- October 2010 (1)
- September 2010 (1)
- August 2010 (3)
- June 2010 (2)
- May 2010 (4)
- April 2010 (4)
- January 2010 (10)
- December 2009 (3)
- November 2009 (2)
- October 2009 (11)
- September 2009 (7)
- August 2009 (5)
- July 2009 (8)
- June 2009 (4)
- May 2009 (6)
- March 2009 (1)
- September 2008 (1)
- August 2008 (1)
- July 2008 (7)
Author Archives: Vinay
SQL Server 2022
yes SQL Server 2022 is coming and would have many advance features. https://www.microsoft.com/en-us/sql-server/sql-server-2022 whats new in SQL Server 2022 would be know more here: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/what-s-new-in-sql-server-2022/ba-p/2922227 Bob Ward would be sharing more on data explose about SQL Server 2022
Azure Arc
Azure arc is another great stuff coming with Microsoft Azure, as we were expecting Azure cloud Microsoft has great DevOps options and nice for everyone. Azure has multiple subscribtion option, where you can have Servers (Windows/Linux) and softwares include Database(s), … Continue reading
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)
Posted in AI, Python
Leave a comment
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 with multiple provides, SQL Server ML also provides build in, I … Continue reading
Posted in AI
Leave a comment
Machine Learning – Introduction
Machine Learning : it is a system where system will learn how the pattern is going and accordingly we can predict the future information. There are two types in machine learning: Classification Regression Classification: in this category it would be … Continue reading
Posted in AI
Leave a comment
Powershell : Desire State Configuration -DSC
Powershell in 2012, Powershell 4.x onwards introduced Desire State Configuration(DSC) which help to build the standard configuration/ process /template for your system state and can be use or maintain that state for compliance and standardization of our environment. this can … Continue reading
Posted in Automation, Future DBA, Others, Powershell, What I learned today, Whats New
Tagged Future DBA, Powershell
Leave a comment
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 providing the assessment for your sql server with general recommendation on … Continue reading
Posted in Future DBA, Others, Powershell, SQL Server 2019, SQLonLinux, What I learned today, Whats New
Tagged Future DBA, Powershell, SQL Server 2019, SQLonLinux, Whats New
Leave a comment
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 and would be available on gethub Early this year we got … Continue reading
Posted in Open Source, Others, Powershell, What I learned today, Whats New
Tagged Future DBA, Open Source, Powershell, vNext, Whats New
Leave a comment
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 BEGIN — add instructions to be executed for every rows SELECT @db_nm FETCH NEXT FROM db_cursor INTO Sys.Databases END CLOSE db_cursor DEALLOCATE db_cursor GO … Continue reading
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 same as dbcc loginfo which is non documented by Microsoft. SELECT … Continue reading