(Ember Crooks) Sometimes the things we studied in college are actually useful. As much as I hated my statistics professor, I still learned a lot that I frequently use. Maybe I don’t do many multiple regression problems these days, but I use standard deviation a lot. It is a concept that every DBA or
Author: SSWUG Research
SQL Server Reporting Services XML Data Source and Data Set
(Scott Murray) Is it possible to use XML data / files as a source for SQL Server Reporting Services (SSRS) reports? Are there any limitations to using an XML source?
Building SOAP Message Based Web Services with WCF
(Sergey Morenko) I really like WCF as technical framework, it simplifies creating communication layer, but I don’t like WCF’s design style. I think creating new method for every data transfer object is poor, so I tryed to solve this one.
Writing PostGIS raster Map Algebra Callback Functions in PL/V8
(Leo Hsu and Regina Obe) I’ve read from many that PL/V8 mathematic operations are generally faster than what you get with SQL functions and PL/pgsql functions. One area where I thought this speed would be really useful was for writing Map Algebra call-back functions.
Collect Your SQL Server Auditing and Troubleshooting Information Automatically
(Feodor Georgiev) After many years, the Default Trace still remains the simplest way of auditing SQL Server. It gives you so much useful information about significant events, when they happened and, where relevant, the login associated with the event.
Use industry templates for advanced case management, Part 2: Introducing the Auto Claims Management sample solution template for IBM Case Manager
(Jos H. Olminkhof) IBM Case Manager provides the platform and tools for business analysts to define and implement a new generation of case management solutions. To accelerate the development of solutions in particular industries, IBM Case Manager supports the notion of a solution template: a collect
Five SQL Server 2012 business intelligence features
(Robert Sheldon) SQL Server 2012 delivered some new features that enhance and extend its capabilities well beyond SQL Server 2008 and 2008 R2. This was especially true in the area of business intelligence (BI), where improvements delivered reporting and analytic capabilities more extensive than anyt
IBM Watson gets DevOps
(David Norfolk) There is something new and big happening at IBM for what it calls the Cognitive Computing Era—basically, a new ecosystem group around Watson that could build into something as big as J2EE, and make what is fundamentally ‘artificial intelligence’ applied to textual and similar non-rel
Find what databases you have quickly – #EM12c Inventory Search
(Bobby Curtis) Thought I would write a quite tip on how to find what versions of databases you have in your environment. Oracle Enterprise Manager 12c provides a quick and easy way to find this information once it is configured within your environment.
Cognitive computing can take the semantic Web to the next level
(James Kobielus) The IT industry is approaching a point where we’ll soon need to distinguish between “cognitive” and “semantic” computing. The terms are blurring into each other. Actually, the distinctions among them have never been clear. Sometimes it’s even easier to refer to them both by the even