The SQLServerCentral.com Store
We've added a new store section. Read on and visit to see if there's anything worth your while.
MDX in Analysis Services: Mastering Time: Introduction to Moving Avera
In this article, we will examine "rolling average" aggregations, a common business requirement. "Rolling," or "moving," averages, involve a measure, the average under consideration, that is aggregated over a progressively moving window of time periods.
Incident Response - The Framework
Do you have a SQL Server disaster plan? What about something less than a disaster? Steve Jones has worked more than his share of disasters or incidents, some of them self-inflicted. He's taken some of his experience and started a new series looking at a framework for dealing with incidents. Read part 1 about getting prepared.
MDX in Analysis Services: Mastering Time: Period - to - Date Aggregati
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.
NULL Column Analysis
NULL values in columns can indicate a few things, the value isn't known, it's not yet been filled in, or perhaps, as Leo Peysakhovich argues, the column isn't being used? How many SQL Server tables do you have with extra tables and columns that are not being used? Or maybe never have been? This article looks at a statistical analysis of columns using NULLs to determine if you might be able to remove certain columns.
MDX in Analysis Services: Mastering Time: Change across Periods
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.
Disaster in the Real World - Hurricane
Hurricane Charlie had a pretty substantial impact on residents and businesses in Central Florida. Andy lives in the Orlando area and wrote up some notes on the various challenges he ran into it. Out of it you might find a couple things worth thinking about adding into your DR plan.
Review: Log PI
Ever have a transaction you need to roll back? Undo a fat finger? There are a number of log reading products available for SQL Server to help with you in this area. Dale Corey takes a look at LOG PI with an extensive review of the product, including a bunch of screenshots..
Win One of 5 XBOXs!!!!
By now everyone should have heard about the PASS 2004 Summit in Orlando this September. Hopefully you are also aware that SQLServerCentral.com is one of the sponsors for this event and to make it a bit special, we're putting on a reception for everyone that registers for PASS with our promotion code. Read on to see what we've got planned!
Into Fantasy Football? Join the SQLServerCentral.com League.
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
Blogs
Flyway Tips: AI Generating Migration Script Names
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Forums
No Defaults Passwords Ever
Comments posted to this topic are about the item No Defaults Passwords Ever
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?