(Craig S. Mullins) There have been some nice data validation improvements made to the IBM DSN1COPY utility in DB2 11 for z/OS. I suppose I should first explain what the DSN1COPY utility is before I talk about how it has been improved, so…
Other News
Optimize Customer Relationships and Retention
(Manjunath B. Subramanian) Customer relationship management (CRM) initiatives continue to be a high priority for many organizations as they try to innovate and develop new ways to deliver a superior customer experience.
Tracking Progress of SQL Server Index Builds and Rebuilds
(Matan Yungman) Let’s say you build or rebuild an index in SQL Server. Your users and boss are anxious to know when the table will stop being blocked and when their precious queries will run fast. What can you tell them?
Keeping Up To Date
What is your preferred role when working with databases? Do you want to be the guru with all the different techniques for database design and optimization. Do you want to be the optimization wizard able to get the right set of indexes or optimize query performance? Do you want to be the database manager making sure people have only the […]
SSWUGtv: How do you prepare your business for the holidays?
Video Programming for IT Professionals Career management advice, coaching and much more. We discuss making the best of your professional development, provide specific tips and ideas for advancing your career and even answer questions from field.
The Importance of Consistent Compliance and Ways to Achieve it
The Importance of Consistent Compliance and Ways to achieve it Why do we require consistent compliance? It has a very simple answer – audits can occur any time and you don’t want to be blacklisted by regulators. Stringent compliance policies were brought into action in the wake of exponential fiascos that uprooted businesses and public-sector organizations. Moreover, consistent compliance is...
DB2 Basics: MONREPORT
(Ember Crooks) If you’re mourning the loss of “RESET MONITOR ALL”, there are a number of ways you can address that. Ideally, you’d use this approach:
PowerShell and Text Mining Part I: Word Counts, Positions and Libraries
(Tim Smith) We’ve been evaluating text mining and are currently considering different approaches on how we can import and analyze the SQL Server data. As an organization familiar with numerical data, we have little experience with the basics of text mining for SQL Server and are curious about some o
Saving the MessageBoxViewer output to a SQL Server database
(Agustín Mántaras) The MessageBox viewer tool allow you to save the output in a SQL Server database.
Support for debugging lambda expressions with Visual Studio 2015
(Patrick Nelson) Anyone who uses LINQ (or lambdas in general) and the debugger will quickly discover the dreaded message “Expression cannot contain lambda expressions”. Lack of lambda support has been a limitation of the Visual Studio Debugger ever since Lambdas were added to C# and Visual Basic.

