(William Pearson) In this lesson, we will introduce a new addition to MDX with Analysis Services 2005, the CASE statement. Classed as an MDX scripting statement within the Microsoft MDX documentation, CASE can return values based upon multiple comparisons. There are two general types of CASE stateme
Other News
Transform XML into HTML Using XSLT
(Haissam Abdul Malak) For demonstration purposes, we will create a simple search engine in which XSLT is used to iterate through the XML file (data retrieved from the database) to display the data based on the user entered criteria. It consists of user information, such as First Name, Last Name, Ema
Use OfficeWriter and Reporting Services to Create Excel Spreadsheets with Live Links to Analysis Services Cubes
(Chris Webb) One of the biggest complaints about SQL Server Reporting Services’ out-of-the-box functionality is that when you export a report to Excel you only get static values pasted into cells in the resulting workbook – all connections with the underlying database which you used to create the re
The Ins and Outs of Offline Files
(Paul Randal) Over the next few posts I want to touch on some of the issues that have been causing confusion on the MSDN Disaster Recovery forum. First up is offline files.
ASP.NET Configuration and Group Policy, Part 1: Creating and Using Custom Configuration Sections
(Alex Homer) ASP.NET applications usually rely on two of the standard sections in a Web.config file: the section that holds general configuration and application values, and the section specialized for storing connection details for data providers such as database s
Avoiding Blocking Issues in ASP.NET Session State Databases
(Greg Low) As soon as ASP.NET systems grow to the point that more than a single Web server needs to be deployed, decisions need to be mode about where the session state will be held. By default, ASP.NET session state lives in the memory of the server hosting the application. The problem with this is
Oracle Session Tracing Part III
(James F. Koopmann) In Part I we learned how to set the CLIENT_IDENTIFIER session variable to more accurately pinpoint resource consumption for an individual user or group of users. We did this through queries to real-time activity views such as V$SESSION and V$ACTIVE_SESSION_HISTORY.
Domain-Specific Development with Visual Studio (Part 2)
(Steve Cook, Gareth Jones, Stuart Kent, Alan Cameron Wills and Alan Cameron Wills) Before talking about graphical DSLs, let’s look briefly at textual DSLs. We’ll see how Domain-Specific Development involves a particular way of thinking about a problem, and we’ll look at how to implement this approac
Technical Advances Make Your Passwords Practically Worthless
(Randy Nash) Your password is a form of authentication, or identification, used to control access to a given resource. Passwords are supposed to be kept secret, thereby controlling access to important information. But due to continuing advances in technology, passwords are becoming weaker every day.
Why IS NULL doesn’t always work in MySQL
(Xaprb) How can a query like “SELECT * FROM tbl WHERE col IS NULL” return a row where the column has a (non-NULL) value? Read on to find out.