Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

Browsing "MySQL"

0

Please don’t use blacklists, use parameterized queries or stored procs instead

Every now and then you will hear how some site will use a blacklist to ‘protect’ themselves against sql injection. Using a blacklist is very foolish because you can’t ever think of all the different ways that the bad guys will try to bypass your little…

Read More...
5

MySQL MyISAM and InnoDB Engine Differences

I am a stranger in a strange land. I am a SQL Server DBA and developer wandering, lost, in the world of MySQL. Fundamentally, I know that a database is a database. Both MySQL and SQL Server are built on the same ANSI standards. However, as I started wor…

Read More...
1

Anecdotes about SQL AKA post 400

This is my 400th blog post here on lessthandot and I decide to steal borrow Chrissie’s idea and ask a bunch of people if they have an interesting story to share about SQL.

Here is how I asked it

As you may or may not know I’m an avid SQL fan.
I’m…

Read More...
2

SQL Injection Pocket Reference for MySQL, SQL Server and Oracle

There is a nice SQL Injection Pocket Reference up on Google Docs

Here is what is covered

MySQL
Default Databases
Comment Out Query
Testing Injection
Strings
Numeric
In a login
Testing Version
MySQL-specific code
Database Credentials
Data…

Read More...
5

SQL Saturday in Chicago – Schedule is up!

Scheduled! The SQL Saturday in Chicago team has been working pretty hard lately on the schedule. It was difficult to complete due to all of the sessions being so good. I was close to trying a two day event so we could get all ~70 submissions up the weekend of April 17th. You can now […]

Read More...
0

Microsoft Announces SQL Server Migration Assistant for MySQL

This is just a quick post letting you know that Microsoft has announced the SQL Server Migration Assistant for MySQL This tool is available for download now.

Microsoft SQL Server Migration Assistant (SSMA) 2008 is a toolkit that dramatically cuts th…

Read More...
8

Introducing SQL Server to Oracle

Over the last few weeks I have been working on the task of bringing an Oracle database into my SQL Server landscape. The basic process that needs to be accomplished is to get this Oracle database pumped into the existing SQL Server structure primarily to address the reporting aspect and requirements. The software that utilizes […]

Read More...
13

SSMS Tools PACK, Something Every SQL Server Developer That Uses SSMS Should Have Installed

This post was already published yesterday, someone deleted it by mistake so I had to recreate it…sorry for that (and thanks for google cache :-))

SSMS Tools PACK is an Add-In (Add-On) for Microsoft SQL Server Management Studio and Microsoft SQL Se…

Read More...
3

An Interview With Kevin Kline About SQL In A Nutshell Third Edition

Most of the database developers these days don’t work with just one RDBMS, a large percentage will work with at least two of them. SQL In A Nutshell will help you with that, no longer do you have the need for two or more books open at the same time. I asked Kevin Kline if […]

Read More...