Vinay Thakur


Blog Post

Replication

Hi,Just want to share info about replication script which i generally use. this is good for sql server 2000 Transaction...

2009-09-03

746 reads

Blog Post

Data Type Synonyms

Today on sql server central QOD. very interesting question on Data Type Synonyms...
http://www.sqlservercentral.com/questions/Programming/67390/
We can use the synonyms data type also...

2009-09-02

626 reads

Blog Post

reading.

Reading another great book ( I know its old but good book)...Inside Microsoft sql server 2005: T-SQL QUERYING....by Itzik Ben - Gan.

2009-08-30

1,591 reads

Blog Post

Transaction isolation level

Transaction isolation level:1. Uncommitted Read (NoLock)2. Committed Read (blocking)3. Repeatable Read (phantom)4. Snapshot  (no blocking)5. Serializable (no blocking)Dirty Read:(DR)Non Repeatable Read:(NRR)Phantom:(P)Great...

2009-05-19

1,144 reads

Blogs

What’s new in SQL Server 2025 CTP 2.0

By

Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...

Monday Monitor Tips: Beyond SQL Server

By

Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...

T-SQL REST API Integration in SQL Server 2025: Streamlining T-SQL Snapshot Backups

By

In this post, I’ll walk you through a T-SQL script that creates application-consistent snapshots...

Read the latest Blogs

Forums

The Hidden Cost of Ignoring Software Bugs

By danishtariq1

Every expert knows you can't make perfect software that never crashes or has bugs....

Building Flame Diagram for MSSQL stored procedures

By tzimie

I wanted to share with you tools from my personal toolbox. If your code...

Connect tabular model to excel via Power BI semantic model

By Bhagat

I have a tabular cube, with myself included in one of the roles. I...

Visit the forum

Question of the Day

The Minimal Linked Server

What is the minimal number of parameters to add a linked server with sp_addlinkedserver?

See possible answers