Databases

Educating end users and upgrading internal processes can help enterprises fix data quality problems without dropping a ton of cash, analysts say.

Educating end users and upgrading internal processes can help enterprises fix data quality problems without dropping a ton of cash, analysts say.

In this second article of a two-part series on new T-SQL statements, expert Serdar Yegulalp reviews command changes to sequencing, date values and more.

Each release of SQL Server brings changes to Transact SQL. In this tip, expert Serdar Yegulalp gives a walkthrough of tweaks like WITH RESULT SETS for renaming columns and THROW for catching errors.

Enterprise information management programs should be molded around clear business objectives, says a senior information architect at Bank of America.

Enterprise information management programs should be molded around clear business objectives, says a senior information architect at Bank of America.

Demystify the SQL Server Reporting Services (SSRS) configuration process. Get an overview of this tool and guidelines for how to set up each screen in SSRS from industry professional Roman Rehak.

You probably think you?re ready to upgrade to the new release, but you might not be as prepared as you think. Before you upgrade, there are some tools to become familiar with, says Bob Sheldon.

"Big data" technologies took a verbal shellacking from consultant and well-known Twitterer Karen Lopez in an Enterprise Data World conference session.

"Big data" technologies took a verbal shellacking from consultant and well-known Twitterer Karen Lopez in an Enterprise Data World conference session.

The latest version of IBM's flagship DB2 database offers several features designed to coax Oracle customers out of their software comfort zones.

After years of telling SQL Server users to avoid ODBC in favor of OLE DB, Microsoft has suddenly reversed its position and advised going back to ODBC. Why? And what should you do about it?

With SQL Server 2012, Microsoft has gone whole-hog SQL Server, with great PowerShell capabilities. But what?s the best way for a DBA to manage them? Read this tip from Don Jones to find out.

Performance and support top the lists of pros for going to SQL Server 2012. But application compatibility and ?the unknown? might keep you away for now.

Performance and support top the lists of pros for going to SQL Server 2012. But application compatibility and ?the unknown? might keep you away for now.

One of the strongest versions Microsoft has put out in years, SQL Server 2012 first needs to accomplish a monumental task -- overcome database inertia, industry watchers say.

One of the strongest versions Microsoft has put out in years, SQL Server 2012 first needs to accomplish a monumental task -- overcome database inertia, industry watchers say.

SQL Azure Federations can help manage massive amounts of data, says Roger Jennings. In Part 2 of this two-part series, read on for instructions on splitting the federation root table.

SQL Server 2012 is here, and the Apache Hadoop integration is making the biggest wave, according to some users.

SQL Server 2012 is here, and the Apache Hadoop integration is making the biggest wave, according to some users.

Worried about mishaps during your next SQL Server upgrade? What if you could perform an upgrade that is virtually risk free? It is possible, database architect Roman Rehak writes.

Can SQL Azure help you manage ?big data?? SQL Azure Federations enhances traditional partitioning, says Roger Jennings. Part 1 of this two-part series looks at using T-SQL to make federated tables.

Can SQL Azure help you manage ?big data?? SQL Azure Federations enhances traditional partitioning, says Roger Jennings. Part 1 of this two-part series looks at using T-SQL to make federated tables.

SQL Server expert Denny Cherry argues that SQL Server is better than Oracle Database because it is cheaper, simpler and has a better supportive community.

SQL Server expert Denny Cherry argues that SQL Server is better than Oracle Database because it is cheaper, simpler and has a better supportive community.

SQL Server virtualization may seem like a magic bullet, but there a few scenarios that might cause businesses to reconsider.

SQL Server virtualization may seem like a magic bullet, but there a few scenarios that might cause businesses to reconsider.

Backup compression is well known to carry the benefit of cost savings to SQL Server shops, but organizations using SQL Server data warehouses may have a few more variables to consider.

Reduced SQL Azure pricing, an upgraded management portal, increased database size and the SQL Azure Federations Data Migration Wizard mean multi-tenant and ?big data? projects are big possibilities.

Database Object Naming Conventions Yesterday I tossed out the question regarding the relevance of naming conventions for hardware and software services. Today I’d like to share some insights others have shared regarding naming conventions for database objects as well. Jim writes: I thin...(more)

(Davin Martyn) Ajax (Asynchronous JavaScript and XML) is a new web development technique for interactive websites. With AJAX help we can develop web applications and retrieve small amounts of data from a web server. AJAX consists of a different type of technology.

(Jovan Popovic) The jQuery DataTables plug-in is an excellent client-side component that can be used to create rich-functional tables in the web browser. This plug-in adds lot of functionalities to the plain HTML tables that are placed in web pages such as filtering, paging, sorting, changing page length, etc.

(Andy Brown) Visual Basic is a better programming language than Visual C#. Who says so? This article! Here are 10 reasons why you should always choose VB over C#.

(Susan Visser) After a long delay, I can finally announce that this long awaited book is about to publish and you�ll be able to buy it in time for the IDUG conference. The publisher has provided a 10% discount on all pre-orders. If you�re attending IDUG Denver this year, make sure you take the pre-conference certification class that Susan Lawson is teaching on May 14.

(Keith Wood) In this post, I thought I'd look at a complete server-side and client-side solution for validating credit card numbers using the LUHN algorithm for both ASP.NET Web Forms and MVC. The core code uses some nice LINQ that I have previously blogged about, but thought it was worth providing a complete example to demonstrate how to leverage the validation infrastructure in the various ASP.NET technologies.

(Michael K. Campbell) Previously we looked at how to set up alerts for cases where SQL Server encounters issues with the storage subsystem. Setting those up is a key component to staying alerted to when problems happen � but another great mechanism for detecting corruption early is to set up regular checks for corruption.

(Karen Reliford) After nearly a year's hiatus from writing for Database Journal, I'm very glad to be back, and to finally be finishing the second part of my article on my favorite new features in Oracle 11g Data Guard, their primary product for protecting databases and an integral part of many Disaster Recovery plans.

(Petros Venetis, Alon Halevy, Jayant Madhavan, Marius Pasca, Warren Shen, Fei Wu, Gengxin Miao and Chung Wu) The Web offers a corpus of over 100 million tables, but the meaning of each table is rarely explicit from the table itself. Header rows exist in few cases and even when they do, the attribute names are typically useless.

(Pinal Dave) Recently I was reading excellent blog post by Lenni Lobel on Spatial Database. He has written very interesting function ShortestLineTo in Spatial Data Classes. I really loved this new feature of the finding shortest distance between two shapes in SQL Server.

(Thomas LaRock) Yesterday we talked about the user information you can get from SQL Azure. Today we are going to focus on the details you can gather about the databases for your SQL Azure instance. You can run the following code to view details about the databases for your SQL Azure server instance:

(Guenadi Jilevski) In the article you will have a look at the steps related to extending an existing Oracle cluster by adding a node to the cluster and the opposite steps to remove a node from the cluster. Oracle 11.2.0.3 is used for verifying the reconfiguration steps in the article.

(Marc Reed) This document discusses a number of issues that advanced report authors may encounter when they create reports that generate a stitch query (queries that include facts from multiple fact tables).

(Robert Catterall) Sometimes an APAR (in IBM-ese, a description of a software functional enhancement or defect correction effected via application of a fix) is not what it -- at first -- seems.

(Sakthivel Chidambaram) Sharing one of the interesting scenario I worked today.

(Scott Wesley) For anyone that may have missed it, Oracle announced their current statement of direction for Oracle Application Development Tools - Statement of Direction: Oracle Forms, Oracle Reports and Oracle Designer

(Hans Worst) Just by extending the XSL of the Refinement Panel and adding a little javascript it is possible to select multiple Refiners via the UI:

(asim9ice) Most of the developers always find solutions for integrations and helping techniques, so in this post we compile ultimate useful xml tutorils, below xml tutorials will help developers for import data using xml techniques anywhere in web development or web galleries, we have some examples to guide you where you can or you should use this useful technique, nowadays most of the corporate companies and portfolio websites generate a image gallery for present their projects and photos using backend web language PHP, XML is compatible solution for this as well.

Cloud-based business intelligence has its attractions, especially for SMBs having a hard time supporting any BI in-house. But don?t forget to ask some crucial questions.

Are Naming Conventions Still Relevant? I recall a discussion Steve introduced a couple years ago about naming conventions. In it we were discussing the value of how things were named that provided enterprise services. The discussion was targeted primarily at SQL Server. There was a lot of fe...(more)

Error Handling Final Comments Today I’m Wrapping up this series on error handling with some interesting insights from two of our readers. One is from an SQL Server perspective, and the other reflects code in all layers. Fraser Responds to Error Handling flow with the following thoughts: ...(more)

Error Handling – When and Where At the root of error handling is the need to identify the severity of the problem. If the problem is significant, then it is important to notify someone when the error occurred. These requirements determine the technique necessary to handle an error. When ...(more)

With SQL Server 2012 released in a ?virtual launch? this month, Microsoft data platform specialist Mark Kromer tells us what his favorite features of the new release are.

Database Error Handling SQL Server had a very simplistic error handling capability before SQL Server 2005 was released. The Global System Variable @@ERROR contained the value of any error occurring from the last statement. If no error it contained the value zero. For granular error trapping you...(more)

SQL Server 2012 pricing includes some significant adjustments, including a reduction in the number of editions and the change from processor- to core-based licensing.

Industry watchers weigh in on Microsoft SQL Server 2012, which offers added business intelligence capabilities for end users and IT. Features include Power View and master data management.

The Microsoft BI stack gains a few additions with release of SQL Server 2012, with new Excel-based Power View for business users and old standbys like Reporting Services.

A successful SQL Azure migration means picking the right migration tool and loading data into SQL Azure properly.

Some of last year's biggest information management mess-ups could have been avoided through closer adherence to best practices, according to experts.

In this interview, Microsoft executive Mark Kromer discusses newly unveiled Microsoft ?big data? features and products announced at last month?s PASS Summit 2011.

Microsoft?s SQL Server-Hadoop connectors bridge the structured, relational database world with the unstructured universe of big data. For DBAs, there?s a whole lot to get used to.

In this Q&A, Microsoft?s Mark Kromer discusses the company?s preview of SQL Server connectors for Hadoop and the shift to the Open Database Connectivity interface for data access.

SQL Server Developer Tools, also known as Project Juneau, made its debut in this summer?s Denali preview. Read up on five SSDT features.