(Robert Catterall) Many of you have probably heard (I’ve said it a number of times in presentations myself) that starting with DB2 9 for z/OS “pure” sequential prefetch (what we just called sequential prefetch before dynamic prefetch came along) would only be used for table space scans.
Other News
SSMS – Query Designer – Ad-hoc query writing/editing made simple
(Nakul Vachhrajani) The SQL Server Management Studio is truly an Integrated Development Environment. There are innumerable utilities and tools available within SSMS which are yet to gain a footing. Today, I will present how the Query Designer can be useful to develop ad-hoc queries – without writing
Announcing common_schema: common views & routines for MySQL
(Shlomi Noach) Today I have released common_schema, a utility schema for MySQL which includes many views and functions, and is aimed to be installed on any MySQL server.
How do I migrate stored outlines to SQL Plan Management?
(Maria Colgan) Stored outlines were deprecated in Oracle Database 11g and even though we have done a number of posts about SQL Plan Management (SPM) we have never discussed the reasons why you should migrate stored outlines to SQL plan baselines and the steps necessary to do the migration. It is str
Data Recovery Advisor Feature for 11g Not Supported with 11gR2 RAC
(Ben Prusinski) Today while checking and validating our database backups for our Oracle 11gR2 RAC and R12 EBS Oracle environments, I wanted to test out the Data Recovery Advisor with 11gR2 RAC.
A follow-on to all that timeout stuff we just talked about
(Willie Favero) What follows are a few words about some of the terms used in my post yesterday (Monday, July 11, 2011) entitled “It’s time to reevaluate your DB2 for z/OS maintenance strategy”… In that post I referred to a couple of DB2 resource timeout values specified through DSNZPARMs.
What are SQL server audits – a new feature in SQL server 2008
(Harsh Chawla) In this presentation, you will learn about the complete description of the SQL audits , their benefits along with brief demos.
Secure integration of an LDAP user registry with WebSphere Lombardi Edition
(Shili Yang) This article shows how you can use an existing user registry, such as an enterprise user directory in LDAP, with WebSphere Lombardi Edition. You’ll learn how to register an LDAP provider with the Lombardi application server, manage access for the LDAP users and groups, and secure the LD
SQL Table to Managed Type Creator
(zenwalker1985) This application generates and saves assembly at run time which represents the SQL table structure passed as input. The generated assembly at run time has properties defined with set and get accessors as per the column of the DB table.
SQL Server Management Studio SQLCMD mode option
(Shawn Melton) I recall in SQL Server 2005 Management Studio (SSMS) that I could quickly go into SQLCMD mode using a button on the SQL Editor toolbar. What happened to it in SSMS after SQL Server 2005, I can’t find it?