Virtual Training – SSIS, and Replication February 1 – 28, 2011 Here is an opportunity for you to add or extend your SQL Server skills in the areas of SQL Server Integration Services (SSIS) and/or SQL Replication. As Stephen wrote a while back, there are so many skills a SQL Server professional needs to have today, its difficult to keep […]
Other News
What is ebXML and What Does It Do?
(Darla Ferrara) XML is changing the way the web works with projects such as ebXML. This is not news really. Since the 1990‚s, committees have been examining ways to update and improve standards for the Internet and associated languages.
System Privileges for Oracle Database XE
(W. Jason Gilmore and Bob Bryla) A system privilege is a right to perform an action on any object in the database, as well as other actions that do not involve objects at all but rather such tasks as running batch jobs, altering system parameters, creating roles, and even connecting to the database
UNIQUE WHERE NOT NULL indexes
(Serge Rielau) Some of you may know that I am engaged in enabling Oracle applications to DB2.
Innodb undo segment size and transaction isolation
(Peter Zaitsev) You might know if you have long running transactions you’re risking having a lot of “garbage” accumulated in undo segment size which can cause performance degradation as well as increased disk space usage.
SQL Server Data Mining with Microsoft Office Excel
(Dinesh Asanka) A key issue in data mining is not only generating the results but also interpreting them. Unfortunately it is often difficult to interpret the results of data mining and many users are turning to Excel and its data mining add-in tool.
Linq to object with DataGridView
(Hussein Ahmed) Language Integrated Query (LINQ) is considered one of the most important features to all developers nowadays; the powerfull feature of LINQ to execute complex queries from any datasourse with simple, clean and concise code.
Description of updates for MSXML Core Services 3.0 and MSXML Core Services 6.0
When you visit a Web site or run an application that loads XHTML documents by using Microsoft XML Core Services (MSXML), MSXML will send requests to the World Wide Web Consortium (W3C) to fetch well-known Document Type Definition (DTD) files every time.
Standby database creation of VLDBs
(Jay Stanley) I have mentioned before that the best way to insure Oracle RDBMS uptime, is to create and maintain a physical standby database. There simply is no more reliable way to insure uptime for the Oracle RDBMS.
Beware of starting slaves from the position in the master.info file
(Singer Wang) I’ve seen many a good DBA make the master of starting slaves from the position in the master.info file, most recently this week, that I want to bring it to everyone’s attention. Of course I mean the underlying issue and not the names of the DBA because that would be cruel.