(Xaprb) I’m continuing to add new tools to the MySQL Toolkit. MySQL Deadlock Logger is for extracting and storing information about the latest recorded InnoDB deadlock. It’s not only easy to view the information from the command line, it’s dead simple to store it back into a MySQL table for analysis
Author: SSWUG Research
Disabling Constraints and Triggers
(John Papa) Constraints are valuable tools for maintaining data integrity in databases. However, there are times when it is convenient to disable one or more of them to perform tasks such as data synchronization with an offline database. When SQL Server replication is used to synchronize data betwee
Tempdb changes in SQL Server 2005
(Serdar Yegulalp) The total number of changes to SQL Server in its 2005 edition could fill a book, and in fact has filled several such books. The most significant changes are not feature changes; They’re changes in internal behavior that aren’t always immediately visible to a user or administrator.
Use Ajaxterm for remote administration tasks
(Vincent Danen) Remote administration usually requires access to a terminal on a remote system, but if you don’t want to permit direct ssh access, there aren’t a lot of other options. And with constant port-knocking and brute-force attempts on ssh services these days, some people would prefer not to
Rich Ajax slide shows with DHTML and XML
(Jack Herrington) Learn to create an Asynchronous JavaScript and XML (Ajax) client-side slide show that’s animated using "Ken Burns Effects." Here, you discover how to build XML data sources for Ajax, request XML data from the client, and then dynamically create and animate HTML elements with that X
Black Belt Administration: Performance Dashboard for Microsoft SQL Server, Part I
(William Pearson) In this article, we extend the meaning of “samples,” as well as the type of “Administrator,” a bit further. We use an installation file recently made available by Microsoft that allows us to implement an exciting new report pack with minimal effort. Because we will be running the i
Processing with C#, Oracle transactions and Oracle exceptions
(Dimitar Madjarov) The main purpose of this article is to show one different way of cooperation between Oracle and C# in process of developing different Oracle database application with Microsoft Dot.Net technology and C#. In this article I will try to show you a new approach of programming and taki
Tutorial: Specializing DITA Conditional Attributes
(Eliot Kimber) A new feature in DITA 1.1 is the ability to specialize from the base= and props= attributes. For conditional processing, this lets you add your own attributes rather than using otherprops=, which can be clearer to authors and implementors. [NOTE: at the time of writing the DITA Open T
Linking SQL Express 2005 Tables to MS Access 2007
(Jayaram Krishnaswamy) This tutorial shows you how to link tables on your SQL 2005 Express server to an MS Access 2007 database. Some of the salient features of the MS Access 2007 program were discussed in an earlier tutorial including a detailed description of the “Ribbon.” Reading the earlier arti
Aligning Your BI Environment with SOX Internal Controls
(Brandon Lucado) Is your financial reporting application compliant with Sarbanes-Oxley (SOX) Section 404? The answer to this question will depend on what controls your company has established internally. SOX Section 404 mandates companies to implement a control framework for their financial reportin