(Pom Bleeksma) Have you ever wondered why it takes a century to completely refresh your materialized view? I did, so I did some testing.
Other News
That good old DB2 catalog poster
(Willie Favero) One of the very cool parts of working with DB2 for z/OS back in the 80s was hanging all of the DB2 posters on the walls of ones office. Actually, having an office with walls to hang stuff on was also pretty cool.. but I digress.
SSIS Data Source Connection Information Parameterization with Environment Variable
(Meer Al) We would like to parameterize SSIS 2012/2014 Package connection manager with the environment variables. We would like to make sure the connection parameter picks up the value from the Environment variables during runtime.
Working with Class Diagrams? Let Visual Studio 2013 do the work
(Susan Ibach) Using an agile methodology doesn’t mean you never document or design anything. The class diagram is still a great tool to help you design a new application or to visualize an existing application so you can plan a new feature.
How to Work with Variables, Data Types, and Arithmetic Expressions in the C Programming Language
(Stephen G. Kochan) The true power of programs you create is their manipulation of data. In order to truly take advantage of this power, you need to better understand the different data types you can use, as well as how to create and name variables.
Comment lines: Software solution resiliency guidelines can help prevent bad behavior
(Samir Nasser) Unit testing, system functional testing, performance testing, and the like have traditionally been the only kind of testing that is performed in some form or fashion when implementing a new or updated system. Unfortunately, often overlooked is resiliency testing.
.each() Function in jQuery and Concatinate Some Exception Within .each() Function
(Anubhav Chaudhary) In my previous article I explained how to find the click event for Static and Dynamic Elements. This article explains how to work on .each() and concatenate some exception within the .each() function.
Phantom FileTable Constraints
(John Pertell) I was writing a wrap-up post to my series on FileTables when a co-worker found something interesting. SQL will insert a phantom FileTable constraint when you use SQL Server Management Studio to create a script of a non FileTable table that has a clustered index on a field named either
Automated Source Control: A Librarian For Your Database Objects, Part 3
(Tracy McKibben) As I mentioned earlier, we use Perforce as our source control package, so all of the scripts presented here are written for Perforce. I’ll try to clearly explain, in terms of source control, the functional parts of the script, so that you can easily transfer this to your own source
Testing SQL Server Query Performance Using Different Levels of Parallelism
(Ben Snaidero) I think that my SQL Server queries would benefit by being executed with multiple parallel threads. In some cases in the past I’ve used the MAXDOP option in my T-SQL to reduce the level of parallelism, but is there a way that I can increase the number of threads that my query uses duri