(Troy Coleman) I’ve written quite a bit about both IBM DB2 for z/OS manuals and IBM DB2 Redbooks. I generally use the manuals to educate myself about DB2 for z/OS features. When I’m looking for more in-depth details on different areas of practice within DB2, I often turn to Redbooks.
Other News
Materialize
(Dom Brooks) Summary – Note the recursive SQL, the association of an in-memory temporary table with a child cursor, and possible side-effects for distributed transactions.
Getting the Most Out of Enterprise Manager and Notifications
(Kellyn Pot’Vin) I ran out of time before I was able to provide an adequate white paper this year for my EM12c presentation, but there was some valuable info in what I had started, so thought I’d turn it into a mulit-part blog post…
Script Component Debugging in SSIS 2012
(Carla Sabotta) In SQL Server 2012, you can now debug the Script component by setting breakpoints and running the package in SQL Server Data Tools (replaces BIDS) .
DB2 SET CURRENT SCHEMA
(Jack Vamvas) Within a database multiple SCHEMAS can exist. If a table or view exists in a schema different from the default SCHEMA of the logon and the reference to the object does not include a qualified name , then the object can’t be found.
SQL Server – Custom Database Role
(Paresh Prajapati) Recently while working with database security, I learned database roles as how the each role used. Apart from the server level roles if we need to require to assign access/rights to particular databases level then we need to go through database level roles.
Managing and scheduling database jobs with the Data Studio Web Console
(Dimple Bhatia, Hassi Norlen and Quddus Chong) As the number of databases increase in many organizations, many DBAs are facing a major challenge in automating and scheduling their database operations. The new job management capability in IBM® Data Studio provide DBAs with a simple and flexible way t
How to Handle Null Values in MYSQL Server
(Arjun Panwar) The concept of the null value is a common source of problems for an outsider; null is the same thing as an empty string in MySQL server does nothing to disallow null as the value of a distribute expression, whether it is a column value or the value of a user supplied expression. Null
SQL Server Data Types Impact Performance
SolidQ Training in NYC and Las Vegas! In partnership with SolidQ, SSWUG announces two new seminars in March of this year! March 7-8, a fast-paced, in-person seminar on configuring and securing SharePoint 2010 and business intelligence services will be taught by BI expert Carl Rabeler in Las Vegas, NV. March 13-14, practical SSRS design techniques based on industry best practices […]
SQL SMO Virtual Device
New, Online SQL Server High Availability Course Starts Tomorrow SolidQ and SSWUG.ORG unveils the first virtual class on SQL Server High Availability, providing you with the advanced knowledge and experience necessary to design, implement and administer SQL Server High Availability solutions in SQL Server 2005, 2008 or 2012. Randy Dyess, a SolidQ Mentor having a large variety of experiences dealing […]