Author Archives: uday arumilli

How to control windows services from SQL Server?

How to control windows services from SQL Server? For a SQL Server DBA there are scenarios where he/she needs to deal with Windows services from SQL Server when there is no direct access to Windows server and only have access … Continue reading

Posted in SQL Server DBA | Tagged , , , , , , , , | Leave a comment

Incremental Load in ssis with example

This post demonstrates the incremental load in SSIS with example. Based on the business requirement and data volume we should determine the ETL process. We’ll assume we have a low to mid-sized source data file and here are the requirements: … Continue reading

Posted in MSBI, SSIS | Tagged , , , , , , , , , , , , , | 6 Comments

Script all Primary Keys, Foreign Keys in a SQL Server using T-SQL

Script all Primary Keys, Foreign Keys in a SQL Server using T-SQL Find the relationships between tables in sql server Get Primary Key and Foreign Key details using T-SQL   How to find all related tables of a given table? … Continue reading

Posted in SQL Development, SQL Scripts | Tagged , , , , , , | Leave a comment