SQL-Articles

Data Engineering – Learn from the experts

  • Change Transfer Schema for all Objects

    In my working environment we will be using different schema for production and development environments. Our development apps are configured to Dev schema and Production apps are configured to Prod schema, so when we restore the db from production to development environment, all our dev apps stopped working since the objects securable will be using…

  • Monitoring Replication using Scripts(Version 1.0)

    This script can be used to monitor replication using scripts instead of logging into the server and using replication monitor. It gives information on Transactional replication status.

  • Adding article to existing publication without generating a full snapshot

    This SP can be used to add articles to the existing publication without starting snapshot for all the tables. When Snapshot is started it will create snapshot only for the newly added article to the publication

  • December Month UG session scheduled

    We are ready for December month session, please goahead and register for the same. Venue: Microsoft Training centre, Radhakrishnan Salai, Chennai Landmark: Opposite to President hotel Timings: 10:00 AM to 01:00 PM Date: 19th Dec 2009

  • Creating Linked server to SYBASE from SQL Server

    In this article we going to look into creating a heterogeneous linked server. i.e. We are going to create a linked server to SYBASE database server from SQL Server environment and then going to query datas from Sybase. First step in heterogeneous linked server is to create a ODBC connection to that RDBMS platform. For…

Got any recommendations?

Get In Touch