(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.
Author: SSWUG Research
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
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.
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
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
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.
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
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
MDX Scripting Statements: Introducing the Simple CASE Statement
(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
Have you reorganized your DB2 catalog lately?
(Willie Favero) If your answer is no, then I have to ask why not? How often do you reorganize your production table spaces? I’m guessing fairly often. So, what can be more “production” than your DB2 catalog? Sure, you don’t have to REORG your catalog as frequently as you might reorganize your user t