Knowledge is power. We love to share it.

News related to Mono products, services and latest developments in our community.

imarusic

Delegates in action, part 2: ASP.NET password encryption

06/10/2013 By imarusic 0
This content has not been rated yet. 
Bookmark and Share
Here is a real-world example of a task that is beyond the scope of standard SQL scripts. We will change the ASP.NET membership password format in MonoX and take care of the existing entries.
imarusic

SQL Tips & Tricks: changing column values in multiple tables

03/08/2013 By imarusic 0
Rated 5.00, 2 vote(s). 
Bookmark and Share

Learn how to write a simple SQL script that modifies all fields with a specified name and type from all tables in a database. 

Tags:
imarusic

Delegates in action

02/17/2013 By imarusic 0
This content has not been rated yet. 
Bookmark and Share

This blog covers one of the alternative solutions for dealing with tasks that require fetching and manipulating large amounts of data from the database. Of course, you can always rely on standard SQL scripts, but I feel that this approach allows for more flexibility.

kpeulic

SQL Tips & Tricks: full-text query optimization

01/20/2013 By kpeulic 0
Rated 3.67, 6 vote(s). 
Bookmark and Share
How to optimize your slow SQL full text index query that uses a combination of LEFT JOIN and OR operators. A simple switch to the EXISTS operator will make all your performance problems disappear in a moment.
idrazic

Different ways of importing data into SQL Server

03/31/2012 By idrazic 1
Rated 1.86, 28 vote(s). 
Bookmark and Share
Data import is one of those tasks that are performed on a daily basis. This post describes three different approaches for importing data into the SQL Server database.
Goran

Parsing a delimited string in SQL Server

09/20/2011 By Goran 3
Rated 3.29, 7 vote(s). 
Bookmark and Share
This tutorial will teach you how to write a custom SQL Server function for parsing delimited strings. It is particullary useful if you are passing a parameter that contains multiple string values to be used as a filter for “IN” expression in SQL.
Tags: