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)
18,395 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)
18,395 reads
In this article, learn how to get the correct weekday regardless of the DateFirst setting on your server.
2010-02-19
10,904 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,981 reads
This article would help to solve a strange error dealing with compatibility issue while using CROSS APPLY
2009-08-06
5,934 reads
Learn how you can split a delimited string in a single query using XML with Divya Agrawal.
2009-06-25
15,466 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,483 reads
2009-05-25
1,385 reads
Calculate the Running Total for the last five Transactions on an Iterative basis
2008-11-27
5,107 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,988 reads
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
By Arun Sirpal
I do believe most people know about the ability to backup your SQL server...
I need to update greatherthan8 (category) record to Missing (status) if the same member...
Quick one I hope in case I'm heading off in entirely the wrong direction!...
Hi everyone I am looking at the size of my db on disk (ie...
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers