(Peter Vogel) Auto-implemented properties let you define a property in a single line of code:
Author: SSWUG Research
The Excitement of the IDUG North American Technical Conference – 2015
(Ember Crooks) My favorite week of the year is the IDUG North American Technical Conference. It’s better than Christmas if you ask me. I get to see my DB2 family and learn all kinds of new stuff. I come away refreshed and inspired.
My 10 Minute DB2 App on Bluemix
(Henrik Loeser) I needed some fun at the end of the workday today. Why not enhance my own skills, do some "coding", and try out Node-RED on Bluemix again (I performed a "phoney" test in October already). This time, I wanted to see whether a database like DB2 or dashDB is supported as backend.
Mobile BI with SQL Server Reporting Services
(Adam Aspin) For users to get the information they need from mobile reports, we frequently have to tailor the way we design those reports to the characteristics of the target device.
SQL Server Rowversion Functions min_active_row_version vs. @@DBTS
(Robert Biddle) For data synchronization projects, using rowversion is a very effective method for detecting changes. In order to work with the rowversion properly, we would need to either use @@DBTS or the function min_active_rowversion. Understanding the differences between these values will help
Generating tSQLt tests from a dacpac
(Ed Elliott) I use SSDT and tSQLt in my work and I am always interested in productivity tools to help speed up development and make it more streamlined, if there is something that can help us develop better or faster then we should use it.
Emulating MySQL roles with the Percona PAM plugin and proxy users
(Stephane Combaudon) From time to time people wonder how to implement roles in MySQL. This can be useful for companies having to deal with many user accounts or for companies with tight security requirements (PCI or HIPAA for instance).
ADF BC Property Set to Group Attribute Hints
(Andrejus Baranovskis) There is one ADF BC component not mentioned often – Property Set. This is a bag of properties/hints, it can be applied for EO/VO attributes. Frequently used hints can be defined in Property Set once, without repeating the same for each attribute.
ALTER DATABASE BEGIN BACKUP and ALTER DATABASE END BACKUP
(Andrew Reid) I logged into an Oracle 12.1 database, checked it was in ARCHIVELOG mode then ran the ALTER DATABASE BEGIN BACKUP command. This told Oracle I was about to do a hot backup:
SQLTXPLAIN and the AWR Warehouse, Part I
(Kellyn Pot’Vin) Yeah, so I did it- I installed SQLTXPLAIN, (SQLT) on the AWR Warehouse! From previous experience with this fantastic tool, I was pretty sure I’d have some great new adventures with the AWR Warehouse data and I wanted to try and test out the AWR pieces of this tool with the Warehou