(Mike Davis) Now in SQL 2012 we have parameters that make it easy, but configuration files are still an option and I still see a lot of my clients using them even on 2012 due to several reasons, but mostly because of the work to convert over.
Author: SSWUG Research
Tip: COLLATE for ‘Cannot resolve collation conflict’ error
(Jen McCown) Some data professionals are VERY well versed with collation, and some never ever have to touch the concept. That second group tends works in shops that leave everything on default. A huge portion of my career has been spent as a member of that “Custom collation? What custom collation?”
Where is my Availability Group?
(johnsterrett) In SQL Server 2012 we got this great new high availability feature called availability groups. With readable secondaries under the covers it can be harder to figure out the following two questions.
Recover deleted SQL Server data and tables with the help of Transaction Log and LSNs
(Manvendra Singh) My last tip was about how to find a user who ran a DROP or DELETE statement on your SQL Server objects. Now we will learn how to recover deleted SQL Server data with the help of the transaction log and the respective LSN numbers. This tip will give you step by step process to achie
XSD 1.1 Support in Liquid XML 2014
(bconlon) I’ve just got round to looking at Liquid XML 2014. I have been tasked with investigating W3C XML Schema 1.1 standard (XSD 1.1) and as if by magic Liquid Technologies have provided 1.1 support in their excellent XML Schema Editor. Here is what they say…
The ‘once and for all’ SHOW SLAVE STATUS log files & positions explained
(Shlomi Noach) True, GTID is upon us whether via MySQL 5.6 or Tungsten Replicator (and wasn’t it in Google Patches since 2009?).
Build a data mining app using Java, Weka, and the BLU Acceleration service
(Krunal Vora and Karandeep Chawla) As data scientists for the customer analytic group in our wireless service provider company, we want to leverage customer data to predict customer churn. Customer retention is a critical challenge for the telecommunications industry, where annual churn rates can be
Visual Studio Tip: Delete a Line
(Peter Vogel) I’ve written before about how to comment out code. Sometimes, however, you just want to get rid of a line altogether. The good news is that deleting a line is just a keystroke away, and you don’t have to select the whole line to delete the whole line.
Using Arrays
(Troy Coleman) Last week I discussed the new user-defined ARRAY data type in DB2 11. This is the first DB2 for z/OS release to support arrays, although DB2 for Linux, UNIX and Windows has supported arrays since DB2 V9.5 (October 2007).
Backup Compression Consideration – DB2 COMPRESS vs. GZIP
(mkrafick) We interrupt your regular programming for a quick announcement.