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,480 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,122 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,921 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,201 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
11,578 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
16,475 reads
2009-05-25
1,041 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,432 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,725 reads
Blogs
Life Support 2008 – Audit Logons
Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep...
All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT
This is the first in a series of posts about gatekeeping in Information Technology...
None of the IP addresses configured for the availability group listener can be hosted by the server Either configure a public cluster network 19456
By MUTHUKKUMARAN KALIYAMOORTHY
Requirement: Remove a node from one of... [[ This is a content summary only. Visit...
Forums
full text search
Trying to understand why when I search for numerics in full text, contains does...
New CVE-2019-1068 vulnerability - is there a patch for MSSQL 2012?
MSSQL Server 2012 Service Pack 4 is officially supported until 2022-07-12: https://support.microsoft.com/en-us/lifecycle/search?alpha=sql%20server%202012 The new...
SSIS Package/Agent Job Not Failing!!!
I have a package running in SQL 2016 using Project Deployment. One of the...
Ask SSC