Updated: 2011-08-30 15:30:54
Are you looking for an introduction to the Structured Query Language? About Databases offers several free resources that might help you get started on the road to learning this ...Read Full Post
Updated: 2011-08-27 07:34:35
Database Engine Tuning Advisor (DETA) allows you to optimize your SQL Server database configuration based upon the unique business requirements of your organization. It analyzes your database workload and uses ...<a href="http://clk.about.com/?zi=1/1hc&zu=http://databases.about.com/b/2011/08/27/sql-server-performance-optimization.htm"Read Full Post
Updated: 2011-08-27 05:11:46
I made a few remarks about Sybase IQ 15.3 when it became generally available in July. Now that I’ve had a current briefing, I’ll make a few more. The key enhancement in Sybase IQ 15.3 is distributed query — what others might call parallel query — aka PlexQ. A Sybase IQ query can now be [...]
Updated: 2011-08-26 03:58:22
One of the less popular category names I deal with is “Complex Event Processing (CEP)”. The word “complex” looks weird, and many are unsure about the “event processing” part as well. CEP does have one virtue as a name, however — it’s concise. The other main alternative is to base the name on “stream processing” [...]
Updated: 2011-08-24 06:33:48
Are you a database professional seeking to polish your resume in the hopes of landing a better gig? Perhaps you're just getting started in database administration and you'd like to ...Read Full Post
Updated: 2011-08-21 15:33:03
The MySQL database server is one of the most popular open source databases in the world. Although there is not yet an official package for installing it on the latest ...Read Full Post
Updated: 2011-08-21 12:54:43
I wanted to learn more about Hadoop and its futures, so I talked Friday with Arun Murthy of Hortonworks.* Most of what we talked about was: NameNode evolution, and the related issue of file-count limitations. JobTracker evolution. Arun previously addressed these issues and more in a June slide deck. *Arun has been working on Hadoop [...]
Updated: 2011-08-19 03:09:31
HP has announced that: HP is buying Autonomy. HP is pulling back from WebOS. HP may spin off its PC business altogether. On a high level, this means: HP is doubling down on enterprise IT. HP is taking a more software-centric approach to the enterprise IT business. HP is backing away from the consumer electronics [...]
Updated: 2011-08-18 06:31:06
Looking to optimize the performance of your SQL Server database? If your database contains very large tables, you may benefit from partitioning those tables onto separate filegroups. This technology, introduced in SQL Server 2005, allows you to spread data onto different physical disks, leveraging the concurrent performance of those disks to optimize query performance.
Read the full article: Partitioning a SQL Server Database Table...Read Full Post
Updated: 2011-08-16 05:30:15
Access 2010 uses the tabbed document format found in other Microsoft Office products. In some cases, you may wish to hide these tabs to change the look and feel of ...Read Full Post
Updated: 2011-08-14 14:14:04
In a recent forum message, HighTechPost asks:
I have a .bcp file containing lots of data. Now, I want a few records out of it for particular a time frame, say for 2-4 days.
How can I make a query or stored procedure? I know this can be done at the command line.
...Read Full Post
Updated: 2011-08-14 05:08:03
My Couchbase business update with Bob Wiederhold was very interesting, but it didn’t answer much about the actual Couchbase product. For that, I talked with Dustin Sallings. We jumped around a lot, and some important parts of the Couchbase product haven’t had their designs locked down yet anyway. But here’s at least a partial explanation [...]
Updated: 2011-08-14 05:02:42
I decided I needed some Couchbase drilldown, on business and technology alike, so I had solid chats with both CEO Bob Wiederhold and Chief Architect Dustin Sallings. Pretty much everything I wrote at the time Membase and CouchOne merged to form Couchbase (the company) still holds up. But I have more detail now. Context for [...]
Updated: 2011-08-11 05:27:59
Microsoft SQL Server 2008 offers administrators two choices of performing user authentication: Windows authentication mode and mixed authentication mode. Making the proper choice affects both the security and maintenance of ...Read Full Post
Updated: 2011-08-09 05:25:45
In a recent forum message, David asked:
"Does somebody know why a form or report built with Access 2007 modifies its look when you open it?
What I mean is that I ...Read Full Post
Updated: 2011-08-07 14:25:04
Are you having difficulty understanding the concept of a database relationship? In Database Relationships Explained, we explore the concept of relationships between tables, foreign keys, JOINs, and entity-relationship ...Read Full Post
