scandalz.net
 
 
 
BETA (Google AJAX Search)

Databases

This is the template.

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

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Configuring SSRS the easy way

by Roman Rehak, Contributor(# at 09:33 AM, 05/09/2012

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

ODBC drivers replacing OLE DB? Say what?

by Roman Rehak, Contributor(# at 12:03 PM, 04/23/2012

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?

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Big data a big deal for SQL Server 2012, users say

by Alan Earls(# at 09:49 AM, 04/11/2012

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

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Big data a big deal for SQL Server 2012, users say

by Alan Earls(# at 09:49 AM, 04/11/2012

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

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

No-risk SQL Server upgrade for SSRS no problem

by Roman Rehak, Contributor(# at 13:05 PM, 04/10/2012

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Oracle vs. SQL Server face-off: Microsoft SQL cheaper, simpler than Oracle DB

by Denny Cherry, Contributor(# at 11:33 AM, 04/04/2012

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

Oracle vs. SQL Server face-off: Microsoft SQL cheaper, simpler than Oracle DB

by Denny Cherry, Contributor(# at 11:33 AM, 04/04/2012

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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.

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google

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

Add to digg Add to StumbleUpon Add to del.icio.us Add to Google


Select a random row with MySQL:

SELECT column FROM table  ORDER BY RAND()  LIMIT 1  

Select a random row with PostgreSQL:

SELECT column FROM table  ORDER BY RANDOM()  LIMIT 1  

Select a random row with Microsoft SQL Server:

SELECT TOP 1 column FROM table  ORDER BY NEWID()  

Select a random row with IBM DB2

SELECT column FROM table  ORDER BY RAND()  FETCH FIRST 1 ROWS ONLY  
2008 scandalz.net
I'll rob that rich person and give it to some poor deserving slob. That will *prove* I'm Robin Hood. -- Daffy Duck, "Robin Hood Daffy", [1958, Chuck Jones]
CountryUS
IP Address38.107.179.239
User AgentCCBot/1.0 (+http://www.commoncrawl.org/bot.html)