(Dom Brooks) Quick overview of DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE and DBMS_SPM.LOAD_PLANS_FROM_SQLSET:
Other News
Multi-master, NoSQL and MySQL
(Mark Callaghan) The MySQL family has been innovating rapidly. New features need names and sometimes those names are confusing. Describing something as multi-master or a NoSQL solution has confused me.
Auditing DDL Changes in SQL Server databases
(Grant Fritchey) friend recently described to me how he had to give administration privileges to developers on production. I was appalled because I had lived through a similar experience at a ‘dot com’. My ‘dot com’ went even further: they gave ‘sa’ privileges to everyone in the company, including t
Searching through the SQL Server Errorlogs
(jamesask) Sorry – It’s been a while since my last post. The past few months have been very busy for me. The other day, I had a brief discussion with a colleague on ways to search through all of the error logs in SQL Server.
And then temp work files and sort work files became just one
(Willie Favero) It was way back in DB2 9 that temp work files and sort work files were combined, or converged as the Redbook explains it. It all seemed like a good idea at the time, and it probably was, but there were still a few issues with the original implementation that have just been recently
Index usage
(Geniiius) Last week I blogged about how to get help identifying possible missing indexes by using some of the DMV’s provided by SQL Server. This week I will show another one that can be used to see how often a given index has been used.
SQL SERVER – Detecting Database Case Sensitive Property using fn_helpcollations()
(Pinal Dave) In my recent Office Hours, I received a question on how to determine the case sensitivity of the database.
Use IBM Cognos tools with DB2 to develop Business Intelligence reports
(Deepak Jindal and Rachit Arora) This article describes the complete process for generating Business Intelligence reports using IBM Cognos Business Intelligence tools with an IBM DB2 database. Also, the step-by-step processes for data creation using IBM DB2, data modeling using Cognos Framework Mana
A Love/Hate Relationship with Enums
Love/Hate Relationship with Enums Enums are used frequently to enforce a data domain and establish human readable names for codes. An Enum only exists in application software. It does not exist in a database. Often we have reference tables in the database in order to translate codes created by application Enum values into human readable text. Now we have the […]
Another Attack of Colossal Stupidity
Another Attack of Colossal Stupidity Like you, I also get the daily newsletter in my Inbox. I write and submit the editorial, and SSWUG builds everything else. I saw a link yesterday for one of the most frequent searches this past month, “SPOOL OUTPUT SQL SERVER”, and decided to click on it. Lo and behold, I come across a forum […]