Articles

The SQL Server Tables and Exchange Web Services sample demonstrates a powerful integration of Microsoft® Exchange Server 2007 and Microsoft SQL Server™ 2005 features. This integration enables you to provide data from both Microsoft Exchange and SQL Server to client applications so that the data appears as if it were stored in SQL Server. As you will see, this creates some exciting development scenarios.

2007-06-22

1,640 reads

Discuss

How to use trace flags in SQL Server 2000

by Christoffer Hedgate

SQLServerCentral.com

Administration

SQL Server 2000 trace flags can dramatically alter the behavior and functionality of the server. There are a number of ways that they can be enabled and Chris Hedgate brings us a tutorial on their use and benefits.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.2 (5)

You rated this post out of 5. Change rating

2007-06-21 (first published: 2005-05-04)

25,477 reads

Discuss

The Journey to Katmai

by Steve Jones

SQLServerCentral.com

With the next version of SQL Server due to release in 2008, Steve Jones takes a look of some of the more interesting features available in the June 2007 CTP and that should be ready for release next year.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-06-21

8,582 reads

Discuss

Ignoring a SSIS Checkpoint

by Additional Articles

JumpStartTV

Integration Services (SSIS)

One thing that people typically want to do is always execute a particular task regardless of whether a checkpoint file exists or not. In this video, Jamie shows you how to create a package that can conditionally skip a checkpoint if it's in place.

2007-06-21

1,319 reads

Discuss

Security Tool Survey

by Additional Articles

Redgate

Product and Book Reviews

Red Gate is looking to expand upon their ever-growing list of extremely helpful tools and asking for help from you DBAs out the real world. They have a survey with 20 questions on Security Tools and 5 people will be chosen to win a goodie bag. I have no idea what's in the bag, but it should be interesting.

2007-06-21

2,771 reads

Discuss

The 2007 PASS Summit Conference

by Press Release

SQLServerCentral.com

SQLServerCentral

It's coming to Denver in September and there's still time to save. And attend the SQLServerCentral.com Reception.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-06-20

1,016 reads

Discuss

Using OVER() with Aggregate Functions

by Additional Articles

SQLTeam.com

T-SQL

One of new features in SQL 2005 that I haven't seen much talk about is that you can now add aggregate functions to any SELECT (even without a GROUP BY clause) by specifying an OVER() partition for each function. Unfortunately, it isn't especially powerful, and you can't do running totals with it, but it does help you make your code a little shorter and in many cases it might be just what you need.

2007-06-20

3,806 reads

Discuss

SqlCredit - Part 5: Adding Card, Vendor, and Purchase, Plus Much Refac

by Additional Articles

Database Journal

Miscellaneous

As I built out the last pieces of the original table set (Card, Vendor, and Purchase), I found a number of pieces that needed to be fixed in the design.

2007-06-19

1,737 reads