(Rebecca Bond, Yuk-Kuen Henry Chan, Kevin Yeung-Kuen See and Carmen Ka Man Wong) When thinking about organizational information security, your mind might jump to the technical details such as firewalls, access control lists, certificates, auditing, encryption, and all those well-known electronic tra
Other News
MyISAM Scalability and Innodb, Falcon Benchmarks
(Vadim Tkachenko) We many times wrote about InnoDB scalability problems, this time We are faced with one for MyISAM tables. We saw that several times in synthetic benchmarks but never in production, that’s why we did not escalate MyISAM scalability question. This time working on the customer system
Oracle, MySQL and PostgreSQL feature comparison – Part 2
(Sean Hull) In the last piece of our database comparison, we hit upon various areas such as triggers, views, and stored procedures. Though the feature sets certainly differ between Oracle, Postgresql, and MySQL, most of your daily needs are met in these areas. This time around, we’ll hit upon some a
Oracle 11g Total Recall – Flashback in the hands of Database Designers and Application Developers, at last. And: the end of Journalling Tables
(Lucas Jellema) One of the new features in the Oracle 11g database is called Oracle Total Recall. This is called marketing! I have read some weblogs where people – mostly DBAs – are surprised at all this attention for Oracle Total Recall, as it seems little more than the Flashback technology that si
Handle slowly changing dimensions with SSIS 2005 wizard
(Baya Pavliashvili) In previous versions of SQL Server, you had to manage the process of implementing slowly changing dimensions through custom logic, often embedded in Data Transformation Services (DTS) packages. Within a DTS package, you had to manually compare each relevant column’s value between
Table Value Constructors and Compound Assignments for SQL Server 2008
(Jonathan Allen) In SQL Server 2008, T-SQL will be getting some welcome enhancements to the syntax itself. Included among these are table value constructors, also known as row constructors, inline variable declaration, and compound assignments.
How NOT to pass a lot of parameters
(Hugo Kornelis) Did you know that SQL Server allows stored procedures to have up to 2100 parameters? And more important: do you care? Well, some people do care, and Joe Celko seems to be one of them.
Business Intelligence – What’s Your Approach?
New SQLonCall Show Posted! Check it out – Chris has put together How to hire a DBA as a show! Tips, tricks – and much more. Find out what you need to know from both the hiring and the being-hired end of things. Watch the show here. > …and, you can catch the most recent SelectViews SQL Server Show here […]
SQLonCall: How to Hire a DBA – the Show!
Pro-Center Video Programming for IT Professionals
Don’t Forget: Sometimes It’s The Easy Stuff…
Don’t Miss the Latest SQLonCall: Basic Security Best Practices (new show posts tomorrow!) SelectViews: Software as a Service, Data Archive Challenge and more Featured Article(s) Diagnosing Poor Data Access Code Using SQL Profiler I created this article to assist DBAs and application developers who need to optimize data access code in their applications. This document covers a few cases where […]