• SQL Server 2008 R2 Editions

    Updated: 2011-06-30 05:49:28
    SQL Server 2008 R2 is the latest release in Microsoft's enterprise relational database platform series. As an upgrade to the SQL Server 2008 platform, SQL Server 2008 R2 ...Read Full Post

  • Securing SQL Server Connections

    Updated: 2011-06-28 06:48:35
    Encryption helps you prevent unauthorized access to information when individuals try to bypass your database security controls. For example, someone with a computer on your network might try to use ...Read Full Post

  • What colleges should teach in analytics

    Updated: 2011-06-27 16:57:13
    Based on a Teradata press release calling attention to the small amount of explicit university instruction in business intelligence, I was asked: Does BI really need a dedicated undergrad track? What sort of BI and analytics-related skills should students look to obtain now in order to be viable in the job marketplace five years out? [...]

  • What to think about BEFORE you make a technology decision

    Updated: 2011-06-26 19:51:06
    When you are considering technology selection or strategy, there are a lot of factors that can each have bearing on the final decision — a whole lot. Below is a very partial list. In almost any IT decision, there are a number of environmental constraints that need to be acknowledged. Organizations may have standard vendors, [...]

  • MCITP in SQL Server 2008

    Updated: 2011-06-26 01:47:45
    Looking to demonstrate your SQL Server 2008 expertise to potential employers? Perhaps you'd like a credential to help you earn a promotion or pay increase at your current job? The Microsoft Certified Information Technology Professional (MCITP) program...Read Full Post

  • Oracle to announce big data accelerator that has something to do with Hadoop?

    Updated: 2011-06-24 15:30:25
    Mark Fontecchio: CEO Larry Ellison added that Oracle plans announcements around Exadata this fall, presumably at Oracle OpenWorld. It seemed like Ellison couldn’t wait to spill some of the details. He said the company plans on announcing some kind of in-memory accelerator for Exadata in the fall, as well as a big data accelerator. From [...]

  • Observations on Oracle pricing

    Updated: 2011-06-24 07:45:45
    A couple of months ago, Oracle asked me to pull some observations on pricing until after the earnings call that just occurred, and I grudgingly acquiesced. In the interim, more information on Oracle pricing has emerged (including in the comment thread to that post). The original notes are: Oracle disputes some common claims about its [...]

  • Forthcoming Oracle appliances

    Updated: 2011-06-24 07:44:56
    Edit: I checked with Oracle, and it’s indeed TimeTen that’s supposed to be the basis of this new appliance, as per a comment below. That would be less cool, alas. Oracle seems to have said on yesterday’s conference call Oracle OpenWorld (first week in October) will feature appliances based on Tangosol and Hadoop. As I [...]

  • All you need to know about the Oracle ACE program

    Updated: 2011-06-23 16:00:31
    @LydiaSmyers interviews @oracletechnet about the Oracle ACE program (via @alexgorbachev) Related articles:I am an Oracle Developer … huh! Oracle OpenWorld 2007 – Social Networking, Twittering, Flickring and Unconferencing

  • Handling Errors with TRY...CATCH

    Updated: 2011-06-23 05:06:15
    The TRY...CATCH statement in Transact-SQL allows you to detect and handle error conditions gracefully within your database applications. This statement is the cornerstone of SQL Server error handling and ...Read Full Post

  • Citrusleaf RTA

    Updated: 2011-06-23 00:20:57
    Citrusleaf has released an add-on product called Citrusleaf RTA (Real-Time Attribution). It’s to be used when: You want to update dashboards within a minute. You want to update predictive models fairly quickly (within the hour?), although it’s not clear to me how much the models are being updated or changed with that latency. The metrics [...]

  • It’s official — the grand central EDW will never happen

    Updated: 2011-06-22 02:54:46
    I pointed out last year that the grand central enterprise data warehouse couldn’t happen; the post started: An enterprise data warehouse should: Manage data to high standards of accuracy, consistency, cleanliness, clarity, and security. Manage all the data in your organization. Pick ONE. IBM’s main theme at the Enzee Universe conference has been to say [...]

  • Gathering fixed object stats may reduce recompilation time post Oracle upgrade

    Updated: 2011-06-21 16:00:03
    Mike Dietrich: In larger sized databases with many objects and components our recommendation is always to gather first fixed object stats prior to start the recompilation. Some time ago I’ve learned from to very different customer database projects that these stats will speed up the efficient job creation for recompilation. And last week I’ve got [...]

  • Using SQL in an Access Database

    Updated: 2011-06-21 06:05:30
    Did you know that you can view and edit the SQL statements that drive every Microsoft Access database query? In this article, we take a look at the process of ...Read Full Post

  • Best Practices for Oracle E-Business Suite Performance Tuning

    Updated: 2011-06-20 17:17:37
    Steven Chan: Isam Alyousfi and Lester Gutierrez are key members of our Applications Performance Group. They recently presented their popular session covering performance tuning tips for all layers of the E-Business Suite at OAUG/Collaborate earlier this year. [...] This presentation is chock full of tips, pointers, and hard-won knowledge. It represents the distillation of countless [...]

  • The Vertica story (with soundbites!)

    Updated: 2011-06-20 07:14:56
    I’ve blogged separately that: Vertica has a bunch of customers, including seven with 1 or more petabytes of data each. Vertica has progressed down the analytic platform path, with Monday’s release of Vertica 5.0. And of course you know: Vertica (the product) is columnar, MPP, and fast.* Vertica (the company) was recently acquired by HP.** [...]

  • Vertica as an analytic platform

    Updated: 2011-06-20 07:13:18
    Vertica 5.0 is coming out today, and delivering the down payment on Vertica’s analytic platform strategy. In Vertica lingo, there’s now a Vertica SDK (Software Development Kit), featuring Vertica UDT(F)s* (User-Defined Transform Functions). Vertica UDT syntax basics start: In this release, Vertica UDTFs can only be written in C++. Other UDTF languages are promised. Otherwise, [...]

  • Temporal data, time series, and imprecise predicates

    Updated: 2011-06-20 07:11:43
    I’ve been confused about temporal data management for a while, because there are several different things going on. Date arithmetic. This of course has been around for a very long — er, for a very long time. Time-series-aware compression. This has been around for quite a while too. “Time travel”/snapshotting — preserving the state of [...]

  • Columnar DBMS vendor customer metrics

    Updated: 2011-06-20 06:41:54
    Last April, I asked some columnar DBMS vendors to share customer metrics. They answered, but it took until now to iron out a couple of details. Overall, the answers are pretty impressive. Sybase said that Sybase IQ had > 2000 direct customers and >500 indirect customers (i.e., end customers of OEMs). That’s counting by customers; [...]

  • Creating SQL Server 2008 Accounts

    Updated: 2011-06-19 05:02:05
    SQL Server 2008 provides two methods for creating database user accounts - Windows authentication or SQL Server authentication. In this article, learn how to create a new account ...Read Full Post

  • Setting Up Alerts in SQL Server

    Updated: 2011-06-16 05:49:39
    SQL Server allows you to automatically notify database administrators when unusual circumstances occur. This powerful alerting mechanism enables 24-hour monitoring of your database performance without staffing a 24-hour operations center. Read ...Read Full Post

  • Simplify Code by Encapsulating Locks

    Updated: 2011-06-15 10:13:54
    , J ust S oftware S olutions Call Us on 0845 053 0 350 Or email us for Custom Software Development Buy just : thread C++0x Thread Library . Download and get started today 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 June 2011 2 May 2011 1 April 2011 1 March 2011 1 February 2011 1 January 2011 1 2010 24 2009 25 2008 41 2007 26 2006 13 Search Enter your search terms Web this site Submit search form Photo shows

  • Choosing a SQL Server 2008 R2 Edition

    Updated: 2011-06-14 05:48:57
    SQL Server 2008 R2 is the curent release in Microsoft's enterprise relational database platform series. As an upgrade to the SQL Server 2008 platform, SQL Server 2008 R2 ...Read Full Post

  • Just::Thread now supports GCC on Windows and MacOSX

    Updated: 2011-06-14 00:51:06
    : , J ust S oftware S olutions Call Us on 0845 053 0 350 Or email us for Custom Software Development Buy just : thread C++0x Thread Library . Download and get started today 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 June 2011 1 May 2011 1 April 2011 1 March 2011 1 February 2011 1 January 2011 1 2010 24 2009 25 2008 41 2007 26 2006 13 Search Enter your search terms Web this site Submit search form Photo

  • Assigning a Datatype to a Column

    Updated: 2011-06-12 19:48:23
    In a recent forum message, Raja1244 wrote: "My problem is while doing sum of two columns the value is placed at left side. While putting this column in Crystal Reports, ...Read Full Post

  • What Are Database Dependencies?

    Updated: 2011-06-09 05:34:10
    Database dependencies describe the relationships between different data elements in the same table. Examples of database dependencies include functional dependencies, trivial functional dependencies, full functional dependencies, transitive dependencies and ...Read Full Post

  • Oracle Pre-Upgrade Utility

    Updated: 2011-06-06 17:05:53
    This is a guest post by David Clement, a veteran database engineer and a friend of mine. You can find him online at davidclement.org. A handy feature that I’ve just found out about is that there is a link from Metalink document 884522.1 to the Oracle Pre-Upgrade Utility. You can get the utility without downloading [...]

Current Feed Items | Previous Months Items

May 2011 | Apr 2011 | Mar 2011 | Feb 2011 | Jan 2011 | Dec 2010