The State Of IT
In 2004 is the IT industry expanding or contracting? Is your job secure? Steve Jones recently completed a survey and just got the results. Read this short summary of the results.
Troubleshooting and Debugging SQL Web Services Configurations
A Q&A look at the new Web Services configurations in SQL Server 2005.
The Daily Database Build
From SQLTeam's Bill Granazio, a look at how he ensures his database scripts are always working.
InfoPath 2003 - Part 2
Continuing with Dinesh Asanka's series on SQL Server and Infopath 2003, he shows us this time how to build a report that joins two tables and includes some conditional formatting. Infopath 2003 is part of Office 2003 and is a great quick and dirty tool for getting to your SQL Server data.
DataSet Server CE: Database Connectivity for Windows Mobile-Based Devi
A short tutorial on building database back-ended applications with SQL Server and CE. If you're looking to build mobile apps, this is a good place to start.
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.
Blogs
SQL Server Wait Stats
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
FabCon 2025 Recap
By DataOnWheels
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...
Privacy Policy
We value your privacy. This policy explains what personal data we collect and why. What...
Forums
why cant i get rid of extra dataset
hi i never used shared datasets before in ssrs. i created a dataset called...
Distinct values using string_agg
Hi Is it possible to get distinct values using string_agg Select T1."transType", WHEN T1."TransType"...
Refactoring a DELETE query using NOT EXISTS — need expert feedback
Hi everyone, I'm working on optimizing a DELETE query used in a data cleanup...
Question of the Day
Importing Flat Files
What types of sources can be used with the Import Flat File Wizard in SQL Server Management Studio (SSMS)?
See possible answers