MDX Numeric Functions: The Max() Function
Business Intelligence Architect Bill Pearson introduces the numeric Max()function, and leads hands-on practice examples of the basic concepts.
2008-01-02
1,984 reads
Additional Articles
Top 10 SQL Server Integration Services and DTS tips
Top SQL Server Integration Services (SSIS) tips from migrating and running DTS packages, to SSIS debugging, maintenance and programming in SQL Server 2005.
2008-01-02
5,713 reads
SQL Server Security Model
Greg Larsen discusses the different options available within SQL Server 2005 for managing security.
2008-01-01
2,853 reads
Add Custom Data Mining Algorithms to SQL Server 2005
Get a high-level overview of the benefits of the extensibility framework in SQL Server 2005 Analysis Services that allows independent software developers to easily integrate new data mining algorithms into the product.
2007-12-31
1,647 reads
Accessing External Data Sources with Microsoft SQL Server Analysis Services 2005
This white paper covers a variety of client object models supported by Microsoft SQL Server Analysis Services when connecting to relational data sources. The example problems and solutions were gathered by members of the Analysis Services team while working with users of Analysis Services.
2007-12-28
2,119 reads
Data Encryption in SQL Server 2005 – Part I
SQL Server 2005 provides four methods of encryption. Part one of this article covers encryption and decryption by passphrase.
2007-12-28
2,818 reads
Creative Ways to Use the TOP Clause
Gregory Larsen discusses how to use the TOP clause to help solve requests where you want to restrict the number of records returned based on a record count.
2007-12-27 (first published: 2007-01-05)
8,395 reads
2007-12-27
3,466 reads
Kimball University: Handling Arbitrary Restatements of History
How do you cope with an executive's request to "bring back a time series of activity for all subscribers who were in platinum status as of X date," or "show me a time series of orders by sales region according to the sales organization as of Y"? Here's how data warehouse pros can cope with the common requirement to look back in time.
2007-12-26
1,522 reads
Optimize T-SQL data types in SQL Server
To optimize Transact SQL (T-SQL) data types in SQL Server, learn how each type affects performance -- I/O, RAM and CPU in SQL Server.
2007-12-26
3,745 reads
Blogs
PostgreSQL: Diagnosing and Fixing a Sequential Scan with No Filter Predicate
A sequential scan is not always a problem — PostgreSQL's planner often chooses one...
Giving AI Agents Visibility Into SQL Server with MCP
I’ve been thinking a lot lately about what it actually takes to make an...
The Book of Redgate: Profits
By Steve Jones
Redgate is a for-profit company. We look to make money by building and selling...
Forums
Stop Prompting Your AI Agent. Give It a Playbook.
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Finish the quote
Comments posted to this topic are about the item Finish the quote
Everything I Needed to Know Used to be Found in One Book
Comments posted to this topic are about the item Everything I Needed to Know...
Question of the Day
Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers