(Ember Crooks) Just a quick tip today. I’ve been dealing quite a lot with triggers lately, and found the -td option on db2look very useful. I hadn’t had cause to use it before, but it has now become part of my default syntax. In my case, I was moving 963 triggers from a development system to product
Author: SSWUG Research
New Features in F#
(Sumit Srivastava) The F# (F Sharp) programming language is open source. It supports for loops, while loops, hash tables and object oriented programming like dot notation, object expressions and construction named arguments, and setters. It is released from Microsoft Research.
Improving SSRS Report Performance with Set-Based Operations – part 1
(yxjin) Ax reports were migrated to Microsoft SSRS in Ax2012, mostly in the form of Report Data Provider classes (RDP). We want to share with our customers and ISVs, through this series of blogs, with some best practices to improve SSRS report performance.
12c – parallel_degree_level (control for auto DOP)
(Kerry Osborne) I heard JP Dijcks speak at RMOUG in 2012 about a new parameter that would show up in 12c called parallel_degree_level. It’s basically a knob that you can turn to dial up (or down) the calculated DOP when setting parallel_degree_policy=auto.
Oracle Default Password Checker
(Neil Chandler) It’s amazing how much stuff you come across years after it was released by Oracle, like the view DBA_USERS_WITH_DEFPWD. It lists many standard or common database accounts where you still have a default password set.
Generating The Content-MD5 Checksum For The Amazon S3 REST API Using ColdFusion
(Ben Nadel) Recently, I’ve been playing around with the Amazon Simple Storage Service (S3) API. In my previous post, I was able to upload images to an S3 storage bucket without providing any content checksum.
start_of_group
(Timur Akhmadeev) Those who visit SQL.ru often know what the title means. It’s a very simple yet powerful technique to group data which doesn’t seem appropriate for grouping at first sight.
DB2 for z/OS Data Sharing: The Evolution of a GBP Sizing Formula
(Robert Catterall) Recently I had an e-mail exchange with my friend, colleague, and fellow DB2 blogger Willie Favero, on the subject of DB2 for z/OS group buffer pool sizing. One of my messages was a little wordy (imagine that), and Willie responded with, "[This] reads like it could be your next blo
SSIS 2012 – Using PowerShell to Remotely Execute File System Packages
(Marcin Policht) In our most recent article published on this forum, we presented a PowerShell script that allows you to execute SQL Server 2012 Integration Services packages deployed by using the traditional Package Deployment Model. The approach we have described can be applied to packages stored
Converting LOB data to SQL 2012 FileTables
(John Pertell) I’ve been reviewing my notes on FileTables lately. If you’re unfamiliar with FileTables, introduced in SQL Server 2012, you can read up on them here. But briefly they are an update to FILESTREAMING that allows you to store large objects in a hierarchical structure in a database table,