SQL Server

Securing Data With SQL Server 2016

2017-03-27T08:23:30+00:00 March 27th, 2017|

Microsoft SQL Server 2016 provides advanced enterprise data protection with built-in security features to help safeguard your organization’s data. SQL uses multiple layers of security: Robust auditing Transparent data encryption Dynamic data masking Row Level Security Always encrypted technology […]

Fpweb.net Joins Microsoft Cloud Solution Provider Program

2017-03-20T08:39:45+00:00 March 20th, 2017|

Fpweb.net, a managed services and cloud provider with a global infrastructure and headquarters in St. Louis, Missouri, has joined the Microsoft Cloud Solution Provider program. The Cloud Solution Provider program allows partners to combine high-margin service offerings with Microsoft cloud products, and provide customer support and billing directly to customers. As [...]

Want to Save 30% on Microsoft Premier Support? We Have the Answer!

2016-01-21T11:10:19+00:00 January 21st, 2016|

Microsoft and its many fantastic products are simply amazing. Countless businesses of all shapes and sizes rely on so many different facets that Microsoft has developed and provides. Whether you’re programming with SQL and operating through Windows, manage your data with SharePoint or Azure, or tackle several tasks through the [...]

Choosing Between SQL Server 2012 & SQL Server 2008

2015-09-10T10:00:58+00:00 September 10th, 2015|

Why Use SQL Server 2012 instead of SQL Server 2008 R2? What are typical bases for making the decision? Which apply to this decision? When would we not choose 2012? Let’s dig in. As all of you know, SQL Server 2012 has been released for general use for a while [...]

Configuring SSL in SQL Server Reporting Services (SSRS)

2015-03-18T09:55:20+00:00 March 18th, 2015|

Learn how to troubleshoot and apply SSL in SSRS Here at Fpweb.net, we receive requests to create or renew SSL Certificates for SharePoint sites on almost a daily basis. In my experience, this has always been one of the simpler, more straightforward services we provide for our customers. I recently completed a [...]

Resolving SSRS Subscription Issues in SharePoint

2014-11-04T09:11:08+00:00 November 4th, 2014|

How to Fix Two Errors with SQL Server Reporting Services Subscription Issues Recently, a client of ours had some specific issues with SharePoint and SQL Server Reporting Services (SSRS). The solutions were, I felt, rather cryptic. So I’m posting them here in hopes that they help others who may encounter these apparently rare issues. [...]

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