2008-03-09
35 reads
Articles
Forum Search Changes
Forum Searching The forum search is back, allowing you to search for specific issues in our discussion forums. There is a search link above the forum thread lists. Please report any issues to the webmaster.
2008-03-08
19 reads
Linked Server Optimization
This article demonstrates the negative affect that linked servers can cause in queries and offers alternatives to speed up performance.
2008-03-07
15,728 reads
The Truth Table
Truth tables are an important part of working with logical values in SQL Server. Yousef Ekhtiari brings us some T-SQL that can help you construct those many variable truth tables and ensure you are getting the results you expect.
2008-03-07 (first published: 2007-04-19)
11,940 reads
Using VBScript to Automate Tasks
This article discusses why VBScript should be one of the tools you use to manage your server. Sample scripts show how to remove files over x days old and how to FTP files.
2008-03-07 (first published: 2003-11-04)
103,014 reads
Apply Test-Driven Development to your Database Projects
This article from MSDN discusses the benefits of TDD and bringing unit testing to your database development.
2008-03-07
3,320 reads
Bad Meetings
A joint editorial this week from the Red Gate team looking back at the news of the week.
2008-03-07
35 reads
Bad Meetings
A joint editorial this week from the Red Gate team looking back at the news of the week.
2008-03-07
38 reads
Extending SQL Server Reporting Services with SQL CLR Table-Valued Functions
This article describes how to take advantage of SQL CLR table-valued functions to combine different types of data sources to create rich and exciting SQL Server Reporting Services reports.
2008-03-07
2,625 reads
How to Break Replication
David Poole is a regular author at SQLServerCentral.com, sharing many of his knowledge and experiences with us over the years. This time he examines some of the issues that you might have with replication.
2008-03-06
12,123 reads
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers