database

Microsoft TechEd Madrid: Optimizing T-SQL & SQL Server 2014 Futures and Features

Today, I am beginning my second TechDay by a session about Optimizing T-SQL. You need to know about this if you are using SQL Database or Microsoft SQL Server 2012. Tobias Ternström, Lead Program Manager, was the speaker of(…)

Oracle 12c now available for download on OTN and Oracle E-delivery

Finally after some months … The Oracle’s long-awaited 12c database (12.1.0.1) is now available for download on OTN and Oracle E-delivery ( http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html). Without any surprise the first platforms are Linux and Solaris! Weird, but until now(…)

Three basic points on SQL Server Best Practice

A few weeks ago, I went to the Swiss Database Days 2013 and followed the “Practical SQL Server Performance Troubleshooting” workshop. During this workshop, I have seen a different way of troubleshooting, but I was surprised to see that(…)

ORA-03113 caused by Database Vault Rule Sets

Database Vault solution allows to create rules that manage access to database. Among these rules there is what is called in Database Vault “Rule Sets”. These logic components are written as PL/SQL(…)

Stéph@TechEd 2012: Episode2 – SQL Server 2012 & Windows Server 2012

Today it’s the real beginning of the TechEd with several sessions in parallel.

Forefront Endpoint Protection (FEP) 2010 and database policies

I have seen at a customer that the SQL Server's policy doesn't follow the Microsoft's recommendations about antivirus and databases(kb 309422), such excluding *.mdf,*.ndf and *.ldf files. In addition the policy for Oracle doesn't exist in(…)

SQL Server 2012 ‘Denali’: a new panel of DMVs

Dynamic management views (DMVs) return server state information that can be used to monitor the health of a server instance, diagnose problems and tune performance.Since few months, I test the future new version SQL Server 2012 codename Denali and(…)

Changing the reference instance for SQL Server Integration Service (SSIS)

In my experience, I have seen many clients do not know how to do when they have multiple databases instances and Integration Servicet for manage the end of the instance that is the reference for Integration Services. When(…)