(Chris Webb) The Power BI Preview includes the ability to share Power Query queries with other people in your organisation; I was thinking about writing a blog post on this topic, but to be honest the documentation covers it so well there’s little point repeating what it says.
Author: SSWUG Research
Get The Backup History for Databases
(Richard_RP) Below is a script that I use to find the backup history for all the databases on a single instance. There is an inline ‘WHERE’ clause that is currently commented out that you can add in to filter by database name.
Introduction to SQL Server 2014 CTP1 Memory-Optimized Tables
(Greg Larsen) There are a number of new features that became available with SQL Server 2014. One of the more exciting features is the new Memory-Optimized tables. In this article I will explore how to create Memory-Optimized tables, and what I’ve found during my initial exploration of using this n
Concurrency Control in the In-Memory OLTP Engine
We believe that the In-Memory OLTP engine advances the industry state of the art with respect to concurrency control. The main reason for this advancement is due to the combination of lock free algorithms and the row-versioned architecture of the engine.
12c: PERFORMANCE ISSUE WITH IN-DATABASE ARCHIVING
(Anju Garg) In my earlier article on in-database archiving, I had demonstrated the functionality of this new feature introduced in Oracle 12c. But this feature you could also give problems with performance.
5 neat little features of the 12C database to remember
(noechri) In this post, I’d like to introduce 5 of the many new features Oracle 12C brings to us, database developer’s.
Compare Big Data Platforms vs SQL Server
(Derek Colley) SQL is derided by modern developers as ‘Scarcely Qualifies as a Language’. But just how efficient are the new wave of NoSQL languages touted by bleeding-edge skunk works? This tip is a defense of SQL and of the relational model, and argues for the efficiency and suitability of relatio
Using workload management, service discovery, and the Integration Registry in IBM Integration Bus V9
(Eugene Kharlamov, John Reeve and Sarah Styles) This article shows you how to use new service discovery and workload management features in IBM Integration Bus V9 to discover services by interrogating WebSphere MQ or a database, use the discovered service to configure integration flows, and contro
MySQL 5.7: Monitoring Replication with the Performance Schema tables
(Shivji Kumar jha) In the previous post, we had a look at the Performance Schema tables to monitor MySQL replication. We discussed why these were needed, what advantages they have to offer and what each table stands for.
SOA Web Services Automation SOAPUI
(Jagan Mohan) Design SOA web services test automation framework to support multiple operating systems and web hosts with single driver script using SOAP UI.