SSIS Package documentor
Read and document multiple SSIS packages in an Excel file. The document can be used to do further code analysis.
2016-11-04 (first published: 2015-09-01)
17,780 reads
Read and document multiple SSIS packages in an Excel file. The document can be used to do further code analysis.
2016-11-04 (first published: 2015-09-01)
17,780 reads
In this article, learn how to get the correct weekday regardless of the DateFirst setting on your server.
2010-02-19
10,782 reads
This article from Divya Agrawal might help you to overcome the problem when multiple objects or statements are scripted together. This is technique that can eliminate errors from scripts built dynamically.
2009-10-30
1,977 reads
This article would help to solve a strange error dealing with compatibility issue while using CROSS APPLY
2009-08-06
5,869 reads
Learn how you can split a delimited string in a single query using XML with Divya Agrawal.
2009-06-25
15,317 reads
This article will show you how you can execute a SQL job with one click, allowing anyone to do this. Author Divya Agrawal shows a technique to let other users run jobs that do things such as perform a backup with a batch file.
2009-06-05
22,166 reads
2009-05-25
1,212 reads
Calculate the Running Total for the last five Transactions on an Iterative basis
2008-11-27
5,025 reads
Compare Dates in an iterative manner for a particular set of records in a single query using SQL Server 2000
2008-11-12
3,950 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers