Transaction replication info
Hi,To continue with the replication discussion, on my last post i discussed on some important commands and sp's for how...
2009-09-08
717 reads
Vinay Thakur
Replication troubleshooting.
Hi All,Continue on Transaction replication discussion: Today I would like to share some of the important ways of handling/troubleshooting replication...
2009-09-08
658 reads
How Log reader works- replication
Just saw the the answer by michael Hotek for how log reader works on replication: looks very great:http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/d2d2e1c6-01ee-439b-93e8-e31c77c0cd28/Thanks Michael Hotek...
2009-09-03
811 reads
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
745 reads
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
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
Conditional reIndex and update stats.
Hi,This script is very helpful, specially for sql server 2000. I made some changes into this.Thanx to T.Pullen for this...
2009-08-28
1,896 reads
Things to consider...
Hi.... I found some interesting COOL and Caution stuff on sql server, Will try to keep this updated....Cool Stuff:
1.SSMS: now...
2009-08-20
555 reads
What's new in Sql server 2008
Hi...Finally... the Complete Enterprise product sql server 2008 is a great product, it has everything includes features which other competitors...
2009-08-10
888 reads
What's new in Sql Server 2005
Its very difficult to write what all new in Sql server 2005, almost everything is new... the complete engine has...
2009-08-03
710 reads
Blogs
Friday Basics: the CIA Triad
By Brian Kelley
In information security (INFOSEC), there several foundational concepts and principles. One of the ones...
A New Word: the standard blues
By Steve Jones
the standard blues– n. the dispiriting awareness that the twists and turns of your...
How Redgate Flyway Can Boost Your DevOps Journey
By Chris Yates
A brief introduction to the tool and its advantages for database migrations DevOps is...
Forums
One more reason to use foreign key constraints
Comments posted to this topic are about the item One more reason to use...
client_app_name is empty in Extended Events output but present in sp_who2
I'm tracing activity on one database and would like to include the client_app_name in...
How to compare data in customer table with other customers to find related cust
select Custno, Addr1, City, Res_Phone, Bus_Phone, Fax_Phone, Marine_Phone, Pager_Phone, Other_Phone, email1, email2 from customer...
Question of the Day
The Marked Transaction
I want to mark a transaction in the log as a recovery point. How do I do this in my code if I use the transaction, myTran?
See possible answers