Additional Articles

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

Performance Testing SQL 2008’s Transparent Data Encryption

by Additional Articles

Database Journal

SQL Server 2008

The focus of this article is to test the performance of SQL Server 2008's Transparent Data Encryption. How does it perform compared to a database without encryption? How does the mix of SELECT/INSERT/UPDATE affect the performance results?

2009-04-28

2,670 reads

Take Advantage of In-Memory Analytics

by Additional Articles

Intelligent Enterprise

Business Intelligence

Fast analysis, better insight and rapid deployment with minimal IT involvement: these are among the benefits of in-memory analytics, but different products are appropriate for different environments. Read our in-depth report on in-memory technologies.

2009-04-28

2,316 reads

Convert Implicit and the related performance issues with SQL Server

by Additional Articles

MSSQLTips.com

Performance Tuning

I was a running a routine query using an equal operator on the only column of the primary key for a table and I noticed that the performance was terrible. These queries should have been flying because all I was doing was retrieving one row of data which should have been doing an index seek. When I looked at the query plan it was doing a scan instead. This tip shows you what I found and how to resolve the problem.

2009-04-27

3,197 reads

Using Web Service and XML Tasks in SQL Server 2008 Integration Services

by Additional Articles

SQL Server Performance

Integration Services (SSIS)

Follow a detailed walkthrough of using the Web Service Task to connect to a web service and return an XML result.

2009-04-27

2,488 reads

SQL Server Data Mining Programmability

by Additional Articles

TechNet Blogs

Data Mining

Learn more about the new APIs for data mining in SQL Server 2005, and get an introduction to several common development scenarios.

2009-04-24

2,532 reads

Auditing in SQL Server 2008

by Additional Articles

TechNet Blogs

SQL Server 2008

This paper provides a comprehensive description of the new feature along with usage guidance and then provides some practical examples.

2009-04-23

2,372 reads

Using The File System Task in SQL Server 2008 Integration Services

by Additional Articles

SQL Server Performance

Integration Services (SSIS)

This article examines the File System Task which can perform numerous operations on files and directories such as create, move, delete, and also to set the attributes of files and folders.

2009-04-23

2,718 reads

Getting the SSIS package store to work with a SQL Server named instance

by Additional Articles

MSSQLTips.com

Integration Services (SSIS)

We have a named SQL instance and I am able to connect to the instance, but when I try to view the SSIS packages stored in the MSDB database I get an error. This does not happen with our default instances. Is there an additional setting that must be changed to get this to work?

2009-04-22

2,714 reads

All authors

Additional Articles

Accessing SQL Server Databases with PHP

Inside the new replication features for SQL Server 2008

Performance Testing SQL 2008’s Transparent Data Encryption

Take Advantage of In-Memory Analytics

Convert Implicit and the related performance issues with SQL Server

Using Web Service and XML Tasks in SQL Server 2008 Integration Services

SQL Server Data Mining Programmability

Auditing in SQL Server 2008

Using The File System Task in SQL Server 2008 Integration Services

Getting the SSIS package store to work with a SQL Server named instance

Blogs

VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”

Future IT Roles – Agentic Architect and AI Boom!!

Free Webinar about Columnstore Indexes

Forums

BCA KCP Wisma Barito TLP/WA 08218573837

BCA KCP Niaga Grisenda TLP/WA 08216366654

BCA KCP Kramat Jati Telp/WA0851•8812•0691

Question of the Day

SSoL Support on the OS