(Willie Favero) If you are licensed for DB2, it’s time to get your updated copy of the DB2 11 for z/OS Diagnostics Guide and Reference (LY37-3222-02). As in the past, this update is only available via a PTF.
Other News
Boosting APEX menu SQL performance
(Scott Wesley) If you’re using dynamic SQL to source your menus and you’re utilising the apex_application_pages dictionary view to build you list of menu options – I suggest you consider using Materialized Views.
View Per-Process I/O and More With VividCortex
(Baron Schwartz) What can explain mysterious slowdowns in database performance? Sometimes it’s not the database or the queries it’s running, but the non-database activity on the server. One of the most important types of activities to analyze is processes.
Pushing data to multiple WebSocket clients from a Java server
(Yakov Fain) Finished writing the WebSocket chapter for the second edition of my Java 24 Hour Trainer. In this blog I’ll show you one of the code samples from lesson 28.
SQL SERVER – Customization of New Query in SQL Server Management Studio
(Pinal Dave) Recently I was working with one of my friends who handles production server databases as a senior DBA. He told that recently one of the Jr. DBA was fired from his company because he has run a drop table command on a production server.
New Features in C# 6
(Mads Torgersen) C# 6 is the version of C# that ships with VS 2015 Preview. The philosophy behind this version is straightforward: improve simple everyday coding scenarios, without adding much conceptual baggage. The features should make code lighter without making the language heavier.
What is the best way to handle negative online customer feedback?
What is the Best Way to Handle Negative Online Customer Feedback? Hello, this is Laura Lee Rose. I am a speaker and author. I am an expert in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
The Modern Data Warehouse
(James Serra) The traditional data warehouse has served us well for many years, but new trends are causing it to break in four different ways: data growth, fast query expectations from users, non-relational/unstructured data, and cloud-born data. How can you prevent this from happening?
Materialized Views in SQL Server
(Michael J. Swart) What’s the difference between Oracle’s “materialized views” and SQL Server’s “indexed views”? They both persist the results of a query, but how are they different? Sometimes it’s difficult to tell.
ALTER COLUMN in SQL Server
(Chandrika Bandi) The ALTER COLUMN T-SQL portion of the ALTER TABLE command is used to change a named column. There is a list of scenarios where this is not possible, such as a column used in a PRIMARY KEY or FOREIGN KEY constraint.