DBThings.com

Cartesian Products usually don't provide useful information and often result in mistakes that can hurt your database developer career. Learn to spot Cartesian Joins and banish them from your SELECT queries forever.

The questions you may wish to ask or that will be asked during a SQL Server Developer interview will vary. Deanna Dicken shares the top 9 interview questions she asks when interviewing a potential SQL Server developer.

Learn how to consume and make use of the ADO.NET Data Service in a .NET Framework Client Application. This article demonstrates the process by creating a simple web application that uses an existing ADO.NET Data Service.

Arshad Ali explores Proactive Caching, available in SQL Server Analysis Services 2005 and later versions. Proactive Caching helps DBAs to better control the cube data automatic refresh frequency. Proactive Caching offers near real time data for reports, while at same time providing a query performance similar to MOLAP storage mode.

Table partitioning is an option available to DBAs that can help them manage key database performance areas including i/o balancing, contention reduction, SQL statement performance improvements and even data availability. Oracle Database 11g adds some very powerful new table partitioning methods that can be implemented to help to achieve some of these goals.

It would be smart to brush up on your SQL when interviewing for a PL/SQL developer position. James Koopmann shares five questions that he has been asked when interviewing for both a DBA position and a PL/SQL developer position.

There is a growing trend to access applications that are not just confined to just the PC but also extend to the other usually connected devices such as mobile phones and Point-of-Sale terminals. Keeping data synchronized across different platforms is a difficult problem to solve and the Microsoft Sync Framework is Microsoft's solution to the problem.

Back in June we evaluated four great Access 2010 books that had just been released. There's now another volume available written especially for programmers. Danny Lesandrini peeks inside to see if this book lives up to its name.

DBAs often have a need to identify why a problem has occurred, or is occurring in their SQL Server database. This article covers some of the tools you can use to look for clues, and the steps you might go through to help troubleshoot a SQL Server problem.

CouchDB is a great example of forward-thinking technology that's worth a look even if you're not currently in need of a database solution. This article introduces you to CouchDB, showing you how to get started using this fascinating solution and even integrate it into your PHP website.

Despite the traditional news dead zone as many people take a well-earned summer holiday, this month has seen a couple of interesting announcements from IBM, which will impact many of us over the next year or two.

Protecting database information from threats and vulnerabilities is vital for any organization. This article discusses 10 new security features introduced in SQL server 2008 that facilitate effective management of the database by using server surface area configuration (policy-based management configuration), full database encryption (TDE), enhanced auditing features and more.

The SELECT statement is without question the most complex amongst MySQL's data manipulation statements. This article covers the syntax of the SELECT statement, exploring its many optional clauses.

Are you just getting used to working in Microsoft Access 2010? Danny Lesandrini shares some tips on how to work around the annoyance factor of the new format and increase your productivity.

In the world of Business Intelligence, the day has arrived. Oracle recently announced the release of Oracle Business Intelligence 11g, and the goods are now available. Steve Callan provides a history, tracing the software back to its origins, and comparing 10g with the 11g version.

No programming skills? No problem. Microsoft Visual Studio LightSwitch is all about building data-centric applications and all of the plumbing necessary to make the database connections is done for you behind the scenes. Read along as we look at what this tool can do for you.

Microsoft Access 2010 has a collection of wizards to lead you step-by-step through each process involved in developing and using a production-grade database application. ' Exploring Relational Database Theory and Practice ' is extracted from ' Microsoft Access 2010 In Depth', published by Que.

It's important to understand how well the underlying I/O architecture is performing versus its expected I/O rates, before tuning an Oracle Database 11g Release 2 (11gR2) for optimal I/O performance. Jim Czuprynski discusses how to implement a suitable extra-database I/O performance test and then capture the actual I/O performance results.

Every day, information is delivered within a business intelligence solution to facilitate decision making specific to business functions. Having confidence that the information being generated came through a rigorous data quality program is imperative.

This article discusses Database Instant File Initialization, which instructs the OS to allocate the required disk space immediately before actually zero-ing out the content from the allocated space. This means the content of the allocated disk area remains there until SQL overwrites it, improving the performance and reducing the downtime. Read on to learn more...