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)
12,898 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
7,469 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,924 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,277 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
12,066 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
17,012 reads
2009-05-25
1,046 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
4,494 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,734 reads
Blogs
Transaction log Information gathering
By Vinay Thakur
Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...
What's New in SQL 2019? at BRSSUG
By Will Assaf
Thanks to everyone who joined the BRSSUG for a night all about SQL Server...
Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 3
By Gerard
This is the third post in a series about modern Data Lake Architecture where...
Forums
Using crypt_gen_random to generate unique Serial Numbers
Trying to generate unique serial numbers with alphanumerics (A-Z,a-z,0-9) and no special characters.Used below...
OPENQUERY is not inserting identical rows
Hi, Thanks in advance for any help. I am trying to insert into a...
Azure file copy creating a directory to hold the renamed file
Hi All, I'm pretty new to azure and am hitting the following problem. I've...
Ask SSC