(Martin Jungfer and Siegfried Wurst) This article describes performance considerations for IBM DB2 for Linux, UNIX, and Windows stored procedure ADMIN_MOVE_TABLE in a SAP system environment. We will examine tables with the characteristics of typical SAP systems.
Author: SSWUG Research
Collecting the Information in the Default Trace
(Feodor Georgiev) The default trace is still the best way of getting important information to provide a security audit of SQL Server, since it records such information as logins, changes to users and roles, changes in object permissions, error events and changes to both database settings and sc
Report from a Cube in Reporting Services
(Mike Davis) Data warehousing has become a staple of businesses to help make business decisions. From these data warehouses you can develop an Analysis Services cube which allows for fast reporting. Creating reports in Reporting Services 2008 from a cube is very different from a normal SQL query.
Monitoring performance of SignalR Applications
(Suprotim Agarwal) We have in the past seen how to use the persistent connection framework – SignalR from the ASP.NET team. SignalR is one rare framework that actually lights your eyes up once you start getting the hang of what it can do.
XBRL Validation and Processing Tools
(Erin Cavanaugh) When we were designing RaptorXML Server, we knew from the get-go that the engine should support XML and XBRL standards. The former standard is ubiquitous and the latter will be, as well, given increasing mandates from governments worldwide as well as adoption by enterprises for anal
What A Select $watch() Teaches Me About ngModel And AngularJS
(Ben Nadel) The two-way data-binding in AngularJS is very powerful, especially when there is a direct mapping of input-data to view-model-data. But, when the data mapping requires some translation, interpretation, or validation, you need to get your hands a little dirty – you need to get more involv
Be Smart About C++11 Smart Pointers
(Brian Overland) The expression smart pointer suggests a super-intelligent data type. It sounds like these pointers might write your program for you—or maybe get up and dance. Of course, they can’t do that. Smart pointers are used for resource management, principally that of dynamically allocated me
XML Data to JSON
(Pål Thingbø) This article describes how to transfer XML data from SQL Server to a JSON object in a web browser, using the powerful Newtonsoft JSON converter. This article assumes you are familiar with basic concepts in SQL Server, VB.NET, HTML and JavaScript coding.
The handler and the validator functions of a FDW
(Par Guillaume Lelarge) I’m still working on my foreign data wrapper. Actually, I haven’t written a lot of code. Instead, I’ve been reading the code of the other foreign data wrappers and it helped me a lot to understand many things, and to see how far each went.
Oracle 12c: Database Parameters…
(Marco Gralike) For those in a desperate need to learn all 3351 database parameter variations…