Tag: sql
News (257)
Microsoft relaxes virtualisation rules
Microsoft has eased up its server licensing rules so that organisations can make more efficient use of servers in virtualised environments. Read more »
Microsoft releases SQL Server 2008
Microsoft said on Wednesday in the US that it had finished work on SQL Server 2008, the latest version of its database software. Read more »
IBM chides security researchers
Technology giant IBM has taken independent security researchers to task for their role in making information about unpublished computer attacks available in an undisciplined manner. Read more »
When worlds collide: Microsoft funds Apache
Microsoft, one of the biggest rivals to open source programming, has begun funding the Apache Software Foundation (ASF), one of open source software's biggest supporters. Read more »
Google's Blogger number one for malware
Search giant Google has catapulted itself to the top in the ranks of web hosts with the most malware, courtesy of its blogging website Blogger, according to security vendor Sophos. Read more »
Drizzle: MySQL slims down on Aker's diet
Brian Aker, MySQL's director of architecture, has unveiled Drizzle, a database project aimed at powering websites with massive concurrency as well as trimming superfluous functionality from MySQL. Read more »
Unisys wants AU$250k open source advocate
The Australian arm of IT services multinational Unisys has placed an advertisement for an evangelist to plug open source software locally, with a potential pay packet of AU$250,000 per year. Read more »
Microsoft fixes DNS flaw but warns of Word attacks
Microsoft is warning that a Word flaw is being used for targeted attacks, and has also issued four 'important' patches, including one for a potentially serious DNS flaw in the latest Patch Tuesday bulletin. Read more »
PlayStation 3 site hacked, 2.40 upgrade suspended
Sony has suspended its PlayStation 2.40 firmware upgrade following reports it has fouled up some users' systems — Sony has also removed hacked pages on its Playstation web site. Read more »
New tools to prevent Microsoft SQL attacks
Microsoft has issued new tools to assist Microsoft ASP and ASP.NET technologies against recent Web-based attacks. Read more »
Features (454)
Copy legacy Oracle tables with SQL*Plus
Tables with a LONG datatype cannot be copied via the CREATE TABLE AS SELECT syntax. They can, however, be copied with the SQL*Plus COPY command. This Oracle tip shows you how. Read more »
Capturing SQL Server 2005 database file size information
It's very important to capture trends of the sizes of your SQL Server 2005 database because it allows you to plan for future space needs, notice types of problems, and plan for time periods of heavy volume. I'll show you the simple method that I use to capture this information. Read more »
What does a DBA do all day?
Data integrity is a DBA's number one responsibility, but do you know what else they do all day? Read more »
Choose the right JDBC driver for your database interface
Picking the right driver can optimise connectivity between your Java apps and database. Read more »
Render SQL*Plus output in HTML
SQL*Plus has traditionally been thought of as a plain text SQL query tool. But since Oracle 8i, it has also had the capability to render its output using HTML. Read more »
RIFE with possibilities
Developing a web-based application is never a small undertaking. At the very best it's a lot of work just to develop the code that does whatever it is your application is supposed to do but before you even get to the point of writing your application's code, you have to decide what you going to write it in. Read more »
Delegate privileges to users with sudo
One of my favourite tools is sudo, a program that many users will be familiar with. Both Ubuntu and OS X popularised sudo by making efficient and default use of the program. Sudo allows regular users to perform commands as other users. Read more »
Comparing SQL Server constraints and DML triggers
This article sheds some light on when to use constraints and when to use DML triggers. Read more »
Create cross-platform database-driven applications with JDBC
The Java Database Connectivity (JDBC) API offers a unified interface to different databases, providing a series of generic functions that are internally translated into native function calls. This makes it extremely easy to create database-driven applications that work across different RDBMS types. Read more »
Iterating through tables and databases in SQL Server
We look at two very useful stored procedures that live in the master database but are not mentioned in SQL Server Books Online. These system procedures come in very handy for jobs such as determining the space used, the number of rows, the indexes on the user tables, and so on. Read more »
Video (4)
Eliminating boilerplate code with LINQ
Jason Zander, general manager of Visual Studio, Microsoft, explains the advantages of using LINQ. Read more »
Working with LINQ in Visual Studio 2008
One of the new features in Visual Studio 2008 is LINQ -- a query language that allows access to SQL databases, XML and local data stores with one interface. Read more »
The missing LINQ
Coming out with the next version of Visual Studio and .NET, LINQ is a new feature that allows developers to iterate through data sources using an SQL-like syntax. Read more »
Blog (28)
Microsoft services VS2008 & .NET 3.5
-- Microsoft has just announced the release to manufacturing of the .NET Framework 3.5 Service Pack 1 (SP1) and Visual Studio 2008 SP1. Read more »
Q&A with EditMe: A wiki for non-geeks
-- Finally, a wiki CMS solution that you can safely give to your clients to use. But sshhhh... don't call it a wiki... Read more »
The future remains yesterday
-- Remember when MySQL was blazingly fast and cared little for SQL standards? When MySQL regarded a view as something nice from your window and a trigger was treated as a weaponry component? Those days are set to return with a MySQL fork called Drizzle. Read more »
Install Web stacks in an instant with BitNami
-- Need to set up a server environment to run Web applications such as WordPress, MediaWiki, Joomla, Trac, DocuWiki, or Drupal? Here's how to do it in less than two minutes with free software. Read more »
Jonathan Schwartz's free software foundation
-- Sun has become its own free software foundation, open sourcing everything from Java to Solaris, and acquiring the open source MySQL database for $1 billion in January of this year, as a way to grow its revenue. Read more »
Google App Engine meets Amazon EC2
-- What do you get when you cross Amazon's EC2 on-demand cloud computing infrastructure with Google's new App Exchange foundation for Web applications? Read more »
Feeling fines with Microsoft
-- This week had Microsoft-related news coming at us from left, right and centre -- fines, launches and more Steve Ballmer than you can handle. Read more »
Microsoft says "open sesame"
-- While you may have been out last night watching the latest Rambo adventure with Sly Stallone making war for war's sake, Microsoft was busy declaring a truce with the open source community. Read more »
SCO of the dead
-- It lives -- struggling along with a bad limp and only one thing on its mind -- brains. Will anyone be able to stop the zombie-like progress of SCO? Read more »
Dr. Evil couldn't have said it better
-- When the price for a company is $1 billion, it's hard not to recall Austin Powers' Dr Evil. Read more »
Others (3)
Mini-Confs Day 2
Mini-conferences continued to be the order of the day at Linux Conference Australia 2007. Read more »
Mini-Confs Day 1
Linux.conf.au kicked off today with a series of mini conferences covering a range of topics Read more »
Filter Tags
News and features
- Latest
- Popular
- Features
- Most Discussed
-
Share a keyboard and mouse with Synergy
Even in the era of virtualization, many IT pros (including myself) have a small army of computers sitting on, under, and around their desks. Read more »
-
Android devs less than gruntled
Yet more discouraging news on the Android front. Having hacked off its developer community by releasing updated SDKs to just a small group of chosen devs, Google has now given the brush-off to a petition that called for more to be given to the wider community. Read more »
-
As a developer there will be a time when you ship a bug -- be it a stub that you left in, or a flaming, crashtastic segfault. The next time this happens and your bosses come baying for blood, point them in the direction of VMware, who this week gave the developer world a great example of how to ship a showstopper bug. Read more »
-
Ivar Jacobson, Bill Gates and the weekly poultry -- Club Builder
2008/08/20 16:36:22
-
Wii remote creates $50 digital whiteboard: IDF
2008/08/20 10:42:43
-
2008/08/18 13:05:17
What's on?
-
Club Builder: Captain Obvious vs the Crackpots
In the case of the bleeding obvious, IBM says open source needs good designers; a claim is made that China can activate your phone to snoop on you; and we take a look at the Defcon conference.
