SQL Server

Blog specifically related to SQL Server

Posted by in SharePoint, SQL Server, Speaking on August 07, 2016 .

Please visit the Microsoft Virtual Academy to view my Microsoft SharePoint and SQL Server courses.

You can visit the ComputerWorld site to view my monthly SharePoint blogs.

Thanks for visiting!

Brian 

I’m sure by now most of you have encountered SharePoint databases that have a SQL Server database data file (.mdf) at a size that is as little as several hundred MB’s, yet the associated log file (.ldf) is ginormous and may be GB’s in size. This ginormous transaction log file will continue to grow until the drive containing the transaction log (t-log) runs out of disk space. At this point there is no room for transactions to be added to the t-log, so users cannot perform insert, update, or delete actions in SharePoint. This restriction is applied because every type of SQL data modification is first written to the transaction log and...

Posted by in SharePoint, SQL Server on June 02, 2015 .

When creating a web application in SharePoint 2013 it will communicate with SQL Server to create the supporting content database. Depending on what steps are used to create the Web Apps it sometimes creates the SharePoint database with a not-so-'friendly' database name and it may contain a ginormous GUID, (which I pronounce Goo-id) as part of the database name. When working with these databases it can become challenging to specify the name of the database within PowerShell or SQL Server so you'll want to rename the database to a more user-friendly name. You may also decide you need to move the database to a different location on your hard...

The Central Administration content database that is created during the installation of your SharePoint farm is probably the second most important database, with the SharePoint Configuration database being the first most important, so it is imperative that you are able to easily reference this database when performing administrative tasks.  If you perform the SharePoint installation using the GUI the Central Admin database is created with a not-so-user-friendly name that includes a Globally Unique Identifier (GUID). This name makes it challenging to work with when writing scripts that reference the database because of the GUID included in...

Posted by in SharePoint, SQL Server, Speaking, News on May 15, 2015 .

Last week, I spent time with over 23,000 of my closest friends in Chicago at the Microsoft Ignite conference learning, networking, eating, and enjoying a bevy as we absorbed as much information as possible on topics including Windows 10, SQL Server, SharePoint, Office 365, and Azure just to name a few. Within these areas there were sessions containing information for IT Pros, developers, information workers, and anyone else working in any capacity of technology and not just Microsoft, as there were several mentions of Apple products as well.

This was the first conference of its kind in the fact it combined TechEd and several...

Implementing data redundancy is one of the most effective ways to avoid data loss in any application. Although this article discusses configuring redundancy for SharePoint content stored in SQL Server by configuring SQL Server log shipping, redundancy should not be limited to only data redundancy. Any possible single point of failure, including hard drives, cables, and DNS or IIS entries should be taken into consideration to ensure you are able to quickly recover from what could be a disaster.

There are several methods to choose from when determining the type of data redundancy you need to ensure business continuity. A few of these...