Artículos IT, información y publicaciones sobre Bases de datos

Últimas publicaciones destacadas en Dataprix sobre esta temática TIC

How to use Openquery to make a join between a SSAS cube and a table from any other database

 

Connetion to SSAS instanceImagine you need a report with data from an OLAP sales cube, and have to include data from a table of the relational data source, or from an external database.

With a linked server you can construct a MDX query in the SQLServer instance where you have the cube, joining with an external database to complete the data with information from tables of the relational database..

How to recover the password of the user sa on SQL Server

 

Init params con SQL Server Configuration ManagerWith SQL Server, when we forget or we lose the password of the DBA user 'sa', and we are the administrators of the database, we have a little problem.

It's easy to forget this password because probably we have our own user administrator and don't use to log in with the sa account. We also could have inherited the administration of a SQL Server database, with any documentation about the sa account or we coul'd have installed a database and deleted the login with admin privileges without knowing the password of the sa user.

For all this situations there is a better solution than reinstalling the database..

How to change in SQL Server the key column to an identity by using T-SQL and OVER clause

 

Relational model with invoices master-detailIf you have to change the type of a key column on SQL Server, and the new column type has to be integer, and even identity, you can do it by using some criteria in order to get the rows ordered (PK= index clustered= order by in physical disk by this column)..

We will change the type of the PK column of a table in a sample with 2 typical invoice tables master-detail where the key columns are nchar. 'invheader.invoiceid' is the primary key of the master table and 'invlines.lineid' is the primary key of the detail table..

 

How to access from SQL Server to MySQL databases

 

Connect SQL Server to MySQL with linked serverWe could need to access to MySQL from SQL Server.

An easy way to do it is creating a linked server that uses an ODBC connection..

 

Avoiding errors concatenating fields with numerical values in SQL Server

 

concatenate stringsThe operator to concatenate in SQL Server is '+', but this operator is also used to add values.

 

Being the same operator for both, the query analyzer makes a concatenation or a sum based on the type of data fields being treated. If the fields are of 'string' type, the operator concatenate, and if it has numeric fields, two integers, for example, it add the two values.

Tips for UPSERT or update using insert in SQL Server

 

Merge SQL

In many cases, especially in ETL processes or data loading to a data warehouse, for example, we would rather use a single sentence or the checking of the existence of a register and its updating. If register doesn't exist we would want to insert it. This combination has been nicknamed UPSERT, although in SQL there is a specific statement to make it, which is MERGE.

How to do an update from a select with summarized registers in SQLServer

 

Update from summarized registerA very powerful way to do a table's update in a SQL Server database is to link it with another table with a join, and updating the fields of everyone of its registers using the field's values of the registers linked with the another one. This technique had been discussed in the forum post Update with join or update from select in SQL Server..

Oracle Announces the Certification of the Oracle Database on Oracle Linux 6 and Red Hat Enterprise Linux 6

Oracle Database 11g Release 2 (R2) and Oracle Fusion Middleware 11g Release 1 (R1) will be available on Red Hat Enterprise Linux 6 (RHEL6) and Oracle Linux 6 with the Red Hat Compatible Kernel in 90 days.

Oracle offers direct Linux support to customers running RHEL6, Oracle Linux 6, or a combination of both maintaining compatibility with Red Hat Linux.

Effective immediately, Oracle will provide its Red Hat compatible Linux binaries, updates and errata for free http://public-yum.oracle.com. Terms, conditions and restrictions apply.

The Unbreakable Enterprise Kernel is Oracle’s fast, modern, reliable Linux kernel that is optimized for Oracle software and hardware.

Oracle Linux 6 with the Unbreakable Enterprise Kernel is optimized for running Oracle products.

IBM Addresses Next Shift in Enterprise Cloud Adoption

Study finds nearly 90 percent of businesses are moving beyond virtualization 
New IBM SmartCloud software advances visibility, control and automation across cloud and traditional environments 
IBM extends secure cloud management to Mobile devices and physical assets

Made in IBM Labs: Holey Optochip First to Transfer One Trillion Bits of Information per Second Using the Power of Light

• Researchers invent novel technique by fabricating tiny holes in a single quarter-inch chip to boost data transfer rates 
• Until now, it was not possible to transport terabits of data for existing parallel optical communications technology 
• New prototype compactly and efficiently delivers ultra-high interconnect bandwidth to power future supercomputer and data center applications

 

IBM scientists today will report on a prototype optical chipset, dubbed “Holey Optochip”, that is the first parallel optical transceiver to transfer one trillion bits – one terabit – of information per second, the equivalent of downloading 500 high definition movies. The report will be presented at the Optical Fiber Communication Conference taking place in Los Angeles.

Syndicate content