Extended Events is a powerful feature that was introduced into SQL Server 2008 and onwards. It keeps historical system health...
2017-10-12 (first published: 2017-10-07)
12,218 reads
In my previous two blogs – Capture Important Parameters of the SQL Server Replication and Add new articles to existing Transactional Replication...
2017-07-31 (first published: 2017-07-18)
2,783 reads
I always love to get my hands dirty with new features of SQL Server. I was exploring SQL Server on...
2017-07-27 (first published: 2017-07-14)
2,162 reads
Suppose, you have Transactional Replication configured in your production environment. There is a business requirement to add a new article to the...
2017-07-20 (first published: 2017-07-10)
11,815 reads
Whenever there is a business requirement to add a new article to an existing publication, you want to know how...
2017-07-13 (first published: 2017-07-03)
1,606 reads
One of the real-world I/O troubleshooting problems is – If you have your databases spread across multiple LUNs and you want...
2017-07-03 (first published: 2017-06-26)
4,181 reads
In last three years, I presented two times on the topic Transaction Log File Architecture. During the sessions, when I discussed...
2017-06-28 (first published: 2017-06-20)
1,539 reads