SQL

  • submit to reddit

Selecting a Random Row from Table in MySQL

  Here the simplest way of selecting random rows from the MySQL database with using "ORDER BY RAND()" clause in the query.

3 replies - 1396 views - 02/13/13 by Chara Miteo in Uncategorized

SQL Reporting Services Pricing Update

The team over at the Windows Azure blog recently updated the pricing for Azure SQL Reporting services.  From the blog : Effective today, the price for...

0 replies - 878 views - 02/05/13 by Eric Genesky in Articles

Are NoSQL and Big Data Just Hype? Interview with MySQL Creator, Monty Widenius

Conducted by Dmitry Sotnikov, COO of Jelastic , Oracle Duke’s Choice Award Winner for Java & PHP Platform-as-a-ServiceLast week, we had...

0 replies - 4452 views - 01/24/13 by Julia Wunder in Articles

NuoDB Live Product Launch - Jan 15, 2013

On January 15, 2013, NuoDB, the world’s first and only patented, elastically scalable, SQL/ACID database, becomes generally available! This...

0 replies - 775 views - 01/01/13 by Michael Waclawiczek in Announcements

Updated GemFire 7 Delivers Fast, Reliable Data at Cloud-Scale

Doubling-down on in-memory dataMemory is faster than disk. People realize that when they need to support high performance on-line applications. Recently many...

0 replies - 494 views - 10/30/12 by Stacey Schneider in Announcements

VMware’s Serengeti – Virtualized Hadoop at Cloud-scale

Not long ago I covered the topic of Big Data adoption in the enterprise. In it, I described how Serengeti enables enterprise to respond to common Hadoop...

0 replies - 839 views - 10/23/12 by Stacey Schneider in Announcements

RTM SQL Server 2012 Developer Training Kit Now Available

Microsoft Downloads - SQL Server 2012 Developer Training Kit Quick details Version: 1.0 Date published: 7/16/2012 Language: English ...

0 replies - 2354 views - 07/19/12 by Greg Duncan in Articles

WMS: Rethinking the Need For a CMS

Traditionally, Content Management Systems are about Content. Whenever Data that is  not simply a content page was going to be persisted in a CMS, you'd...

0 replies - 1570 views - 06/16/12 by Itamar Syn-hershko in Articles

Keep it Simple by Using LINQ to SQL

One of the fundamental truths of coding is the Kiss Principle. I think that using LINQ to SQL for data access is a splendid example of applying the Kiss...

0 replies - 3226 views - 05/08/12 by Anders Abel in Articles

Visual Studio 11 beta - Tooling for SQL Server Compact

Visual Studio 11 beta includes SQL Server Compact 4.0 SP1 CTP1, as I blogged about here. In this post, I will describe in greater detail the tooling support...

0 replies - 1718 views - 05/07/12 by Erik Ejlskov Jensen in Articles

Convert A Number From Any Base (between 2 And 36) To Base 10

0 replies - 7581 views - 05/02/12 by Anonymous in Uncategorized

Alpha Sort W/o Articles Of Speech ("A", "The", "An")

0 replies - 3112 views - 05/02/12 by Anonymous in Uncategorized

Turn A Date Range Into SQL Conditions

0 replies - 11140 views - 05/02/12 by Anonymous in Uncategorized

How Snippets Gets General Post Counts For Tags

0 replies - 4168 views - 05/02/12 by Anonymous in Uncategorized

MSH Host Function In SQL Server 2005

0 replies - 2019 views - 05/01/12 by Anonymous in Uncategorized