.Net, ADO.NET, ASP.NET, C#, Data Sources, Database, Excel, Excel 2003, Excel 2007, Excel 2010, Programming, Software, VB.NET

How to Loop Through an Excel Spreadsheet in a .NET Application

Import data from MS Excel into your .NET code

MS Excel is a great tool that a lot of employees at a company are very familiar with using. It helps structure and organize data in a way that is very intuitive to users without the users needing to be especially technical. So it should come as no surprise that sometimes you will want to write code to interface with data from Excel. Continue reading “How to Loop Through an Excel Spreadsheet in a .NET Application”

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

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”

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

SharePoint Dealing with the Huge and Growing File Size of SharePoint_Config_Log.ldf

SP_Custom_Menu
SP_Custom_Menu

It’s amazing how some SharePoint issues are known problems that don’t get fixed by Microsoft even after many years, and that don’t get mentioned as things one needs to look out for. I found this out recently when I ran up against an error where the entire disk space of my SharePoint SQL Server instance was filled up by a file called SharePoint_Config_Log.ldf . This is ever growing file is apparently a known problem with SharePoint that has existed in many earlier versions and that remains difficult to find a solution for that actually fixes the problem. Continue reading “SharePoint Dealing with the Huge and Growing File Size of SharePoint_Config_Log.ldf”