(Steve Callan) The title says it all, except these are some of my personal favorites.
Author: SSWUG Research
Reporting Services performance analysis and tuning
(Michelle Gutzait) While working on a project, I wanted to monitor SQL Server’s activity using SQL Profiler. My private SQL Server was not in use by any application or user at the time of monitoring. I ran the trace and realized that the report server was issuing SQL commands every few seconds. I de
SQL Server Processor Performance, 2006
(Joe Chang) This historical view on the progression in processor performance over time is presented as a guide to upgrading older server systems and as an acquisition strategy for new systems. The focus is on the Intel IA-32 line because Intel designs processors to Moore’s Law, and a common set of p
Common Table Expressions (CTE) in SQL Server 2005
(Scott Mitchell) When crafting a query in SQL, there are often times when we may need to operate over a set of data that doesn’t inherently exist within the system. For example, the database for an eCommerce web application would have the standard tables – Products, Customers, Orders, OrderDetails,
Oracle/PLSQL: ORA-12154 Error
You tried to connect to Oracle, but the service name is either missing from the TNSNAMES.ORA file or is incorrectly defined.
MySQL GROUP BY – Aggregate Functions
After you have mastered the basics of MySQL, it’s time to take the next step and take on Aggregate Functions. Before we talk about what they are, let’s review the definition of aggregate, as it relates to MySQL.
Let Users Customize Your Apps With Visual Studio Tools For Applications
(Paul Stubbs) Many software developers have increased the usefulness of their applications by making them customizable, usually through the addition of a technology like Microsoft Visual Basic for Applications (VBA). But these days VBA doesn’t go far enough. You need a way to provide customers with
A flexible charting library for .NET
(J. Champion) ZedGraph is a class library, Windows Forms UserControl, and ASP web-accessible control for creating 2D line, bar, and pie graphs of arbitrary datasets. The classes provide a high degree of flexibility – almost every aspect of the graph can be user-modified. At the same time, usage of t
DB2 9 DBA exam 731 prep, Part 3: Database access
(George Baklarz) This tutorial will take you through the various steps required to manage some of the objects within DB2®. It includes overview information for indexes, constraints, referential integrity, and views. This is the third in a series of seven tutorials that you can use to help prepare fo
ASP.NET Tip: Create a Perpetual Page Footer
(Eric Smith) One of the easiest ways to tell if a Web site has been updated recently is to check the bottoms of its pages. Many sites include page footers with their copyright dates. Unfortunately, webmasters often forget to change the date each year, making their sites look outdated to users.