Updated: 2010-05-31 07:23:00
Log in Database Geek Blog Database Stuff , from a Geek Home About Feeds Subscribe to Feed Twitter Weekly Updates for 2010-05-31 Posted in May 31, 2010 2:23 . amh Lewi No Comments DB Geek says : Twitter Weekly Updates for 2010-05-24 : google_ad_client pub-4372398370642959 468×60, cr http : bit.ly cjrA0b Blogged PHP for PL SQL Developers : More Include Files , Inserting Data and Must See Sites http : it.toolbox.com trd 46 2 38892 3 I've been Tweeting since July 28, 2007 1031 days How about you http : HowLongOnTwitter.com My life writ dilbertian http : bit.ly cw6qfo dtseiler dtseiler I still double space . I'm oldskool , yo . in reply to dtseiler Interesting webinar coming on June 3, Urban Myths about SQL presented by Mike Stonebraker http : bit.ly 9Os9XD What we need to do about BP's oil
Updated: 2010-05-30 07:43:32
Search Databases Home Computing Technology Databases Share Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Searching through MS Access Records Sunday May 30, 2010 In a recent forum message GBENJAMAR wrote : I am new to ms access and have been having a some challenge with getting my search record combo box to work . I followed the instruction of the wizard in creating this box to search my Name field and pull out the record but I can't seem to get it to put out the required record . Please please please is there a code I can use for this Can you help Interested in solutions to the same problem Visit the About
Updated: 2010-05-28 14:56:06
, J ust S oftware S olutions just : thread C++0x Thread Library Call Us on 0845 053 0 350 Or email us for Custom Software Development About the Company Home Page Our Ethos Contact us Custom Software Development Website Development Free Libraries to Download Technical Writings Published Articles and Presentations Recent Blog Entries Reviews Multithreading and Concurrency C++ Web Design Software Design Database Design Subscribe to Blog Subscribe by RSS Enter your details below to receive updates by email Name : Email : We respect your email privacy Blog Archives May 2010 2 April 2010 4 March 2010 1 February 2010 3 January 2010 3 2009 25 2008 41 2007 26 2006 13 Search Enter your search terms Web this site Submit search form Photo shows Sennen Beach , which lies just 4 miles from our office in
Updated: 2010-05-27 07:23:56
Search Databases Home Computing Technology Databases Share Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS SQL Server Stored Procedures Thursday May 27, 2010 Microsoft SQL Server provides the stored procedure mechanism to simplify the database development process by grouping Transact-SQL statements into manageable blocks . Some of the core benefits of this technology include : Precompiled execution Reduced client server traffic Efficient reuse of code Programming abstraction Enhanced security control Read the full story : SQL Server Stored Procedures Comments 0 See All Posts Share Prev Comments No comments yet
Updated: 2010-05-25 07:21:56
Search Databases Home Computing Technology Databases Share Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Database Professional Development Tuesday May 25, 2010 In a recent forum message Scottees3 wrote : I am a basic MS Access user with decent VB and SQL skills as well . I am interested in moving my database skills forward but am at a bit of a loss on what all I should tackle first . Should I just work at getting better at VB or SQL or MySQL Any advice or options for moving my data management career along would be appreciated . Do you have any advice for Scottees3 Interested in the opinions of others on this
Updated: 2010-05-25 01:15:04
VoltDB is finally launching today. As is common for companies in sectors I write about, VoltDB — or just “Volt” — has discovered the virtues of embargoes that end 12:01 am. Let’s go straight to the technical highlights:
VoltDB is based on the H-Store technology, which I wrote about in February, 2009. Most of what I [...]
Updated: 2010-05-24 15:00:47
Here is something you need to be aware of when you use the EXECUTE IMMEDIATE … USING and OPEN FOR … USING statements in PL/SQL.
Let’s execute this simple anonymous PL/SQL block:
eddie@db11gr2> DECLARE
2 l_string VARCHAR2 (4000);
3 l_rc sys_refcursor;
4 BEGIN
5 [...]
Updated: 2010-05-23 07:29:51
: Search Databases Home Computing Technology Databases Share Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Microsoft SQL Azure : SQL Server in the Cloud Sunday May 23, 2010 With the release of SQL Azure , Microsoft is now offering serious database users the ability to put their databases in the cloud . SQL Azure is a relational database that supports Transact-SQL using Microsoft SQL Server Technology but allowing you to place all of the server and operating system administration tasks in the hands of Microsoft Engineers . Read the full story : Microsoft SQL Azure : SQL Server in the Cloud Comments 0 See All
Updated: 2010-05-23 02:38:51
As you might imagine, there are a lot of blog posts I’d like to write I never seem to get around to, or things I’d like to comment on that I don’t want to bother ever writing a full post about. In some cases I just tweet a comment or link and leave it at [...]
Updated: 2010-05-23 02:34:28
Back in March, Sybase was kind enough to give me permission to post a slide deck about Sybase IQ. Well, I’m finally getting around to doing so. Highlights include but are not limited to:
Slide 2 has some market success figures and so on. (>3100 copies at >1800 users, >200 sales last year)
Slides 6-11 give more [...]
Updated: 2010-05-22 02:04:24
I firmly believe that, as a community, we should look for ways to support scientific data management and related analytics. That’s why, for example, I went to XLDB3 in Lyon, France at my own expense. Eight months ago, I wrote about issues in scientific data management. Here’s some of what has transpired since then.
The main [...]
Updated: 2010-05-20 07:29:45
Search Databases Home Computing Technology Databases Share Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Forms in Microsoft Access 2007 Thursday May 20, 2010 Although Access provides a convenient spreadsheet-style datasheet view for entering data , it isn't always an appropriate tool for every data entry situation . If you're working with users you don't want to expose to the inner workings of Access , you may choose to use Access forms to create a more user-friendly experience . In this tutorial , we'll walk through the process of creating an Access form . Read the tutorial : Creating Forms in Microsoft
Updated: 2010-05-18 07:24:47
Search Databases Home Computing Technology Databases Share Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Securing an Access Database Tuesday May 18, 2010 Password protecting an Access database allows you to protect your sensitive data from prying eyes . In this tutorial , we walk you through the process of encrypting your database and protecting with a password , step by step . Read Encrypting an Access Database Comments 0 See All Posts Share Prev Comments No comments yet . Leave a Comment Leave a Comment Name Email never displayed URL Your Comment Line and paragraph breaks are automatic . Some HTML allowed :
Updated: 2010-05-17 07:23:00
DB Geek says: Twitter Weekly Updates for 2010-05-09: <!–
google_ad_client = "pub-4372398370642959";
/* 468×60, cr… http://bit.ly/cpeb6i #
Blogged "PHP for PL/SQL Developers: Finally, some real code" http://it.toolbox.com/trd/46/2/38612/3 #
Blogged "MySQL Track at ODTUG Kaleidoscope" http://it.toolbox.com/trd/46/2/38656/3 #
SAP buys Sybase for 5.8 billion http://bit.ly/chxieC #
rt @oracletechnet A full Oracle Database App Development stack in a VirtualBox appliance: Can I haz? Yes [...]
Updated: 2010-05-16 23:18:44
The Sybase IQ folks had been rather slow about briefing me, at least with respect to crunch. They finally fixed that in February. Since then, I’ve been slow about posting based on those briefings. But what with Sybase being acquired by SAP, Sybase having an analyst meeting this week, and other reasons – well, this [...]
Updated: 2010-05-16 07:14:00
Search Databases Home Computing Technology Databases Share Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Using the INSERT INTO Statement Sunday May 16, 2010 In a recent forum message VTHOME2009 wrote : I would like to use the INSERT INTO SQL statement to export data from a temporary table in Access to the destination table in Access . I do not want to type in the field names or the values in the INSERT INTO statement since the temporary tables and destination tables change as the code runs . Is there a way to write VBA code that will insert the field name and value into the INSERT INTO statement Can you help
Updated: 2010-05-15 01:58:05
There’s a point I keep making in speeches, and used to keep making in white papers, yet have almost never spelled out in this blog. Let me now (somewhat) correct the oversight.
Analytic technology isn’t only for you. It’s also for your customers, citizens, and other stakeholders.
I am not referring here to what is well understood [...]
Updated: 2010-05-14 22:14:46
My recent post about SAS’ MPP/in-database efforts was based on a discussion in a shared ride to the airport, and was correspondingly rough. SAS’ Shannon Heath was kind enough to write in with clarifications, and to allow me to post same. With permission, I’ve also made trivial grammar edits.
Regarding Netezza, SAS Scoring Accelerator for Netezza [...]<img src="http://feeds.feedburner.com/~r/MonashInformationServices/~4/cHUnd1BI2vQ" height="1" width="1"/
Updated: 2010-05-13 09:30:46
Raj Nathan of Sybase has been calling around to chat quickly about the SAP/Sybase deal and related matters. Talking with Raj didn’t change any of my initial reactions to SAP’s acquisition of Sybase. I also didn’t bother Raj with too many hard questions, as he was clearly in call-and-reassure mode, reaching out to customers and [...]
Updated: 2010-05-13 05:20:09
Search Databases Home Computing Technology Databases Share Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS PCI DSS Database Security Thursday May 13, 2010 The Payment Card Industry Data Security Standard PCI DSS sets forth the security requirements for organizations that store , process and or transmit credit or debit card transactions . These requirements stem from a series of affecting databases of consumer credit information over the past decade . What does PCI DSS mean to you as a database professional If you review the PCI DSS standard , you'll find seventeen pages packed with detailed requirements for
Updated: 2010-05-12 22:31:40
For as long as we’ve had the concept of database management, there’s been a debate as to whether it is realistic for large enterprises to have a single Grand Unified Enterprise Storehouse Of All Information, or whether database proliferation actually makes sense. This argument has been particularly intense in the area of data warehouse/data marts. [...]
Updated: 2010-05-12 17:48:37
SAP is acquiring Sybase. On the conference call SAP said Sybase would be run as a separate division of SAP (no surprise). Most of the focus was on Sybase’s mobile technology, which is forecast at >$400 million in 2010 revenues (which would be 30%ish of the total). My quick reactions include:
Sybase’s main businesses are:
Classic [...]
Updated: 2010-05-11 06:44:44
Search Databases Home Computing Technology Databases Share Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Relationships in Access 2007 Tuesday May 11, 2010 The true power of relational databases lies in their ability to track relationships hence the name between data elements . However , many database users don't understand how to take advantage of this functionality and simply use Access as an advanced spreadsheet . In this tutorial , we'll walk through the process of creating a relationship between two tables in an Access database . Read the full tutorial : Creating Relationships in Access 2007 Comments 0
Updated: 2010-05-10 01:23:00
DB Geek says: Twitter Weekly Updates for 2010-05-02: <!–
google_ad_client = "pub-4372398370642959";
/* 468×60, cr… http://bit.ly/buvM60 #
Blogged "PHP for PL/SQL Developers: A First Look" http://it.toolbox.com/trd/46/2/38432/3 #
"PHP for PL/SQL Developers: A First Look" http://it.toolbox.com/trd/73/2/38432/3/twitter #
Finally tossed the dlink 615. Fast router but the dropped connections were driving me nuts. Don't buy it. #
Blogged "ProjectManager.com – A Review" http://it.toolbox.com/trd/46/2/38443/3 [...]
Updated: 2010-05-09 19:40:16
Search Databases Home Computing Technology Databases Share Databases Database Basics Learning SQL Using Databases Free Databases Newsletter Sign Up Discuss in my Forum Mike's Databases Blog By Mike Chapple About.com Guide to Databases My Bio My Blog My Forum Add to : iGoogle My Yahoo RSS Form Doesn't Exist in Microsoft Access Sunday May 9, 2010 In a recent forum message mbocho wrote : I created a new form in design view . Access gave it the name Form1' . Then I added a control in the form a combo box gave it a name then went to properties and attached an event procedure to the After Update Shortly after that , I went back to access and named the form frmGraph . Then added another control . When I went back to VBA , gave me an error message saying form1 does not exist . Form1 is visible
Updated: 2010-05-06 16:08:57
: , J ust S oftware S olutions just : thread C++0x Thread Library Call Us on 0845 053 0 350 Or email us for Custom Software Development About the Company Home Page Our Ethos Contact us Custom Software Development Website Development Free Libraries to Download Technical Writings Published Articles and Presentations Recent Blog Entries Reviews Multithreading and Concurrency C++ Web Design Software Design Database Design Subscribe to Blog Subscribe by RSS Enter your details below to receive updates by email Name : Email : We respect your email privacy Blog Archives May 2010 1 April 2010 4 March 2010 1 February 2010 3 January 2010 3 2009 25 2008 41 2007 26 2006 13 Search Enter your search terms Web this site Submit search form Photo shows Sennen Beach , which lies just 4 miles from our office
