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)
14,731 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
9,421 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,955 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,618 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
14,320 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
19,592 reads
2009-05-25
1,061 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,799 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,841 reads
Blogs
Ethics in Modern Data this Saturday with the South Florida Data Geeks
By Will Assaf
This Saturday Aug 7, Christine and I will present our joint presentation on Ethics...
3 Reasons Why Focusing on Tech Is The Worst Way To Deploy a HA/DR Solution
By kleegeek
This past Thursday, Edwin Sarmiento presented a session for our Microsoft Data Platform Continuity...
The PowerBI Volleyball Report – Organizing Data To Start
By Steve Jones
One of my goals this year was to build a report that I can...
Forums
Minimun Role Permissions Needed
Hi Friends, Please some guidance, To import a bacpac file in a MI instance,...
Need counts of payment amounts per week grouped by week
Hello, I have a code that suppose to give me weekly(summed) payments, but instead,...
Import CSV Data Into Existing Tables
Hi Guys, I am having issues trying to import data from CSV files into...
Ask SSC