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,622 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,622 reads
In this article, learn how to get the correct weekday regardless of the DateFirst setting on your server.
2010-02-19
10,931 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,989 reads
This article would help to solve a strange error dealing with compatibility issue while using CROSS APPLY
2009-08-06
5,981 reads
Learn how you can split a delimited string in a single query using XML with Divya Agrawal.
2009-06-25
15,511 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,558 reads
2009-05-25
1,465 reads
Calculate the Running Total for the last five Transactions on an Iterative basis
2008-11-27
5,117 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,992 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Comments posted to this topic are about the item Create an HTML Report on...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Comments posted to this topic are about the item Be Wary of Data
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate, o_orderkey, o_custkey, o_storekey FROMdbo.orders WHEREo_orderkey = 3877;