With the full-text search features in SQL Server, along with several hybrid search methods for comprehensive table scanning, companies can better meet specific business needs.
2009-02-20
2,448 reads
This article is the final article in a series that explores new features that are available in SQL Server 2008 Management Studio
2009-02-19
3,549 reads
The previous installment of "SQL Server 2005 Express Edition" discussed Service Broker's internal activation, which allows you to automate communication between initiator and target. Unfortunately, there are some caveats related to its security context. This article describes their specifics and provides a couple of methods to eliminate any undesirable side effects they introduce.
2009-02-19
1,164 reads
When reviewing an issue through the Replication Monitor, the error messaging was leaving me wanting more detail to find out why the replication process was failing. So my question is, is there a way to garner more information from the replication agents running via SQL Server Agent?
2009-02-18
2,346 reads
This article is part 2 of a 4 part series that explores the internals of SQL Server Integration Services. This article looks at SSIS Transformations and Execution Trees.
2009-02-18
3,157 reads
Dynamic management views measure the effectiveness of indexes and discover fragmented indexes that may slow down SQL Server.
2009-02-18
3,072 reads
SQL Server's new FILESTREAM feature simplifies the process of keeping file-based data, such as images, in sync with relational data.
2009-02-17
2,743 reads
This article shows the new features that are available in SQL Server 2008 Management Studio
2009-02-17
5,046 reads
SQL Server login monitoring and access control are important elements of SQL database security. Learn how DDL triggers can help alert you to security issues.
2009-02-16
3,195 reads
I have heard that the installation process for SQL Server 2008 differs from previous installation processes. So, how much different is the installation process? In this three-part tip series, we will review the installation process for SQL Server 2008, which differs quite a bit from SQL Server 2000 and SQL Server 2005 installations.
2009-02-16
3,753 reads
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
We have two "identical" instances of an ASP.NET web service (or so I have...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Which of these are valid OPENQUERY() uses?
See possible answers