Columns
|
116 results found for Columns, displaying items 1 - 20
|
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
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
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
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
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
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
SQL Server 2005 Reporting Services--Worth the Upgrade
Douglas McDowell clears up a few misconceptions about Reporting Services 2005.
SQL Server Magazine
—
Douglas McDowell
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
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
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
MDX Puzzle
MDX Puzzle for March
SQL Server Magazine
—
Russ Whitney
February MDX Puzzle Solution Revealed
February MDX Puzzle Solution Revealed
SQL Server Magazine
—
Russ Whitney
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
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
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
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
MDX Puzzle
The February MDX Puzzle
SQL Server Magazine
—
Russ Whitney
January MDX Puzzle Solution Revealed
The answer to last month's MDX puzzle
SQL Server Magazine
—
Russ Whitney
|
|
Register
