(Adekunle O Adio and Nicholas Geib) IBM’s Migration Toolkit (or MTK) is a free-to-use, free-support tool that helps you move off competitor databases and on to IBM data servers, both DB2® and Informix® Dynamic Server. If you’re new to MTK, check out these earlier articles.
Other News
What Data is in SQL Server’s Memory?
(Bill Graziano) SQL Server memory is primarily used to store data (buffer) and query plans (cache). In this article I’ll show how much memory is allocated to the data buffer (or RAM). I’ll explain how to determine what tables and indexes are in the buffer memory of your server.
Round and truncate dates in Oracle
(Bob Watkins) We usually think of rounding as applying only to numeric values: If the digit to the right of where you want to round is 0-4, round down; if itfs 5-9, round up. In Oracle, the ROUND function is used for this: The expression ROUND(12.34, 1) evaluates to 12.3, and the expression ROUND(1
SQL Server Truncation Attacks
(Ronald van den Heetkamp) This article deals with a SQL injection attack that isn’t very well known, it is called a truncation attack. The idea is simple: a programmer develops a stored procedure and declares fixed field values. He could use a T-SQL function like: QUOTENAME or REPLACE to delimit or
Oracle and Regular Expressions
(James F. Koopmann) Unix comes to Oracle in the form of regular expressions to increase the power of searching.
Oracle 11G: describing a refcursor
(Anton Scheffer) In Oracle 11G the supplied package DBMS_SQL is extended with two new procedures: to_cursor_number, which transfers a refcursor to a “dbms_sql cursor” to_refcursor, which transfers a “dbms_sql cursor” to a refcursor
XML output from MySql
(Erik Wetterberg) Many times you need to produce XML output from your MySql database. MySql has no built-in support for creating XML in it’s SQL implementation but you can easily add support using the stored function feature.
Day 30 as DBA, Real DBAs and More
Day 30 as DBA This follow-on to the Day 1 as DBA show will go into the things you can do now that you’re semi-established in your routines. Daily maintenance, auditing, security checks, best practices and more. There is a lot to consider and think about when you’re putting a good foundation in place for your systems, we’ll cover check […]
Airlines, Baggage and SQL Server Data Responsibilities
Have You Seen the Special Edition SelectViews Shows? Security, SSIS, Reporting Services… all available now – watch here – and a new show will post Friday this week as well. Looking for Free SQL Server Tools? If you’re looking to get a leg up on backup, SQL Server permissions or even SQL Server monitoring, and think a great free tool […]
Building DB2 Stored Procedure Using WSAD V5
(Bibhas Bhattacharya) Stored procedures are generally used to: –Build a library of common and non-trivial queries in a central location. –Locate read/write intensive queries inside the database server for maximum performance.