|
|
Setting Up MySQL Replication
This is the second part of an article that I wrote discussing replication in MySQL. The first part of the article was a more general primer on what replication is and how it differs from clustering. The first part of the article can be found here.
Date: 2008-12-16
Finding And Using DateFormat Within SQL
Have you ever tried to find a DateFormat or date_format function in SQL Server? Chances are you probably ended up concatenating a bunch of DatePart strings to get the format you are looking for. What about grouping by a date in SQL Server?
Date: 2008-12-09
MySQL Replication
Replication is a way to run several SQL servers so that all of them have a current copy of a database or databases. Keep in mind that replication is not the same as clustering and should not be confused as such, even though replication can solve many of the same problems that clustering resolves; albeit in a different manner.
Date: 2008-11-19
Closing The Open Source Model Of MySQL
Okay, I didn't really want to write about Sun again today, but Simon has an interesting post about the "Sun Model" for open source business.
Date: 2008-11-04
SQL Loyalty And Competition
MySQL's Kaj Arno has an interesting post titled: "On Loyalty, Competition and Underdogs". Kaj starts with his son's list of reasons to stay with Bayern Munchen, the longtime favorite, or why to switch to TSV 1860, two German soccer/football teams.
Date: 2008-10-21
Microsoft Adds New Feature To SQL Server With Kilimanjaro
Microsoft has introduced a new managed self-service analysis capabilities code-named "Project Gemini," and self-service reporting in the next release of Microsoft SQL Server focused on Business Intelligence (BI) code-named "Kilimanjaro."
Date: 2008-10-08
Emulating LIMIT With MSSQL 2005
I don't like MSSQL, I prefer MySQL, but many times I have to deal with it at work. Lots of developers, including me and my co-worker Enrico, hate that Microsoft SQL hasn't something like MySQL's LIMIT(from, to). With some new T-SQL commands in Miscrosoft SQL Server 2005 there is a not-so-simple solution.
Date: 2008-09-16
Microsoft Tool Reduces SQL Injection Attacks
Microsoft has introduced a new security filter for its Internet Information Service (IIS) Web server that is aimed at reducing SQL injection attacks. The application called UrlScan 3.0 is free and is an add-on tool to IIS that offers real time verification of HTTP server requests, which help to block malicious code.
Date: 2008-08-22
Prevent SQL Injections With CFQUERYPARAM
If you haven't been using the cfqueryparam tag, chances are you had a baptism by fire this week. As you may have heard, lots of ColdFusion powered sites were targeted by hackers using SQL Injection this week.
Date: 2008-07-29
SQL Injection Finder Tool
This handy newly updated tool from the Code Plex can help parse your IIS Logs looking for the standard command sequences that indicate someone is trying to do an SQL injection attack against your IIS Servers.
Date: 2008-07-10
Tracking ColdFusion Problems With SQL Server Trace
Running a SQL Trace in the SQL Server Profiler can be a great way to track down performance problems in your ColdFusion application. However if you have tried to run one, you probably didn't see the actualy SQL queries your ColdFusion application was sending, only things like this:
Date: 2008-06-17
SQL Ninja Hacking Tool
There is a certain amount of respect earned when someone makes a hacking tool that not only does what it is supposed to do, but does it elegantly as well. While this tool is aimed at professional pen testers, this is one tool that should be in everyone's information security toolbox.
Date: 2008-05-27
OSS Customer Categorization
I've been thinking about this statement from Sun/MySQL's Marten Mickos: "There's a difference between organizations that have more time than money and organizations that have more money than time."
I coming to realize that OSS users split into three, not two, categories: A] An organization that has more time than money...
Date: 2008-05-01
Open Community And Closed Source Vendors
InfoWorld blogger Sean McCown at Database Underground wrote about a key difference between SQL Server & Oracle:"The answer is simple information. MS has built such a strong community and its members are committed to helping each other. There are so many forums out there you just don't have time to go to them all.
Date: 2008-04-01
Database Developers - Produce High Quality SQL Code Faster
A rich development environment simplifies SQL scripting, query building, object management, project management, and version control in live databases or offline source code repositories. Intuitive editing, debugging, and optimization tools help create high-performance SQL code.
Date: 2008-03-26
SolidDB For MySQL Development
As Matt reported last week, IBM announced that it was bowing out of the solidDB for MySQL project. "Those of you who know Solid's history know that Solid has long been a leader in the area of in-memory database software...
Date: 2008-03-11
INFORMATION_SCHEMA Support In MySQL, PostgreSQL
I've known about the INFORMATION_SCHEMA views (or system tables) in SQL Server for a while, but I just leared recently that they are actually part of the SQL-92 standard and supported on other database platforms.
Date: 2008-02-19
Sun, MySQL Merger - Open Source Sinergy?
While Sun Microsystems was buying MySQL for $1 billion, Rome was guesting the international conference "Boosting innovation and growth by fostering Open Source Software trust and quality", organized by the EC funded project QualiPSo.
Date: 2008-01-29
Flex, AIR, And SQL
I decided to give myself a new AIR/Flex project, one that would specifically use the built-in database. My project was a simple one - a time tracker. I currently use Side Job Track to track all of my clients, projects, and hours.
Date: 2008-01-04
|
|
