OLAP Services: Managing Slowly Changing Dimensions
Amir Netz is one of the true OLAP and SQL Server gurus at Microsoft. If you ever get the chance to see him speak, go. This is one of his articles examining OLAP services.
2001-08-30
2,324 reads
Additional Articles
INF: Understanding How to Configure a SQL Server Connection Affinity
In an online transaction processing (OLTP) environment, the connection affinity mask option may provide performance enhancement in high-end, enterprise-level SQL Server environments that are running on computers with 16 or more CPUs. In particular, this option is useful when there are a significant number of network interactions (more than 10,000 per second) between the middle-tier application servers and the back-end SQL Server system.
2001-08-28
1,500 reads
SQL Insider Freeware Software to Become Openware
Robert Vallee has announced that he will release the source code to SQL Insider early to September 15th. On that date, members will be able to download the source code and make modifications to the program.
2001-08-27
37 reads
The Self-Taught DBA
Are you thinking of becoming a master DBA? If so, find out how you can in this article.
2001-08-24
4,429 reads
Strategies for Backing Up and Restoring Transactional Replication
Microsoft® SQL Server™ 2000 allows you to restore transactional replication databases without reinitializing subscriptions or disabling and reconfiguring publishing and distribution. You can set up replication to work with log shipping, enabling you to use a warm standby server without reconfiguring replication.
2001-08-21
2,176 reads
The Ultimate SQL Server
From a DBA's point-of-view, the bigger the SQL Server box, the better. What would you consider to be the ultimate SQL Server box?
2001-08-10
1,628 reads
Upsize Your Database: Convert Your Microsoft Acces
What if you need to convert an existing Microsoft Access 97 database application into a true client-server application that is based on a SQL Server back end? If you know a little about Visual Basic and SQL Server, it's easy to make your app take advantage of the power and scalability provided by SQL Server 7.0.
2001-08-09
1,435 reads
Monitoring blocking on a Server
This article will demonstrate how to monitor active spids, blocked by spids,cpu,I/O,cmds and app name being issued in a real time fashion by using the cmd shell calling a T-SQL script and a resource kit utility.
2001-08-07
49 reads
SQL Server 2000: New Features Provide Unmatched Ea
SQL Server 2000 includes many new features that extend its capabilities as a high performance relational database system with a rich development environment. This article presents an overview of new product features including AWE support, new data types, new user-defined and built-in functions as well as enhancements in trigger functionality, indexing, collation, and property definition.
2001-08-03
3,578 reads
Microsoft SQL Server 2000 Security
This document introduces SQL Server administrators and developers to the new security features of SQL Server 2000. In addition to outlining the new features, there is a detailed discussion about how to best implement security in a Microsoft Windows® 2000 domain environment as well as source code examples.
2001-08-02
1,383 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...