SQL Server

SQL Express to SQL Server Standard: In-Place Upgrade

2014-02-06T09:00:24+00:00 February 6th, 2014|

Did you know you can perform an in-place upgrade from SQL Express to SQL Server? As you can imagine, we’ve seen a lot here at Fpweb.net. Over SharePoint’s 15-plus years, we’ve found solutions that fit for countless SharePoint farms, many different architectures, and many different issues. […]

How to Perform an Unplanned Database Migration

2013-07-21T13:46:16+00:00 July 21st, 2013|

In my last blog entry, I discussed using SQL aliases to configure a SharePoint farm for easy scalability. By using a SQL alias to point towards the SQL Server where the SharePoint config database resides, you create an easy and unobtrusive method if the need ever arises to move the [...]

Understanding AlwaysOn & Mirroring with SQL Server 2012

2013-04-18T10:22:49+00:00 April 18th, 2013|

Today, we dig back into SQL Server 2012 to look at AlwaysOn, Clustering, Log Shipping , Mirroring , Replication & Snap Shots, focusing on the what, the why and the who cares! I’ve been asked about these different items repeatedly by various other engineers and users. […]

SQL Server Files and Filegroups: A conversation

2012-11-26T14:27:26+00:00 November 26th, 2012|

Discussing SQL Server Files and Filegroups                 What are they?                 Why are they important?                 What do I need to know about them? All will be revealed as [...]

SQL Server: Understanding Log Files

2012-10-01T11:43:15+00:00 October 1st, 2012|

Welcome to The Next Byte.  The Gentle Care and Feeding of Log files: What are log files and why do we care? How are log files configured? What else do we need to know about log files? In the beginning, SQL existed over all the realms of information.  SQL saw [...]

Troubleshooting SharePoint Sluggishness (Server Side Issues)

2012-07-31T02:29:54+00:00 July 31st, 2012|

I’ve recently seen quite a few cases of “SharePoint Sluggishness”. When SharePoint is slow, it undermines productivity and can be frustrating to your SharePoint users. But how do you troubleshoot the issue to identify the underlying cause of the slowdown? In this post, we’ll offer some insight on troubleshooting techniques you [...]

Installing & Configuring SQL Server for SharePoint Farms

2012-07-03T05:51:16+00:00 July 3rd, 2012|

Hello everyone! Summer is all around us… The sun is shining bright. The sky’s clear. The birds are chirping. Let’s talk about some fun things such as: “SharePointing” SQL Server! You’re thinking: Wow! That sounds like fun, but what is it? Well, this edition of The Next Byte has all [...]

New Features in Microsoft SQL Server 2012

2012-05-15T07:48:49+00:00 May 15th, 2012|

(Welcome to The Next Byte, a series on Microsoft SharePoint and SQL Server written by Don Conrad, a.k.a. “Don SQL”, the Fpweb.net SharePoint database wizard and expert in all things SQL-related. In this post Don examines new features in SQL Server 2012. Missed an installment of The Next Byte? Check [...]

Sneak Preview: New Features in Microsoft SQL Server 2012

2012-03-19T08:51:06+00:00 March 19th, 2012|

(Don Conrad, a.k.a. “Don SQL”, is Fpweb.net’s resident database wizard and expert in all things Microsoft SQL related. In this post he examines the next version of SQL Server. Missed an installment of The Next Byte? Check out Don’s complete Microsoft SharePoint and SQL Server series.)  The Next Byte – [...]

Microsoft SQL Server and SharePoint: The Next Byte

2012-02-27T07:14:39+00:00 February 27th, 2012|

…THE NEXT BYTE The Next Byte is our series of posts about the relationship between SQL Server 2008 and Microsoft SharePoint, written by database administrator Don Conrad. Missed the last post? Please read “Microsoft SQL Server: The Database Behind SharePoint”. Up for discussion: A high-level description of SQL Server What [...]