Columns

Advanced Search

Columns

116 results found for Columns, displaying items 1 - 20

[December 2007]

Sharpen Your Basic SQL Server Skills
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.
SQL Server Magazine — Pinalkumar Dave

[October 21, 2005]

A Map Through Microsoft's Integration Maze
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.
SQL Server Magazine — Douglas McDowell

[September 23, 2005]

Building to a Fever Pitch: Countdown to Product Launch
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.
SQL Server Magazine — Douglas McDowell

[July 25, 2005]

SQL Server 2005 Notification Services
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.
SQL Server Magazine — Douglas McDowell

[June 24, 2005]

Microsoft's First Annual BI Power Hour
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.
SQL Server Magazine — Douglas McDowell

[May 20, 2005]

Data Mining in SQL Server 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.
SQL Server Magazine — Douglas McDowell

[April 25, 2005]

SQL Server 2005 Reporting Services--Worth the Upgrade
Douglas McDowell clears up a few misconceptions about Reporting Services 2005.
SQL Server Magazine — Douglas McDowell

[March 31, 2005]

SQL Server 2005's ETL Tool: Integration Services
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.
SQL Server Magazine — Douglas McDowell

[March 31, 2005]

SQL Server 2005: Relational Engine Enhancements
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.
SQL Server Magazine — Douglas McDowell

[March 31, 2005]

Analysis Services Integrates with Reporting
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.
SQL Server Magazine — Douglas McDowell

[October 22, 2004]

Big Changes for BI in SQL Server 2005
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...
SQL Server Magazine — Michael Otey

[September 24, 2004]

Getting Ready for SQL Server 2005--Beyond the CLR
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.
SQL Server Magazine — Michael Otey

[March 2000]

MDX Puzzle
MDX Puzzle for March
SQL Server Magazine — Russ Whitney

[March 2000]

February MDX Puzzle Solution Revealed
February MDX Puzzle Solution Revealed
SQL Server Magazine — Russ Whitney

[March 2000]

Solutions by Design: The Security Matrix
The security decision matrix can help you develop and document your security plan.
SQL Server Magazine — Michelle A. Poolet

[March 2000]

Mastering OLAP: Using English Query with OLAP
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.
SQL Server Magazine — Russ Whitney

[March 2000]

Web Dev: Optimizing Web Servers
Web development requires careful planning and testing to build and maintain high-performance applications. Here’s how to get your project under way.
SQL Server Magazine — Ken Spencer

[March 2000]

Inside SQL Server: Accessing System Tables
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.
SQL Server Magazine — Kalen Delaney

[February 2000]

MDX Puzzle
The February MDX Puzzle
SQL Server Magazine — Russ Whitney

[February 2000]

January MDX Puzzle Solution Revealed
The answer to last month's MDX puzzle
SQL Server Magazine — Russ Whitney

[1] 2 3 4 5 6

ADS BY GOOGLE

SPONSORED LINKS		FEATURED LINKS
Download Data Protection Manager 2007 Disaster recovery at a low cost Maximize speed, performance and reliablity of your PCs and servers—automatically! Speed Up Your PC! Try Diskeeper 2008 with InvisiTasking Free Now! Microsoft Learning Snack - Green IT Through Virtualization Many organizations face rising operating costs caused by excessive energy consumption. Virtualization and "Green IT" can help cut these costs. Get the information you need to bring Green IT savings to your business. Order Your Fundamentals CD Today! Register today for your in-depth copy of one of three Fundamental CDs on the following topics – Exchange, SQL, and SharePoint. Microsoft Learning Snack - Virtualization With Windows Server 2008 Windows Server 2008 includes virtualization technology that allows many operating systems - including open source - to run on a single host. Come learn the basics of implementing these features. Microsoft Learning Snack - Virtualization Basics With virtualization, computing components essentially become on-demand services, freeing each element of a system from the others. This short video explains the needs, benefits, and technologies behind virtualization.		Microsoft Learning Snack - Virtualization Basics With virtualization, computing components essentially become on-demand services, freeing each element of a system from the others. This short video explains the needs, benefits, and technologies behind virtualization. Microsoft Learning Snack - Virtualization With Windows Server 2008 Windows Server 2008 includes virtualization technology that allows many operating systems - including open source - to run on a single host. Come learn the basics of implementing these features. Empower Your Processes with PowerShell 201 Paul Robichaux delves deep into PowerShell how-tos in 3 informative lessons, each followed by live Q&A—all on your own computer! Register today! Microsoft Learning Snack - Green IT Through Virtualization Many organizations face rising operating costs caused by excessive energy consumption. Virtualization and "Green IT" can help cut these costs. Get the information you need to bring Green IT savings to your business. New Release: Windows IT Pro Master CD 13 years of content archives, fast answers with advanced search tools, and full access to WindowsITPro.com—order today!

Windows IT Pro Home

FAQ for Windows

WinInfo News
Europe Edition

About Us

Media Kit

Affiliates / Licensing

SQL Server Magazine

Office & SharePoint Pro

Windows Dev Pro

IT Job Hound

ITTV
IT Library

Technology Resource Directory

Connected Home

Windows Excavator

Windows SuperSite