(Richard Carr) There are many reasons for generating random numbers in Transact-SQL (T-SQL) queries but the standard randomisation function will not generate a new value for each row. However, there is a workaround for this problem.
Author: SSWUG Research
Enabling MySQL Multi-Source Replication Workflows with GTIDs
(Luís Soares) The goal of this post is twofold: (i) to show the power of GTIDs and MySQL 5.6 replication infrastructure in general; and (ii) show MySQL users a way to hack multi-source replication rather painlessly and rather quickly on top of MySQL 5.6 when using the new MySQL 5.6 replication featu
DB2 LUW To Get MongoDB Hooks–Will DB2/400 Be Next?
(Alex Woodie) IBM and 10gen, the company behind the open-source MongoDB NoSQL database, announced a partnership last week that will lead to closer integration between MongoDB and DB2 for Linux, Unix, and Windows (LUW), as well as WebSphere middleware.
SSWUGtv News: Anonymous Social Networks, creepy Facebook apps, and an 84in touchscreen from Windows!
Video Programming for IT Professionals
Updating the TCP Port on a SQL Server Cluster Node
(Thomas LeBlanc) When installing 2 SQL Server instances on a Windows Cluster, the installation program requires a Named Instance during the installation of the second node and a dynamic TCP port is created. Our failover procedure for SQL Server instances in a cluster has a DNS name mapped in ActiveD
How to Bind Derived Type in MVC View
(Abhay@Accenture) Normally when we bind the Derived type (or derived type collection) to the MVC View, it always return the actual base type on controller, because our Model (business or domain entity) always has the BaseType. To persist the derived type (during postbacks), we have to create our own
Using Hosting Etiquette to Close the Deal
You’re hosting your boss or a client at a business lunch – what can you does to really make a good impression and seal the deal? Hosting Etiquette is same in most cases. Beyond the regular things you might do, review the following and see what you think:
Synchronize data with control signals in the InfoSphere Streams Time Series Toolkit
(Bharath Kumar Devaraju and Dattaram Rao) InfoSphere Streams is the real-time component of the IBM big data platform. It provides the platform and toolkits for building real-time analytical solutions. The Time Series Toolkit included with Streams includes operators for preprocessing, analyzing, and
Experimenting With The Amazon Simple Storage Service (S3) API Using ColdFusion
(Ben Nadel) Before I say anything, I should probably mention that as of ColdFusion 9.0.1, ColdFusion has had native file-support for Amazon S3 using the “s3://” protocol. That said, I wanted to try experimenting with the Amazon S3 REST API using ColdFusion’s CFHttp functionality. I know that I’m lik
Painless management of a logging table in SQL Server
(Hugo Kornelis) Tables that log a record of what happens in an application can get very large, easpecially if they’re growing by half a billion rows a day. You’ll very soon need to devise a scheduled routine to remove old records, but the DELETE statement just isn’t a realistic option with that vol