In this article, we began with a discussion of general business needs as related to the concept of relative time. We then undertook a practical, multi-step exercise, based upon a hypothetical business need, to illustrate a potential solution for a stated requirement.
2004-08-26
992 reads
In this article and others subsequent to it, we will focus on time considerations in our MDX queries., and how we can successfully report change over time, as well as to accumulate those changes to present the precise snapshots, trends and other time-based metrics so dearly appreciated in business.
2004-08-25
1,221 reads
If you're into fantasy football, come waste some time with us and join our free league at Yahoo. Read the below instructions on how to join. Space is limitted in the first league to 12 teams so join quickly and the draft starts Tuesday! If it's popular, we'll create other leagues.
In order to join the league, just go to http://football.fantasysports.yahoo.com/f1,
click the "Sign Up Now" or "Get Another Team" button and
follow the links to "Join a Custom League". When prompted,
enter the League ID# and password below.
League ID#: 525071
Password: ssc
2004-08-20
204 reads
Notification Services is one of the features included in SQL Server 2005. As the name implies, Notification Services are services which send notifications to the interested entities based on what they would like be notified on. In this article you will see how to implement Notification Services in SQL Server 2005
2004-08-20
2,803 reads
A new article from MSDN magazine on stopping SQL Injection attacks by examining how the SQL can be exploited. It's a good basic article for developers as well as DBAs who might have to review code.
2004-08-20
2,865 reads
An article from Microsoft Journal looking at the new Mining features of SQL Server 2005. If you're interested in Analysis Services, this ias a good look (from a high level) at the next version.
2004-08-19
1,617 reads
How many times do you need to estimate space for a new application? Or estimate growth for an existing one? We've had a new contribution to the freeware section of the site. Tablesizer will allow you to guesstimate how much disk space you'll need. Take a peek if you need it, rate the product and give the author any feedback you have.
2004-07-19
3,779 reads
Books on line has been updated since the release of SQL2000.
If you check the documentation for the sp_addlogin stored procedure and example E says
SELECT CONVERT(VARBINARY(32), password) then you should update your installation.
2004-07-16
193 reads
Dark Horse CRM is an enterprise-class Customer Relationship Management application that allows companies to better develop and maintain customers. Visit www.darkhorsecrm.com for more information and to download the free version of Dark Horse CRM that runs on Java, Apache Tomcat, and MSSQL or PostgreSQL.
2004-07-07
3,877 reads
A key service pack has now been released for Microsoft SQL Server Reporting Services. This one adds key enhancements and fixes many bugs.
2004-06-25
1,937 reads
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
By Steve Jones
This image is from 2010, and it goes along with my last post of...
All week we've had issues with the site being up and down. There's been...
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers