Development & Performance Dynamic filters and “kitchen sink” queries dilemma 10.02.2016 by Microsoft Team Dealing with dynamic filters is a common scenario with management software or ERP. Indeed, users should like to have the flexibility to filter and sort their business data as they want in order to be efficient. Target and operate quickly(…)
Database Administration & Monitoring, Development & Performance, Oracle Enable 10046 Tracing for a specific SQL 05.02.2016 by Clemens Bleile Available methods to enable 10046 trace are described in My Oracle Support Note 376442.1. You can enable 10046-tracing – on session level (alter session) – for other sessions (e.g. with oradebug, the package DBMS_MONITOR or DBMS_SYSTEM) What is not(…)
Development & Performance Availability groups : readable secondary replicas and impact on the storage layer 12.01.2016 by Microsoft Team Do read-only capabilities of an availability group have a performance impact for databases? The quick response is yes but let’s see why in this blog post. First of all, when we want to use our secondary replicas as read-only, we(…)
Development & Performance SQL Server Extended Event: Eine Deadlock-Event aus der “system_health” Überwachung 10.12.2015 by Stéphane Haby Wie Sie vielleicht wissen, gibt es eine Überwachung über Extended Events: system_health. Kürzlich fragt mich ein Kunde an, um ein zufälliges Deadlock-Problem zu analysieren...
Development & Performance, Oracle SQL Plan Directive: disabling usage and column groups 03.12.2015 by Oracle Team By Franck Pachot . Yesterday I came upon a comment on oracle-l while I was reading my slides for the UKOUG TECH15 SuperSunday. I've one slide and one demo about disabling SPD usage but that's not(…)
Development & Performance, Oracle Trying AppDynamix – monitoring application from user to database 23.11.2015 by Oracle Team By Franck Pachot . I like to come upon new monitoring software that help to go quickly from user response time to root cause. And I love applications that can be installed easily and at which I can give a(…)
Development & Performance Software architecture vs code representation 11.11.2015 by Middleware Team Tuesday the 10th of November I attended a public lecture at Swiss Java User Group in Zürich. Topic of the pretension was to describe and address challenges any project manager can encounter, when reflexion switches from perspective of software(…)
Development & Performance, Technology Survey SQL Server 2016: IF EXISTS is included in the DROP command 09.11.2015 by Stéphane Haby With SQL Server 2016, I’m nicely surprised by the addition of IF EXISTS directly in the T-SQL command DROP. Before this new option, all queries are written with IF EXISTS (SELECT * FROM sys….) DROP object. I have quickly tested(…)
Application integration & Middleware, Development & Performance SQL Server Collation for System Center Products 05.11.2015 by Stéphane Haby A customer asks me, what is the collation for System Center products? Do we have a general collation for all products? And what is the BP for Tempdb? And how work the licencing for SQL Server in(…)
Development & Performance, Technology Survey SQL Server 2016: JSON support updated with SQL Server 2016 CTP 3.0! 02.11.2015 by Stéphane Haby For last week, the SQL Server 2016 Community Technology Preview 3.0 has been available with a lot of enhancements on new features. All info about CTP3 are on SQL Server Blog here. I(…)