Browse by Tags - SDT Community Server

How to store and fetch binary data into a filestream column

Desribes how to store and fetch binary data to a filestream column compared to a varbinary column

Posted to Aggregated Feeds (Weblog) by Anonymous on 01-04-2009
Data Mining with SQL Server 2005 without Analysis Services

A C# implementation of CHAID for MSSQL 2005 à la Cognos scenario.

Posted to Aggregated Feeds (Weblog) by Anonymous on 01-01-2009
How to Use a Multi-Result Set Stored Procedure in SSIS

How to use a script component as a data source for multi-result set Stored Procedures.

Posted to Aggregated Feeds (Weblog) by Anonymous on 01-01-2009
Cross Domain/Platform Authentication and Data Transfer

Introduce a methodology of authenticating user cross domain/platform and transferring user data from one site to another during the authentication process.

Posted to Aggregated Feeds (Weblog) by Anonymous on 12-30-2008
GUID versus Number as Primary Key? Why not use "Numerical GUID"?

Best practice for using GUID as promary key.

Posted to Aggregated Feeds (Weblog) by Anonymous on 12-27-2008
SQL Server 2000/2005: Automated Database Backups and Restorations

Provides an insight into creating automated process for Backups and Restorations

Posted to Aggregated Feeds (Weblog) by Anonymous on 12-23-2008
Powershell How-To - Part 1

This article is a part of a series of articles that shows HOW-TO do various tasks in powershell.

Posted to Aggregated Feeds (Weblog) by Anonymous on 12-15-2008
99.99% available ASP.NET and SQL Server SaaS Production Architecture

Production Architecture for a SaaS web application built using ASP.NET and SQL Server that guarantees 99.99% availability and super performance

Posted to Aggregated Feeds (Weblog) by Anonymous on 12-10-2008
Simple Excel 2007 data loader to SQL 2008 Server

Simple Excel data loader to SQL Server usingS QlBulkCopy

Posted to Aggregated Feeds (Weblog) by Anonymous on 12-10-2008
Pivot 2 or more columns in SQL Server 2005

A work around the limitation of only being able to pivot 1 colum

Posted to Aggregated Feeds (Weblog) by Anonymous on 12-07-2008

Page 1 of 15 (141 items) 1 2 3 4 5 Next > ... Last »