The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,527 other followers

Archive for the ‘Database Development’ Category

Essential drop table animals – now with user-generated content – ThePracticalDev – O RLY?

Posted by jpluimers on 2019/04/17

Source:

'; DROP TABLE animals; --

Now with user-generated content!

O RLY? @ThePracticalDev

Via:

Also available as [WayBack] Big picture.

–jeroen

Posted in Database Development, Development, Fun | Leave a Comment »

Generating a million sequential numbers on the fly in a SQL Server query

Posted by jpluimers on 2019/01/16

A while back I wrote on Generating a million sequential numbers on the fly in a Firebird query – some solutions and speed measurements.

SQL Server has different features and performance characteristics so here are some links on doing similar things in SQL Server:

As always: if performance is important, measure before starting to optimise!

Via: [WayBack] sql – All hour of day – Stack Overflow

–jeroen

Posted in Database Development, Development, Firebird, SQL, SQL Server | Leave a Comment »

What RDBMS do you use when doing location-aware things? 

Posted by jpluimers on 2019/01/08

There was a nice discussion on [WayBack] What RDBMS do you use when doing location-aware things?More specifically, I am looking into a simple app with use of GPS… – Andrea Raimondi – Google+

TL;DR: use PostGIS on top of PostgresSQL.

–jeroen

Posted in Database Development, Development, PostGIS | Leave a Comment »

Lock conflict on no wait transaction

Posted by jpluimers on 2019/01/04

Just in case I ever run into this again: [WayBack] Lock conflict on no wait transaction

–jeroen

Posted in Database Development, Development, Firebird, Power User | Leave a Comment »

Can’t format message nn:mmm — message text not found

Posted by jpluimers on 2018/12/20

Lovely: people that perform incomplete Firebird deployments…

This means the firebird.msg file on the client is either not found or is a different version than the server.

Source: [WayBackCan’t format message nn:mmm — message text not found

–jeroen

Read the rest of this entry »

Posted in Database Development, Development, Firebird | Leave a Comment »

 
%d bloggers like this: