Additional Articles

How To Enable User-Defined Hierarchies in SQL Server Analysis Services (SSAS)

by Additional Articles

MSSQLTips.com

Analysis Services (SSAS)

I have a requirement to provide users with the capability to define their own reporting hierarchies for sales data. For instance they had a report which broke down sales by the four regional VPs then by office. Later they created regions, assigned VPs to each region, then assigned offices to each VP. Now they want to be able to create a number of other scenarios and choose which one when they run a report. Can you provide some suggestions on how to do this?

2009-07-10

3,043 reads

Partitioned Table and Index Strategies Using SQL Server 2008

by Additional Articles

TechNet Blogs

Partitioned Tables

The Microsoft SQL Server 2008 database software provides table partitioning to make such operations more manageable.

2009-07-10

3,009 reads

Create a Web-Based CRUD Automation Framework with Python

by Additional Articles

DevX

Python

Implement a CRUD automation framework that handles insert and simple queries, an easy way to talk to a database without needing to write any database-access code.

2009-07-09

1,967 reads

Automating Performance Monitor Statistics Collection for SQL Server and Windows

by Additional Articles

MSSQLTips.com

Performance Monitoring

You have about 100 SQL Servers installed in your production environment. You have performance problems on few of the servers, but they happen during the time when you are not watching the servers. So, how can you automate performance statistics collection on all the servers around the clock so we have the statistics for 24/7/365.

2009-07-08

3,919 reads

Monitoring group of Linked Sql Servers from a Sql Server

by Additional Articles

CodeProject.com

Monitoring

The main purpose of article is to understand how to monitor group of Linked Sql Servers from a Sql Server.

2009-07-08

2,443 reads

10+ tips for working smarter with SQL

by Additional Articles

Builder.com

T-SQL

The sharper your SQL skills become, the more robust and error-free your solutions will be. Here are a dozen practical tips to get you started

2009-07-07

7,621 reads

Limit Groups by Number Using Transact-SQL or MS Access

by Additional Articles

DevX

T-SQL

You can easily limit or group a recordset, but doing both to the same recordset takes a bit of hand coding. Find out how both SQL Server and MS Access can handle the task.

2009-07-07

2,354 reads