Insights. One level above.
We know what above looks like. Explore the expertise built inside most demanding environments.
More than 9.9 million reads in the past 2 years See what readers open most
-
Risk and Health Assessment Program for Microsoft SQL Server
I recently had the chance to go through a so called Risk and Health Assessment Program for Microsoft SQL Server (SQLRAP) at one of our clients. The SQLRAP assesses your SQL Server implementations to ensure proper productive use. It is an excellent opportunity to review the best practices and perform a validation of your client environment by a Microsoft SQL Server Engineer.…

-
Oracle Apex 4.2 now released
Oracle Apex 4.2 is now available on the Oracle Website. It is available since 12 october 2012. This new release comes with new features briefly described in this blog posting. First of all, here are the new features delivered by the Apex 4.2 release. HTML 5 and CSS 3 improvements: Relooking of all the administration workspace Html 5 charts Html…

-
SQL Server 2012: Service Pack 1 (SP1) now available
Some days ago, the 6th of November, the first Service Pack for SQL Server 2012 was made available on the Microsoft website. SQL Server 2012 Service Pack 1 includes SQL Server 2012 Cumulative Update 1 (CU1) and SQL Server 2012 Cumulative Update 2 (CU2) and therefore all hotfixes that they were included. Which issues are fixed in the SP1: There are…

-
Office 2013 and SQL Server 2012: an integrated, powerful BI solution
I have recently read that PowerPivot and Power View are natively present in Office 2013 and especially in Excel 2013. I found this fun and decided to install the preview of Office 2013!:-D First, what are PowerPivot and Power View? PowerPivot is an add-on to Excel which is used for adding and integrating large amounts of data in Excel workbooks.…

-
Overview of Microsoft Visual LightSwitch
Microsoft Visual Studio LightSwitch is a new application development tool wich allows to create fast and nice web and desktop applications. The development environment is the same as the other .NET development tools and creating a new application with LightSwitch works, at the beginning, exactly like with other .NET application: create a new project and choose your programmation’s language between…

-
Java Virtual Machine Diagnostics: Starting/stopping JVMD manager
Although the managed server on which Java Virtual Machine Diagnostics (JVMD) manager is deployed is configured to use the the Node Manager like OMS and admin server, it is not started automatically with OMS. In this post, I will describe how to start JVMD manager automatically when the physical server boots. To implement the script, several steps have to be executed: Creation…
-
SQL Server 2012: SQL Server Data Tools (SSDT) – Schema and Data Comparison
In my life prior to SQL Server, I worked with Visual Studio Team System (VSTS). The “Schema and Data Comparison” feature of SQL Server 2012 Data Tools is a direct descendant of Visual Studio for Databases Professionnals (aka Data Dude) included in VSTS. What is SQL Server Data Tools? These new tools replace BIDS (Business Intelligence Development Studio). But they…

-
Let’s work together
Ready to operate at
the next level?Tell us about your challenge. We’ll bring the depth, the expertise, and the Swiss precision.
-
Most read
More than 360,000 reads in the last 30 days
The posts our readers open most: the all-time favourites, and what is trending right now.
All-time favourites
- Automate encryption-in-transit for SQL Server 124,231 reads
- SQLNET.EXPIRE_TIME and ENABLE=BROKEN 24,760 reads
- Enabling, disabling, and validating foreign key constraints in PostgreSQL 24,132 reads
Trending, last 30 days
-
Documentum job dm_FTIndexAgentBoot does not start anymore
The Documentum job dm_FTIndexAgentBoot does not start anymore and we have the following job status: The job object indicated the job was in progress. In this blog posting, I will describe how to analyze and solve this issue. Analysis The Index Agent does not start automatically when the repository is started although the option start_index_agents = T in server.ini is…
-
“ORA-01665: control file is not a standby control file”: what can I do?
You have certainly also received this error once in you Oracle DBA career: “ORA-01665: control file is not a standby control file” while trying to create a standby database with RMAN through a full database backup. In fact, the feature itself is not very new. It exists since at least RMAN 10g, it is called the “Restore Failover”. In order…
Talk to an expert
Pick a topic and the right team replies personally within 2–3 business days.

