Category Archives: SQL Server

Like a wild-haired puppeteer pulling hundreds of strings at once to produce a uniform, if not terrifying, puppet show, SQL Server pulls your database strings to ensure you’re retrieving the data you need when you need it. Learn how to optimize Microsoft’s tool for complex applications like SharePoint.

Last updated by at . has your Microsoft apps covered with Absolute Support

Posted in Administrative Support, Microsoft Exchange, SharePoint, SQL Server | Tagged , , , | Leave a comment

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

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 … Continue reading

Posted in Administrative Support, Network Administration, Office 365, SharePoint, SQL Server | Tagged , , , , , , , , , , | Leave a comment

Choosing Between SQL Server 2012 & SQL Server 2008

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 … Continue reading

Posted in SQL Server | Tagged , , , , , , , , , , , , | 4 Comments

Configuring SSL in SQL Server Reporting Services (SSRS)

Learn how to troubleshoot and apply SSL in SSRS Here at, 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 … Continue reading

Posted in SQL Server | Tagged , , , , , , , , | 3 Comments

Resolving SSRS Subscription Issues in SharePoint

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 … Continue reading

Posted in SharePoint Tips & Tricks, SQL Server | Tagged , , , , , , , , | 1 Comment

Using the Performance Analysis of Logs (PAL) Tool

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 … Continue reading

Posted in SQL Server | Tagged , , , , , , , , | 1 Comment

SQL Express to SQL Server Standard: In-Place Upgrade

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 Over SharePoint’s 15-plus years, we’ve found solutions that fit for countless SharePoint farms, many … Continue reading

Posted in SQL Server | Tagged , , , , , , , , | 18 Comments

How to Perform an Unplanned Database Migration

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 … Continue reading

Posted in SQL Server | Tagged , , , , , , , , , , | 2 Comments