October 2013 Entries

jQuery 2.0 drops support for legacy IE (IE6, IE7, IE8)

jQuery upgrades may not be as reverse compatible as you may think. Starting from version 2 of jQuery, IE6, IE7 and yes also IE8 will no longer be supported. These are now considered legacy browsers. You will need to stop any upgrades to jQuery until your SLA states that IE8 is no longer supported and remain in jQuery 1.9.Some of the reasons for not supporting IE8 and before:- Remove all the code clutter in the jQuery library with code that has to deal with IE browser compatibility issues between ......

LINQ Contains Case Insensitive

Goal: Search for content in the database via LINQ to ENTITIES or LINQ to SQL that is case-insensitive (case-agnostic). Example: var con = BusinessContext.Create(); var owners = con.Shipments.Where(s => s.Dispatches.All(x => x.DriverLBCompany.Contains(... ).Select(x => x); This will fetch all dispatches where the DriverLBCompany contains the word “(exempt)”. You do not have to be concerned about the case as SQL Server is case-agnostic when it performs filtering. The sql being generated ......

Top 10 Browser Productivity Tips

You don’t have to be a geek to be a productive browser user. The tips below have been selected by actions users take most of the time to navigate a web-site but use long-standing keyboard or mouse actions to get them done, when there are keyboard short-cuts you can use instead. Since you hands are already on the keyboard it is almost always faster to sue a keyboard shortcut to get something done that you usually used the mouse for. For example right-clicking on something to copy it and then doing ......

Top 10 Cloud Backup Services

Although there may be many reasons to keeping your work documents safe, your personal files, images and videos in a safe place, it is also becoming more-and-more important to easily share those files and be able to sync them between devices like PC, MAC, mobile devices and external hard drives. There have been many advances in this space and a plethora of backup solutions to choose from. It can be difficult to make a selection between all of the options and find the one (or more) that fits your needs ......

Carbonite vs Dropbox: Pros and Cons

You may have different goals when we talk about Carbonite and Dropbox. The former was really just a backup solution and did not support file sharing and syncing, which the latter has been known for. Carbonite has invaded and in some ways overtaken Dropbox file sharing and syncing abilities.Before I say too much, here is a great post by Lee from CloudStorageBuzz: http://cloudstoragebuzz.com... my opinion if your data is below 2GB you don't have to fork out anything. ......

Backing up SQL Server to Windows Azure Store using Credentials

Goal: How to backup my SQL Server database to a Windows Azure Store, which is just a folder on your Azure account. Of course you need a Windows Azure account to do this with a Store subscription. In your store subscription you will have a Manage Keys option which will show you your keys needed to connect to your Windows Azure account's Store.You also will need to create a CREDENTIALS file in SQL Server Management Studio that contains your credentials info to use when SQL Manager tries to connect ......

T-SQL: Target server product version and edition

To find out what the target server product version and edition is:SELECT SERVERPROPERTY('ProductVers... SERVERPROPERTY('Edition');This may seem trivial, but a mistake some folks make is that just because you are for example running SQL Server 2012 Enterprise does not mean the target server you are connecting to is. For example, you are wondering why the "SQL Server Agent" does not appear on the tree in your Object Explorer in SQL Server Management studio. Well it could be that your target ......

T-SQL IntelliSense: Some objects or columns don't show up, or are incorrectly marked as invalid

Reasons by T-SQL intellisense does not pickup and complete a list or that an object or column is underlined and marked as incorrect. There could be multiple reasons but I will cover the three most prevalent reasons here:The most common reason is that your local in-memory cache has become stale. Typically this happens if you switch databases, or if you make DDL changes in your query window. Of course if more than one person is actively making changes to the schema will also render your cache stale ......

T-Sql: How to find records added in duplicate within a few seconds from each other

Goal: You need to find out if in a particular table, records that seem to have been added in duplicate due to a possible double-click. In this example I am querying a Shipment table and the natural key is the GBL number.Solution:In this example we will be looking for entries within a minute from each of the duplicate records (30 seconds before to 30 seconds after). See minutes example commented out as an example.select s.GBL, count(*)from Shipment swhere s.GBL is not nulland 1 < (select count(*)from ......

T-Sql: How to find records added in duplicate within a few seconds from each other

Goal: You need to find out if in a particular table, records that seem to have been added in duplicate due to a possible double-click. In this example I am querying a Shipment table and the natural key is the GBL number.Solution:In this example we will be looking for entries within a minute from each of the duplicate records (30 seconds before to 30 seconds after). See minutes example commented out as an example.select s.GBL, count(*)from Shipment swhere s.GBL is not nulland 1 < (select count(*)from ......