Biml or Business Intelligence Markup Language is an open-source XML dialect to generate Integration Services (SSIS) packages. Take a look at this Biml tutorial to learn how you can use Biml to generate SSIS packages.
There is a stored procedure that must be run by only one user at a time. How do to I prevent multiple users from running the stored procedure at the same time? In this tip we look at using sp_getapplock and sp_releaseapplock.
We have SQL Server replication configured on our servers and every once in a while we find the SQL Agent replication jobs are stopped and data is not being replicated. We can find the status of the replication agents either using replication monitor or t
To gain insight into the evolving challenges for DBAs, a study was performed to survey DBAs and those responsible for the management of the corporate data management infrastructure. The more than 200 respondents came from a wide range of industries...