Skip to main content

Hadoop for .Net Developers

Just found a couple of great articles that lead you through the basics of using Hadoop in .Net. Understanding Hadoop Understanding Hadoop File System (HDFS) Programatically Loading Data into Hadoop File System (HDFS) Manually loading data into Hadoop File System (HDFS) Setting up a Hadoop development environment   Here’s a full list of the articles […]

Microsoft revokes trust in 28 of is own security certificates. Remember to run Windows Update today!

Microsoft has revoked 28 of its security certificates via Windows Update today as part of their security advisory 278973. The certificates have been revoked following the Flame malware attack that involved the use of fraudulent Microsoft digital certificates to by pass some security measures in windows to install the malware. This patch should be available […]

How to fix: User, group, or role ‘*’ already exists in the current database. (Microsoft SQL Server, Error: 15023)

How to fix: User, group, or role ‘*’ already exists in the current database. (Microsoft SQL Server, Error: 15023)

 If you’ve restored a database onto another server, you may get the following error message when adding user logins to the database: Create failed for User ‘TMS’. (Microsoft.SqlServer.Smo) User, group, or role ‘TMS’ already exists in the current database. (Microsoft SQL Server, Error: 15023)   To fix this there are two different methods depending on […]

SQL Server Table Function Performance

Rob Farley has a great post on when is a SQL function not a function? Read the two below functions – they return the same thing, but one is more effecient than the other. If you can’t see why, head over to Rob’s post that shows the execution plans for a great explaination. CREATE FUNCTION dbo.FetchSales_inline(@salespersonid […]

ANSWER: UPDATE failed because the following SET options have incorrect settings: ‘ANSI_NULLS, QUOTED_IDENTIFIER’

I came across an interesting problem last night – a stored procedure that had been created years ago was suddenly coming up with this error message: UPDATE failed because the following SET options have incorrect settings: ‘ANSI_NULLS, QUOTED_IDENTIFIER’. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or […]