Nick Kewney

Software Architect & Product Builder

Uncategorized

T-SQL script for identifying deadlocked processes

A useful script for identifying SQL deadlock cause/victim. WITH [Blocking] AS (SELECT w.[session_id] ,s.[original_login_name] ,s.[login_name] ,w.[wait_duration_ms] ,w.[wait_type] ,r.[status] ,r.[wait_resource] ,w.[resource_description] ,s.[program_name] ,w.[blocking_session_id] ,s.[host_name] ,r.[command] ,r.[percent_complete] ,r.[cpu_time] ,r.[total_elapsed_time] ,r.[reads] ,r.[writes] ,r.[logical_reads] ,r.[row_count] ,q.[text] ,q.[dbid] ,p.[query_plan] ,r.[plan_handle] FROM [sys].[dm_os_waiting_tasks] w INNER JOIN [sys].[dm_exec_sessions] s ON w.[session_id] = s.[session_id] INNER JOIN [sys].[dm_exec_requests] r ON s.[session_id] = r.[session_id] CROSS …

T-SQL script for identifying deadlocked processes Read More »

Engaging Business Customers with Mobile in 2014 – Apps vs. Mobile Websites

When we started the process of delivering a business mobile application to our customers, we asked ourselves a fundamental question which has haunted development teams and project managers for many years now; should we go native or mobile web in our development approach and, more importantly, why do we have to make this decision in …

Engaging Business Customers with Mobile in 2014 – Apps vs. Mobile Websites Read More »

The SSE Hydro Arena, Glasgow – Photo & Video Timeline

24 September 2013 24 September 2013 24 September 2013 24 September 2013 24 September 2013 24 September 2013 //player.vimeo.com/video/75390157 14th September 2013 28th August 2013 17th July 2013 9th June 2013 25th May 2013 20th May 2013 23rd February 2013 13th October 2012 13th October 2012 14th September 2012 1st June 2012 6th April 2012 …

The SSE Hydro Arena, Glasgow – Photo & Video Timeline Read More »

Handling Unauthorised Ajax Requests in ASP.NET MVC App

The following post describes an application-wide method of handling unauthorised Ajax posts within an ASP.NET MVC application. Modifying the Authorize attribute as per the example below shows how HandleUnauthorizedRequest can be overridden, returning a Ajax401Response when using Ajax. You’re then able to intercept all requests using jQuery and process them accordingly. Custom Authorize Attribute using …

Handling Unauthorised Ajax Requests in ASP.NET MVC App Read More »

New Website Launched – R.B. Richardson & Co.

R.B. Richardson & Co. specialise in domestic conveyancing and provide clients with a local service at competitive rates across central and south west Scotland, including Irvine, Ayr, Kilmarnock, Troon, Prestwick, Dalry, Kilmaurs & Glasgow. They are a long established firm offering a range of legal services for individuals and families. Whether you need help on conveyancing or …

New Website Launched – R.B. Richardson & Co. Read More »

DevWeek 2013: Tuesday Sessions Overview

I just got back from DevWeek 2013 at the Barbican Centre in London.  I enjoyed all the sessions I attended and have documented a few key presentations below. Tuesday Morning: Modelling and implementing hierarchies with SQL Server Presenter Bob Beauchemin from SQLskills Bob’s Website Bob’s Twitter feed Session Overview Bob’s session looked at support in SQL Server for hierarchical …

DevWeek 2013: Tuesday Sessions Overview Read More »

Hack Proofing Your Microsoft ASP.NET Web Forms and MVC Applications

Security is an afterthought with most developers. A common problem is that most web applications can be easily hacked. This presentation explores the most common attacks on web applications, how they work to exploit your app, and most importantly, how to protect against them. Techniques such as Cross Site Scripting, SQL Injection, Session Hijacking, and …

Hack Proofing Your Microsoft ASP.NET Web Forms and MVC Applications Read More »