Replicate NetSuite Data to Azure SQL (SSIS in Azure Data Factory)
With Azure Data Factory V2 Integration Runtimes (ADFv2 IR), you can deploy enterprise replication tasks to the Azure cloud.
2020-07-17 (first published: 2019-01-02)
3,615 reads
Integration Services (SSIS_
Adding a Primary Key to a Prepopulated Table using a SQL Server Integration Services Package
In this tip we look at how you can use SSIS to build a package to add a primary key to an existing table that does not already have a primary key.
2018-12-03
2,109 reads
SSIS Basics: Data cleansing using derived columns
On this article I will show you how to perform a basic data cleansing using the derived column data transformation
2018-10-30
3,725 reads
Format Date with leading zeroes (T-SQL and VBScript)
Would someone please show me how to take a date and format it with leading zeroes. For example, 4/9/2005 and format it as 04/09/2005 (mm/dd/ccyy). I would like to know how to do this using T-SQL and ActiveXScript.Thanks in advance, Kevin
2005-05-06
9 reads
RE: User-Defined string Functions Transact-SQL
Igor, I'm doing a lot of work with string manipulation at the moment, and the AT and RAT functions will be certainly useful to me! Cheers!Alex
2005-05-05
RE: Need a RELIABLE table-exist test
If you truly need to use positive logic (IS NULL instead of IS NOT NULL) and you also want to check for a zero value, the NULLIF function does a nice job...IF NULLIF(OBJECT_ID('TempDB..##tablename'),0) IS NULL BEGIN yada...yada... ENDChecking for the temporary table name in SYSOBJECTS of the current database won't work because temp tables live […]
2005-04-29
Another Quickie- can Remi the demi(god) help again?!
Hi guys, I've heard there is a sql command which allows you to query a whole db for a certain column name and it will tell you what tables contani that column. Ie if you search for Customer_ID, it will tell you taht Customer_Details, Customer_Address, and so on all contain thiscolumn. Thanks!Alex
2005-04-29
Blogs
Hyperconverged storage tuning tip for SQL Server
By kleegeek
We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...
Daily Coping 25 Nov 2022
By Steve Jones
Today’s coping tip is to connect with someone from a different generation. This tip...
Snowflake Classic UI vs Snowsight
By Arun Sirpal
This blog post is not about which User Interface is better, Classic or Snowsight...
Forums
Can someone explain where non - clustered index is stored?
I am learning non-clustered and clustered indexing. When reading this article https://www.sqlshack.com/what-is-the-difference-between-clustered-and-non-clustered-indexes-in-sql-server/#:~:text=Clustered%20indexes%20only%20sort%20tables,involve%20any%20extra%20lookup%20step. came across this...
Null value when checking unused indexes
I'm using this query to check if I have any unused indexes.. One of...
Retrieve Password from CyberArk using powershell
Hi, I am new to Powershell script and i have to create a power...
Ask SSC