Applying LINQ over CSV files In this article we will discuss how we can apply LINQ over CSV files. Validating column structure in CSV files A comma separated (CSV) file contains all data in text format. Accessing CSV files programmatically could prove a nightmare if the file does not have proper structure or if it fails to adhere the type...
Standard Members
Managing Chatty Coworkers in person and online
Managing Chatty Coworkers In Person and Online Hello, this is Laura Lee Rose – author of books TimePeace: Making peace with time and the Book of Answers: 105 Career Critical Situations– and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. Steve Wynkoop and I talk a lot about designing and...
Bulk Transfers: Some guidelines
Bulk Transfers: Some guidelines Author: Basit A. Farooq Introduction Bulk transfers are a common way of importing large amounts of data into, or exporting large amounts of data out of, SQL Server databases. SQL Server supports bulk transfers run from an operating system command line or the SQL Server command processor. When performing bulk transfers, you must consider the implications...
Troubleshooting SQL Server 2012 full-text search
Troubleshooting SQL Server 2012 full-text search If you have problems with SQL Server 2012 full-text search, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 full-text search bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...
How to ORDER BY an Expression in DB2
How to ORDER BY an Expression in DB2 By Craig S. Mullins Sometimes a program requires that the results of a query be returned in a specific sequence. We all know that the ORDER BY clause can be used to sort SQL results into a specific order. For example, to return a sorted list of employee compensation sorted by last...
Generic Collections in C#
Generic Collections in C# Generic collections were introduced in the .NET Framework 2.0. They provide a type safe approach for working with collections in .NET. The later versions added querying capabilities to these generic collections what we know as LINQ queries. There are two primary interfaces that every generic collection actually implements. They are the IEnumerable<T> interface and IQueryable<T> interface....
Increasing the Results of Attending a Conference
Increasing the Results of Attending a Conference Hello, this is Laura Lee Rose – author of books TimePeace: Making peace with time and the Book of Answers: 105 Career Critical Situations– and I am a business and efficiency coach that specializes in time management, project management and work-life balance strategies. Steve Wynkoop and I talk a lot about designing and...
Troubleshooting SQL Server 2012 backup/restore problems
Troubleshooting SQL Server 2012 backup/restore problems If you have problems with SQL Server 2012 backup or restore, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 backup/restore bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...
Understanding Triggers
Understanding Triggers Author: Basit Farooq A trigger is a specialized stored procedure that activates (executes) in response to an event. There are two basic trigger types, ie data manipulation language (DML) trigger and data definition language (DDL) trigger, based on the type of event that causes them to fire. For example, a data manipulation language (DML) trigger fires in response...
Selecting Every Other Row
Selecting Every Other Row By Craig S. Mullins One of the fun things about publishing is getting questions from readers that make you think. A recent question I received went something like this: "Can I get the odd and even number of rows from a DB2 table?" Well, my first reaction was to think "this guy doesn’t understand the way...