December 2007
DBAs get answers to basic Structured Query Language (SQL) questions on the difference between FILLFACTOR = 0 and FILLFACTOR = 100; ISNULL and NULLIF; clustered index and nonclustered index; % used as wildcard and % used as operator; TRUNCATE and DELETE.
October 21, 2005
Much confusion surrounds the term "integration," possibly because Microsoft has so many integration technologies. But a white paper explains integration technologies--and points you in the right direction.
September 23, 2005
With just over 6 weeks until the triple launch of SQL Server 2005, Visual Studio 2005, and BizTalk 2006, Microsoft and other companies are planning a slew of launch events. Get a rundown of the events--and what they mean to you.
July 25, 2005
Now that Microsoft is marketing Notification Services as part of the BI family, I think customers will begin to understand the value Notification Services brings to SQL Server.
June 24, 2005
At the Microsoft Tech Ed 2005 conference, "The First Annual BI Power Hour" session left Douglas McDowell even more pumped-up about SQL Server 2005 BI and the exciting work coming in the months ahead.
May 20, 2005
Chances are, if you're like most DBAs or developers, you don't know much about data mining. This month, Douglas McDowell gets you started.
April 25, 2005
Douglas McDowell clears up a few misconceptions about Reporting Services 2005.
March 31, 2005
Welcome to a New Year and a new focus for SQL Server Magazine UPDATE--Special Edition. These are exciting times as we approach SQL Server 2005's release.
March 31, 2005
SQL Server 2005 will offer changes in the relational-database engine and features for relational data warehousing. I sought out the Group Program Manager for the SQL Server 2005 Relational Engine development team, Lubor Kollar.
March 31, 2005
I've worked with SQL Server 2005 Analysis Services for several months now, and recently I had the opportunity to talk with Ariel Netz, an Analysis Services Group Program Manager and a core member of the original OLAP Services team.
October 22, 2004
Michael Otey recently sat down with Bill Baker, General Manager of Business Intelligence (BI) for SQL Server, and talked about some of the major BI enhancements that Microsoft is including with SQL Server 2005, and more...
September 24, 2004
There’s no doubt that the .NET integration with SQL Server is a big deal, but the CLR isn’t SQL Server 2005’s only new feature.
March 2000
MDX Puzzle for March
March 2000
February MDX Puzzle Solution Revealed
March 2000
The security decision matrix can help you develop and document your security plan.
March 2000
You can use English recognition with the SQL Server English Query component to generate a Multidimensional Expression (MDX) query, and with Visual Basic (VB) you can integrate the query into OLAP applications.
March 2000
Web development requires careful planning and testing to build and maintain high-performance applications. Here’s how to get your project under way.
March 2000
In last month’s column ("System Tables"), I talked about what system tables are and how they're different from user tables. Here are a few more things that are special about system tables and some recommended methods for retrieving information from them.
February 2000
The February MDX Puzzle
February 2000
The answer to last month's MDX puzzle
Add these Headlines to your Website
