Articles

With each revision, SharePoint becomes more a SQL Server Database application, with everything that implies for planning and deployment. There are advantages to this: SharePoint can make use of mirroring, data-compression and remote BLOB storage. It can employ advanced tools such as data file compression, and object-level restore. DBAs can employ familiar techniques to speed SharePoint applications. Bert explains the way that SharePoint and SQL Server interact.

2011-05-18

3,334 reads

Asynchronous Procesing with Service Broker

by Gary Strange

SQLServerCentral.com

Service Broker (SSSB)

Service Broker is a great feature that allows you to defer processing in SQL Server. Learn how you can have processes work together, but in an asynchronous fashion in this piece from Gary Strange.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(23)

You rated this post out of 5. Change rating

2011-05-17

10,926 reads

Discuss

SQL Server Replication: Providing High Availability using Database Mirroring

by Additional Articles

SQLCAT

Replication

This white paper describes how to use database mirroring to increase the availability of the replication stream in a transactional environment. The document covers setting up replication in a mirrored environment, the effect of mirroring partnership state changes, and the effect of mirroring failovers on replication. In addition, it describes how to use LSN-based initialization to recover from the failover of a mirrored Subscriber database.

2011-05-17

3,504 reads

A story of corrupted Master database in SQL Server 2008

by Yogeshwar Phull

SQLServerCentral.com

Administration

This is a real-time production issue I faced with one of our clients

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(85)

You rated this post out of 5. Change rating

2011-05-16

9,987 reads

Discuss

TSQL Challenge 56 - Create a Sierpinski carpet using TSQL

by Jacob Sebastian

SQLServerCentral.com

T-SQL Challenges

This challnge invites you to generate a Sierpinsky carpet using TSQL

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2011-05-16

2,517 reads

Discuss

Space Impact of Replication Snapshot Agent Job in SQL Server

by Additional Articles

MSSQLTips.com

Replication

I have noticed that available disk space on my SQL Server is getting low and I see a number of files getting generated in the replication snapshot folder. Because of these files there is a space issue on my server. Why are these files here and what can I do to resolve this problem?

2011-05-16

2,739 reads

Loading Data With Powershell

by Chad Miller

SQLServerCentral.com

PowerShell

Moving data in and out of SQL Server is a fundamental task for any developer or DBA. Chad Miller brings us a new way that we can load Powershell output into a SQL Server database.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(32)

You rated this post out of 5. Change rating

2011-05-13 (first published: 2008-12-16)

33,587 reads

Discuss

How to handle empty values in a line chart in SSRS

by Additional Articles

MSSQLTips.com

Reporting Services (SSRS)

When continuous data is displayed on a chart, such as a line chart, data is displayed very smoothly. But when non-continuous data is displayed on such a chart, the chart behavior is different. The continuous data is displayed correctly, but the non-continuous data is ignored on the chart. In such cases, handling of empty points in the dataset is required to make the data continuous and displayed correctly on the chart. In this tip we will look at how to implement a solution for this problem.

2011-05-13

3,962 reads