Additional Articles

Access Your Data On Premise Or In The Cloud With ADO.NET Data Services

by Additional Articles

Microsoft MSDN

cloud services

Web Services has been a hot topic for a number of years now, but what, you may wonder, are these Data Services everyone's talking about lately? As the architecture of Web applications has changed and matured (with the popularity of Rich Internet Applications [RIAs], for example), there has been an increased awareness of the value of exposing raw data, minus any interface or formatting, to any service or application that wants to consume it.

2009-05-05

1,623 reads

Using the OPENROWSET function in SQL Server

by Additional Articles

SearchSQLServer

OPENROWSET

OPENROWSET is a handy tool for retrieving data. Find out how to use the OPENROWSET function for SQL Server and Microsoft Access.

2009-05-05

4,399 reads

Finding the causes of poor performance in SQL Server, Part 2

by Additional Articles

SimpleTalk

Performance Tuning

In the first part of this series of articles, Gail showed how to find the procedures that contributed most to performance problems. In this final part, she shows how to use query statistics to pinpoint the queries that are causing the biggest problems, and then use the query execution plans to find out which operations are the root cause.

2009-05-04

4,867 reads

Installing Reporting Services on SQL Server 2005 Express Edition

by Additional Articles

Database Journal

Reporting Services (SSRS)

Having completed our coverage of the Service Broker characteristics specific to SQL Server 2005 Express Edition, we now turn our attention to Reporting Services. In this article, we will present the initial setup process, leaving discussion of configuration, management, security, and usability for future installments.

2009-05-04

2,776 reads

Script dimensions using Windows PowerShell and AMO

by Additional Articles

Database Journal

PowerShell

Part 11 of our series on "Microsoft Windows PowerShell and SQL Server 2008 AMO" discusses how to generate a script for given dimension of the Analysis Service database to XMLA format file.

2009-05-01

2,122 reads

SQL Server 2005 Row Versioning-Based Transaction Isolation

by Additional Articles

TechNet Blogs

Row Versioning

Microsoft SQL Server 2005 provides nonlocking, nonblocking read consistency to your users through snapshot isolation and read committed isolation using row versioning. Find out when you can use these features to improve performance and reduce latency in your applications.

2009-05-01

2,535 reads

Peer-to-Peer Replication in SQL Server 2008 – Configure a two-node topology

by Additional Articles

Database Journal

Replication

The first installment of this series describes the steps to configure a two-node Peer-to-Peer replication topology.

2009-04-30

1,941 reads

Performing Hierarchical Restructuring Using ANSI SQL

by Additional Articles

DevX

Hierarchies

Discover the flexibility and power of using ANSI SQL to reshape and transform hierarchical structures.

2009-04-30

2,034 reads

Accessing SQL Server Databases with PHP

by Additional Articles

TechNet Blogs

The SQL Server 2005 Driver for PHP is a Microsoft-supported extension of PHP 5 that provides data access to SQL Server 2005 and SQL Server 2008. The extension provides a procedural interface for accessing data in all editions of SQL Server 2005 and SQL Server 2008. The SQL Server 2005 Driver for PHP API provides a comprehensive data access solution from PHP, and includes support for many features including Windows Authentication, transactions, parameter binding, streaming, metadata access, connection pooling, and error handling.

2009-04-29

2,116 reads

Inside the new replication features for SQL Server 2008

by Additional Articles

SearchSQLServer

SQL Server 2008

SQL Server 2008 features several replication improvements, and some are more compelling than others. Learn what's new with peer-to-peer topologies, merge replication and more.

2009-04-29

2,855 reads

All authors

Additional Articles

Access Your Data On Premise Or In The Cloud With ADO.NET Data Services

Using the OPENROWSET function in SQL Server

Finding the causes of poor performance in SQL Server, Part 2

Installing Reporting Services on SQL Server 2005 Express Edition

Script dimensions using Windows PowerShell and AMO

SQL Server 2005 Row Versioning-Based Transaction Isolation

Peer-to-Peer Replication in SQL Server 2008 – Configure a two-node topology

Performing Hierarchical Restructuring Using ANSI SQL

Accessing SQL Server Databases with PHP

Inside the new replication features for SQL Server 2008

Blogs

Resetting on the AI hype train

A New Word: Etherness

Vibe Coding a Login Tracking System

Forums

The Microsoft SQL Year in Review

T-SQL in SQL Server 2025: The || Operator

Your Value from a Conference

Question of the Day

UNISTR Basics