(P.G. Daly) Knowing how to read and write SQL is a skill that is usually taken for granted. It’s assumed SQL is a tool every IT professional has in his or her toolkit. Within the world of the intranet where the business and IT realms often blend together, that can be a detrimental assumption to make

(William Pearson) Having processed cubes in preceding articles, we are aware that processing calculates the aggregations that have been designed for the cube, and then loads the cube with the data, and the calculated aggregations of the data. While we have looked only at Full Processing in most

(Sudha Natarajan) In this article you are going to learn and implement Replication in an hour, amazing isn’t. Now let’s take a tour of Replication.

(Steve Jones) Disaster Recovery is something that’s on my mind lately. With hurricane Charlie rolling through Florida recently (it’s August 2004 as I write this), and my partner Andy without power for nearly a week in central Florida, we’ve had some discussions about how to prepare for a disaster an

(Mike Gunderloy) Want to tackle a certification exam that will test your knowledge of .NET and development best practices to the utmost? One of the application security exams should be perfect for you then. You can choose from Visual Basic .NET or C# versions of the exam; the two are identical e

(Tony Patton) Maintaining data between server calls is a common dilemma in Web development. You may need to maintain information for the application or for particular user sessions. Storing such data is called state management, and ASP.NET provides the means to accomplish the task via various avenue

(Hassan Fahimi) Microsoft SQL Server is built in such a way that it can be managed by Database Administrators (DBA) with a wide range of skills and experience. SQL Server masks the complexity of managing a Relational Database Management System (RDBMS) to make it more appealing to administrators wit

(Ong Boon Kiat) I tried my hand at Google hacking recently. It was easy, and all done with, well, Google. As Google hackers know, what I did was to use Google to look for information residing in other people’s Web-connected servers–and machines connected to those servers. Stuff that I’m not sup

(Don Schlichting) This is the second article in the Cursors with SQL 2000 series. In the preceding article, cursor use and basic syntax were covered. A select cursor was created demonstrating the keywords DECLARE, OPEN, FETCH, @@FETCH_STATUS, and DEALLOCATE. These keywords guide basic cursor executi

(Itzik Ben-Gan) A data warehouse contains data that has been aggregated for data analysis. You aggregate measures (such as quantities and amounts) for different entities (such as employees, customers, and products). You also determine the time units (e.g., day, month, year) for the aggregations