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.

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.

Working Long or Working Hard?

by Steve Jones

SQLServerCentral.com

Editorial

Would you rather work longer hours or tackle harder work? Steve Jones comments today on a recent post by Seth Godin. The answer as to what most people prefer might surprise you.

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.

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

Competing with an MBA

by Steve Jones

SQLServerCentral.com

Editorial

If you are looking to move into management, do you need an MBA? It's nice, but Steve Jones notes that many people are realizing that an MBA doesn't necessarily prepare you to manage other people or lead them in a company.

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

Wish you were here?

by Chris Massey

SQLServerCentral.com

Editorial

As it gets easier to attend events virtually, it's worth considering what the literal, financial value is of physical attendance.

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?

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.

Database Management for SharePoint 2010

Asynchronous Procesing with Service Broker

Working Long or Working Hard?

SQL Server Replication: Providing High Availability using Database Mirroring

A story of corrupted Master database in SQL Server 2008

Competing with an MBA

TSQL Challenge 56 - Create a Sierpinski carpet using TSQL

Wish you were here?

Space Impact of Replication Snapshot Agent Job in SQL Server

Loading Data With Powershell

Blogs

Flyway Tips: AI Generating Migration Script Names

The Book of Redgate: Get the right stuff done

Runing tSQLt Tests with Claude

Forums

No Defaults Passwords Ever

Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON

The Long Name

Question of the Day

The Long Name