SQL

Dedicated Cloud Servers for Your Business

2014-11-28T08:10:47+00:00 November 28th, 2014|

Dedicated cloud servers make it your cloud, not a public one. Fpweb.net presents a private cloud server that works for you. Built to withstand even the largest enterprise needs, our managed cloud servers offer a robust connection and the performance reliability that can only be achieved through the full computing [...]

Using the Performance Analysis of Logs (PAL) Tool

2014-09-23T08:25:34+00:00 September 23rd, 2014|

The Performance Analysis of Logs (PAL) Tool is an extremely useful tool that provides a baseline of performance metrics of many Microsoft products. PAL can be useful as a starting point when troubleshooting possible causes of degraded performance. Used with Windows Performance Monitor (Perfmon), thresholds are predefined for a specific [...]

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. […]

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 [...]

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 [...]

SQL Server Administration for Microsoft SharePoint Hosting

2012-01-29T11:24:29+00:00 January 29th, 2012|

(Meet Don Conrad, affectionately known as Don SQL in the office. This introduction into the SQL arena paves the way for further SQL content from Don.) Hello, I’m Don Conrad. I’m the Database/Systems Architect for Fpweb.net, a dedicated SharePoint hosting company. Hosting SharePoint sites for customers around the globe is [...]