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,586 reads
Divya Agrawal
Finding the Correct Weekday Regardless of DateFirst
In this article, learn how to get the correct weekday regardless of the DateFirst setting on your server.
2010-02-19
10,929 reads
Problem with scripting objects through query
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,988 reads
Compatibility issue and CROSS APPLY
This article would help to solve a strange error dealing with compatibility issue while using CROSS APPLY
2009-08-06
5,974 reads
Split string using XML
Learn how you can split a delimited string in a single query using XML with Divya Agrawal.
2009-06-25
15,507 reads
Execute SQL job through batch file
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,552 reads
2009-05-25
1,460 reads
Calculate the Running Total for the last five Transactions
Calculate the Running Total for the last five Transactions on an Iterative basis
2008-11-27
5,113 reads
Compare Dates in an iterative manner for a particular set of records
Compare Dates in an iterative manner for a particular set of records in a single query using SQL Server 2000
2008-11-12
3,991 reads
Blogs
SQL Server is Slow, part 3 of 4
By Kevin3NF
In parts 1 and 2 of this series, we’ve gathered info and done the...
AI Model Size, Parameters and Download
By Steve Jones
At SQL Saturday Boston 2025, I gave a presentation on local LLMs and there...
SplashFlag - Building an IoT Swimming Notification Device from Scratch
By Bert Wagner
After setting up dozens of Internet of Things (IoT) smart home devices, I started...
Forums
caught off guard by some greek lettering in a warehouse feed
Hi we run 2019 standard. Our warehouse's ssis based etl is klunky but so...
Unlocking High-Concurrency Inserts in SQL Server with OPTIMIZE_FOR_SEQUENTIAL_KEY
Comments posted to this topic are about the item Unlocking High-Concurrency Inserts in SQL...
Vector Datatype
Comments posted to this topic are about the item Vector Datatype
Question of the Day
Vector Datatype
The new Vector datatype in SQL Server 2025 is a binary type that has a few parameters. What parameters are required?
See possible answers