| |
Top Articles
Euro Open SQL Camp Begins August 22nd
[2009-06-23] The European edition of the OpenSQLCamp 2009, will take place in Sankt Augustin (Germany) on Saturday 22nd and Sunday 23rd within the Free and Open Source Conference 2009 - the German conference now in its fourth year.
Ntirety Gets Into MySQL Database Administration
[2009-06-02] MySQL is now officially under Ntirety's figurative umbrella. The Massachusetts-based company has expanded its remote database services to include the relational database management system, which should result in all sorts of benefits for users.
SaaS Version Of SQL Server Management Toolset Announced
[2009-05-08] Individuals and companies with ties to SQL Server may soon have a much easier time of things. Red Rock Consulting has released a Software as a Service (Saas) version of its RockSolid SQL Server Management toolset.
Oracle Slated To Buy Sun
[2009-04-21] The AP is reporting that Oracle will buy Sun shares for $9.50/share, $0.10 higher than IBM's reported offer which fell through. The deal is expected to close in this summer.
First Look At Predictive Analytic Software By SPSS
[2009-04-07] Today SPSS Inc. announced new product releases and new naming for its product families. Predictive Analytics Software (PASW) is the new umbrella and the four families are layered below this. The four families are Data Collection, Statistics, Modeling, and Deployment.
SQL Injection Attacks Receiving All Sorts Of Attention
[2009-03-24] Here's a tiny bit of good news for SQL experts: when a non-techie asks what you do, it's now less likely that your response will garner a blank stare. Unfortunately, this is because SQL injection attacks are becoming common to the point that the mainstream press is catching on.
Understanding SQL Language Restrictions
[2009-03-03] A. SQL LANGUAGE RESTRICTIONS The following is a list of major NON-ANSI and NON-ODBC SQL syntax provided by SQL Server which must not be used in the System Development Environment (SDE).
Developing And Utilizing SQL Naming Standards
[2009-02-10] The format for stored procedure names will be:
SafeNet Offers HSM That Works With MS SQL Server 08
[2009-01-20] SafeNet has announced that its Luna SA hardware security module (HSM) now works with Microsoft SQL Server 2008 for greater application security and performance by offloading select management functionality.
Setting Up MySQL Replication
[2008-12-16] 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.
Finding and Using DateFormat Within SQL
[2008-12-09] 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.
MySQL Replication
[2008-11-18] 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.
Closing the Open Source Model of MySQL
[2008-11-04] 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. Simon states that the model boils down to:
SQL Loyalty and Competition
[2008-10-21] 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. Kaj then draws parallels to the Oracle or MySQL question.
Microsoft Adds New Feature To SQL Server With Kilimanjaro
[2008-10-08] 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."
Emulating LIMIT with MSSQL 2005
[2008-09-16] 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.
Microsoft Tool Reduces SQL Injection Attacks
[2008-08-22] Microsoft has introduced a new security filter for its Internet Information Service (IIS) Web server that is aimed at reducing SQL injection attacks.
Prevent SQL Injections with CFQUERYPARAM
[2008-07-29] 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.
SQL Injection Finder Tool
[2008-07-10] 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.
Tracking ColdFusion Problems with SQL Server Trace
[2008-06-17] Running a SQL Trace in the SQL Server Profiler can be a great way to track down performance problems in your ColdFusion application.
SQL Ninja Hacking Tool
[2008-05-27] 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.
OSS Customer Categorization
[2008-05-01] I've been thinking about this statement from Sun/MySQL's Marten Mickos:
Open Community and Closed Source Vendors
[2008-04-01] InfoWorld blogger Sean McCown at Database Underground wrote about a key difference between SQL Server & Oracle:
SolidDB For MySQL Development
[2008-03-11] As Matt reported last week, IBM announced that it was bowing out of the solidDB for MySQL project.
INFORMATION_SCHEMA Support in MySQL, PostgreSQL
[2008-02-18] 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.
|
|
