(Serdar Yegulalp) Statistics and diagnostic data are the lifeblood of any SQL troubleshooting effort. You can’t find out what’s wrong with a given database’s performance without hard numbers backing up your theories.
Other News
Running out of disk space on MySQL partition? A quick rescue.
(Maciej Dobrzanski) No space left on device – this can happen to anyone. Sooner or later you may face the situation where a database either has already or is only minutes away from running out of disk space. What many people do in such cases, they just start looking for semi-random things to remove
Automate your virtual cloud appliance onto IBM PureFlex System
(Jarek Miszczyk) IBM PureFlex System is a cloud-ready, expert, integrated system that brings together the infrastructure and application layer with proven patterns and can be specifically optimized to meet specific needs, providing all of the infrastructure elements required to run your workloads in
Can a published SQL Server database be renamed
(Mohammed Moinudheen) I have transactional replication configured in production. I am wondering if we could rename the publication database in transactional replication without having to drop and recreate the replication set up. Also, is it possible to rename the database files of the publication da
Windows Metro ? The Lowest Common Denominator
Windows Metro – The Lowest Common Denominator The title is to get your attention. The fact is that Windows Metro will not necessarily be the Lowest Common Denominator anymore than other devices supporting tablet/smart phone style manipulations, primarily touch screens. Many good hardware devices are designed around the Android OS, which the Metro look and feel appears to emulate in […]
SSWUGtv: Gareth Swanepoel talks about SQL Server 2012, extended events wizard and interface – how to performance tune and more.
Video Programming for IT Professionals
Metro Style Apps?is the Mouse Out?
Metro Style Apps…is the Mouse Out? Dana brings me down to earth with her insight into keyboard commands for later versions of Office. For example, when reviewing my understanding of the new Metro Style design principles, I used the changes in Office as an example of making work harder. I have been using Microsoft Excel since 1985….yes, ’85. It was […]
dbms_space displaying information about space usage
(Mohamed Azar) Oracle Database provides data dictionary views and PL/SQL packages that allow you to display information about the space usage of schema objects.
Oracle Enterprise Manager 12c Cloud Control – Managing EM User Security
(Karen Reliford) One key area of concern when it comes to our IT infrastructure continues to be security, in particular user security. In the Oracle world, this concern exists at all levels from the front-end applications, to the middle tier level we use for deployment, to the back end tier or data
InfoSphere DataStage for Enterprise XML Data Integration
(Chuck Ballard, Vinay Bhat, Shruti Choudhary, Ravi Ravindranath, Enrique Amavizca Ruiz and Aaron Titus) XML is one of the most common standards for the exchange of information. However, organizations find challenges in how to address the complexities of dealing with hierarchical data types, particul