Programming, SQL, Software, SQL Server 2008, SQL Server 2000, SQL Server 2005, Transact-SQL, tSQL, SQL Tips, Database, SQL Server 2012

SQL Server Error: Fixing The Transaction Log for Database is Full Due to log_backup

T-SQL
T-SQL

If you are working with SQL Server, you may see an ominous sounding error: the transaction log for database {Your Database Name} is full due to log_backup Continue reading “SQL Server Error: Fixing The Transaction Log for Database is Full Due to log_backup”

Advertisements
.Net, C#, Programming, Software, VB.NET, Visual Studio 2010, Visual Studio 2013

Example of Setting up a Blank Windows Service in Visual Studio 2017

When you are creating a new Windows Service Application in NET, you can’t simply generate the project and then click F5 to debug in Visual Studio. You need to follow a few setup steps to get the service to work. In the article below I’ll explain the basics along with a code sample. Continue reading “Example of Setting up a Blank Windows Service in Visual Studio 2017”

.Net, Programming, SharePoint, Software, Tool, VB.NET, Visual Studio 2010, Visual Studio 2013

Get the Total Number of Documents in a SharePoint Site Collection Library and its Sub Folders using .NET

List the Total Number of Documents in a Library and its Sub Folders
List the Total Number of Documents in a Library and its Sub Folders

One thing that you often need and that is quite annoying to get in a default SharePoint installation is the total number of files in a document library and all of its sub-folders. The most common advice is to open the explorer view and then navigate through the folders and add up the file totals, but this becomes tedious really quickly if you have a library with numerous files and folders. Another option is to write a PowerShell script, but then you need to be on the SharePoint server itself and with an account that doesn’t have access to the document libraries. Also, in the case of PowerShell, you’ll quickly become annoyed with the many bad script examples out there that don’t work and end up taking your time. Continue reading “Get the Total Number of Documents in a SharePoint Site Collection Library and its Sub Folders using .NET”