Vinay Thakur


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

77 reads

Blog Post

Smart Tlog Bkp

another great new feature for SQL Server 2017 is a smart backup with dmv sys.dm_db_log_space_usage this DMV provide log usage information using this we can plan to initiate the...

2019-11-05

16 reads

Blog Post

SQL Server 2019 GA

Yes, Finally SQL Server 2019 is Generally Available yesterday Nov 4th 2019. It has many great features great videos: https://channel9.msdn.com/Niners/dutchdatadude   https://cloudblogs.microsoft.com/sqlserver/2019/11/04/gain-intelligence-over-data-with-sql-server-2019-now-generally-available/ https://cloudblogs.microsoft.com/sqlserver/2019/11/04/sql-server-2019-is-now-generally-available/    

2019-11-05

81 reads

Blog Post

Back to school

Hey, I realize that future we need to know Database system, No SQL and Big Data. with that as things are moving to machine learning and AI system which...

2019-11-02

12 reads

Blog Post

Error 9002

This is very important error whenever you see this error it is clear that your database has “TLOG FILE FULL” and this could result into maintenance job  failed or...

2019-10-30

24 reads

Blog Post

Read-only URL removal

When I blog to configure Read only replica. it would require to provide read-only URL information, and provide the replica sequence. but their is no easy way to remove...

2019-10-30

10 reads

Blogs

Calling a REST Endpoint from Azure SQL DB

By

External REST endpoint invocation in Azure SQL DB went GA in August 2023. Whereas...

Monday Monitor Tips – Adding Redgate Monitor Custom Metrics from SQLMonitorMetrics

By

This post talks about adding custom metrics from the sqlmonitormetrics.com site automatically and how...

Microsoft 365 Security and Compliance for Administrators, a Book Review

By

I was asked to review the following book by the publisher, and I must...

Read the latest Blogs

Forums

Use Polybase with ODBC to create external table

By blom0344

I'm trying to use the installed Polybase service on an  SQL 2019 server to...

how can vs see SSIS under my regular user id but not my admin?

By stan

Hi, we run vs 2022.   I'm stumped how when i run VS as admin...

error in both ssis and ssms - something about losing connections - new error

By stan

hi for about 4 or 5 days now, i've been seeing various connections (to...

Visit the forum

Question of the Day

The Last DBCC Date

How can I easily get the last DBCC CheckDB date from T-SQL in SQL Server 2022?

See possible answers