Now you can perform efficient, sophisticated text analysis using regular expressions in SQL Server 2005.
MSDN Magazine February 2007
View Complete Post
Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.
MSDN Magazine October 2006
Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.
MSDN Magazine July 2006
Many applications require some degree of integration with a reporting tool. A good solution, SQL ServerT Reporting Services 2005, provides Web-based reports and can be integrated into both WindowsÃÂ® Forms and Web-based applications.
MSDN Magazine June 2006
SQL Server 2005 includes several important improvements to the Transact-SQL (T-SQL) language. One added feature is a new kind of trigger that fires when data definition language (DDL) statements run.
MSDN Magazine May 2006
SQL Server 2005 offers a completely redesigned SQL Server Integration Services engine, formerly known as Data Transformation Services. It includes many new features such as built-in support for Fuzzy Lookups and Fuzzy Groupings, which help you build powerful data-cleansing solutions. This article provides an overview of fuzzy searching techniques and a dissection of the underlying fuzzy search technology implemented in SQL Server 2005.
MSDN Magazine September 2005
By now, you're certainly collecting a variety of data from your Web site. But once you collect it, what do you do with it. For it to be meaningful, this data must be categorized and analyzed. The SQL Server 2005 data mining functionalities can help you get the most out of those reams of data you collect, as Peter Pyungchul Kim explains.
Peter Pyungchul Kim
MSDN Magazine June 2005
In SQL Server 2005 Analysis Services you'll find new algorithms, enhancements to existing algorithms, and more than a dozen added visualizations to help you get a handle on your data relationships. Plus, enhancements to the Data Mining Extensions to SQL along with OLAP, DTS, and Reporting Services integration make it possible to create a new breed of intelligent apps with embedded data mining technology. Here the author explains it all.
MSDN Magazine September 2004
i wanted to store image in sqlserver database image field and i did. But now in some cases i want to store null value in that image field please let me know how to do this using file uploader.please give complete sample code.
I have a strange issue regarding SQL Server SMO Transfer. I am using the Transfer class to create a copy of a database. I will explain the different cases I have tried so far and maybe someone can help me figure out what's going on.
I run my C# code from an assembly that references version 18.104.22.168 of SMO assemblies that are in my GAC
If I target a database hosted on a Sql Server 2005 database engine, it works perfectly and fast.
But of course, as soon as I try to target a Sql Server 2008 database engine, it complains that it is not compatible. No surprise there.
I run the exact same C# code from an assembly that references version 10.0.0.0 of SMO assemblies that are also present in my GAC
If I target a database hosted on a Sql Server 2008 database engine, it works perfectly and fast.
However, if I try to target the sam
how can i access my sql express 2005 database from other computers...
How can I run SQL Server 2005 Setup to make SKUUPGRADE=1?Rafael