(Nikolay Savvinov) Many database performance problems can be resolved via a top-down approach: you look at database performance globally (using statspack or AWR report) and then you work your way down to specific SQL consuming most of resources. This approach breaks when the application is not using
Other News
SQLFire multi-site WAN replication
(Pas Apicella) In then latest SQLFire 102 release we have introduced muti-site WAN deployments. The example below shows how quickly we can get this setup with simple SQL calls on both sites. In this very simple example we will have 2 distributed SQLFire sites being setup as a multi-site WAN deployme
Simple CRUD with NHibernate and Windows Form
(Niladri.Biswas) Today, we will get ourself introduce with an Object Relational Mapper (ORM) technology through NHibernate.The main purpose of any ORM technology is to map the data representation from an object model to a relational data model.In this article, we will address the same with the help
Developing Web Applications using JavaServer Pages and Servlets
(Martin Keen, Rafael Coutinho, Sylvi Lippmann, Salvatore Sollami, Sundaragopal Venkatraman, Steve Baber, Henry Cui and Craig Fleming) This IBM Redpaper publication illustrates how to develop Java Platform, Enterprise Edition (Java EE) applications using JavaServer Pages (JSP), Java EE servlet techno
Understanding the MySQL Information Schema Database
(Rob Gravelle) The INFORMATION_SCHEMA database is where each MySQL instance stores information about all the other databases that the MySQL server maintains. Also sometimes referred to as the data dictionary and system catalog, it’s the ideal place to lookup information such as the name of a databa
Deploy new applications on IBM PureSystems with plug-ins, Part 2
(Chin Huang and Ton Ngo) The introduction of IBM PureSystems — an expert, integrated, enterprise-level family of cloud system that encompass applications, services, hardware, and even the expertise (delivered in the form of best practices patterns) — takes cloud computing to new heights.
Migrating SQL Reporting Services to a new server
(Dale Kelly) I have some SQL Server 2005 Reporting Servers that have many reports, data sources and subscriptions loaded on them. My company is in the process of moving from SQL 2005 to SQL 2008 and 2008 R2. I need to move all the objects off the 2005 Reporting Server to the 2008 Reporting Server.
What is Important When Interviewing Software Developers?
What is Important When Interviewing Software Developers? Lately I have been interviewing a lot of candidates for senior and entry level software developer positions. I recognize that software languages and libraries will change over time; so, I am not looking for skills with particular languages as much as styles of writing code. Here are some of the things I look […]
SSWUGtv: SQL Server Tip of the Day – handling big data… quantities. Tips and food for thought.
Video Programming for IT Professionals
Usage of TVP Can Fail
SSWUGtv With Stephen Wynkoop Do you think Big Data should impact your privacy practices? Find out in this recent edition of SSWUGtv Watch the Show] Usage of TVP Can Fail Table Value Parameters (TVP) are a technique for passing a table as an input value to a stored procedure or a function. They are supported in SQL Server as of […]