Operating systems Windows Server 2012 R2: solving .NET Framework 3.5 installation problems 28.11.2014 by Stéphane Savorgnano I faced a problem at a customer site last week when I tried to install the .NET Framework 3.5 – a prerequisite for installing SQL Server 2012 on a Windows Server 2012 R2. I opened the Server Manager and then(…)
Database management Oracle AVDF – Database Firewall Policies 27.11.2014 by Grégory Steulet The successful deployment of a Database Firewall depends on an effective policy. Oracle AVDF includes preconfigured firewall policies as described in the Firewall Policy page in the Policy tab of the Audit Vault Server console. These include policies that log(…)
Database management, Oracle Oracle 12c privilege analysis rocks 26.11.2014 by Oracle Team By Franck Pachot . 12c came with a very nice feature: privilege analysis. You don’t know which privileges are required? then just grant DBA, run your application, and check which minimal privileges are needed. And today, I’ve discovered how(…)
Hardware & Storage WSFC : Manual or automatic failover? That is the question! 26.11.2014 by Microsoft Team During the night, you receive an alert concerning your SQL Server failover cluster or your availability groups and you’re in panic mode because the message displayed is : a failover has occured .. see the log for more details(…)
Database management SQL Server tips: Executing a query with the EXECUTE command 25.11.2014 by Stéphane Haby This short SQL Server blog post is meant to help people who have experienced the error messages 2812 and 203 with the EXECUTE command. The goal is to execute a simple query from a variable in a string(…)
Technology Survey Journées SQL Server 2014: il n’est pas trop tard pour vous inscrire 24.11.2014 by Microsoft Team Le plus grand événement français va bientôt avoir lieu (1 et 2 décembre) à Paris et il vous reste encore une semaine pour vous y inscrire! Pensez également à commander votre lunch(…)
Database management SQL Server 2014: buffer pool extension & corruption 19.11.2014 by Microsoft Team I had the opportunity to attend Paul Randal’s session on advanced data recovery techniques at the Pass Summit. During this session one attendee asked Paul if a page that has just been corrupted can remain in the buffer pool extension(…)
Database management, Oracle Oracle locks: Identifying blocking sessions 17.11.2014 by Oracle Team By Franck Pachot . When you have sessions blocked on locks, you probably have all information about the waiters (they call you and anyway their waiting session is visible in v$session our ASH). But you usually need to get(…)
Database management, Oracle 12c SQL Plan Directive: state has changed between 12.1.0.1 and 12.1.0.2 16.11.2014 by Oracle Team By Franck Pachot . SQL plan Directives have been introduced in 12c. If you have scripts that check their states (and I have that as I prefer to monitor closely the features that are new) you probably have seen(…)
Database management Oracle AVDF post-installation configuration 13.11.2014 by Grégory Steulet In one of my last blog, named: “Oracle Audit Vault and Database Firewall (AVDF) 12.1 – installation on VirtualBox” I explained how to install AVDF on VirtualBox. Since some of you asked for a blog on “How to(…)