Category: Articles
-
SSIS Error Code 0xC02092B4
I was working on a SSIS package in SQL 2014 which was working there without any issues. Due to few factors we need to downgrade to work in SQL Server 2008 R2 for few months. I developed the packages in SQL 2008 BIDS and deployed. No changes done to any of the database objects as…
-
SQL Server 2016 – Tempdb Configuration During Installation
After couple of years I’m started playing around the pre release packages. Today I installed Windows Server 2016 Technical preview release 3 and SQL Server 2016 CTP 2.4 in my machine to play around the upcoming release.
-
April 2014 UG Meet
We are back in action 🙂 This time we will be conducting it after Tamil New year and before the election starts so that audience can enjoy their long leave or holidays.
-
Indirect Checkpoint – SQL Server 2012
I noticed an interesting feature that’s released with SQL Server 2012. In this version now you can set recovery time at database level. In other words now you can set when checkpoint should happen to a database which directly relates to the recovery time of the database. Before stepping into further I would like to…
-
Creating Oracle Linked Server in SQL Server
I wrote multiple articles on heterogeneous linked server which helped user to connect to Sybase , SQL Server & MySQL RDBMS platforms. However I missed creating Oracle linked server , many users responded to write an article on this so I decided to complete it. As you know when you create a heterogeneous linked server…