Stairway to U-SQL Level 21: Exporting Data with Azure Data Factory

Learn how you can move data from your Data Lake to Azure SQL Database with Azure Data Factory.

Understanding Azure Data Factory – A Cloud Based Integration Service

Azure Data Factory is a cloud based data integration service. This helps you to define, schedule and manage data pipelines to transfer and transform the data from disparate on premise and cloud data sources. Read on to learn more.

Azure Data Factory

Exporting Azure Data Factory (ADF) into TFS Source Control

Have you created a Data Factory in Azure and are wondering how to get it into TFS and source control? This article will show you how.

RE: Logshipping

****IAM page (4:62991) for object ID 2073058421 is incorrect. The table ID on page is 413960551; should be 2073058421. The entry in sysindexes may be incorrect or the IAM page may contain an error. The above error suggests that the sysindexes is corrupt - normally if any of the system tables is corrupt, it is hard to […]

RE: Login failed for user ''''(null)''''

Teresita,Your SQL Agent is running on a local account. you have to use a domain account for it. If your domain is SQL_Smart then use an account like that for your Agent on the publisher and grant access to that account on your SQL at the subscriber. 

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

RE: corrupt date column

Thanks! That was it. (tested from another box with no issues)Currently playing with Visual Web Developer 2005 Express Edition Beta (includes SQL 2005)I feel much better now. 

Removing a Full Text Catalog

I am trying to shrink a 50 Gb Db and I believe the Full Text Catalog is getting in the way. But trying to delete this object has not proven easy. I have tried the following:EXEC sp_fulltext_database 'enable'EXEC sp_fulltext_catalog 'ux_t100_full_text', 'drop'But the files are already gone so this returns an errorAccess is denied or the path […]

RE: Re: Problem w/ the cursor in sproc

Just correcting myself here : In my previous post I assume that you are creating a bitmap so I suggested you do something like this : Declare @BitMap as int set @BitMap = 0 Select @BitMap = @BitMap | MyBit from ( Select 1 as MyBit union all Select 2 as MyBit union all Select […]