4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London


Peter Larsson

Peter Larsson is a key player for performance written code. He can turn a 10 hour query into a 3 minute piece of code. Peter is also a SQL Server MVP since 2009. He often hangs out at SQLTeam.com (27k+ posts) and other various sites where he helps all people understand SQL Server. When not working, he takes care of a wife and 4 kids.
http://www.developerworkshop.net http://weblogs.sqlteam.com/peterl/rss.aspx

All developers and DBAs make mistakes when programming in SQL Server. Learn to avoid the most common mistakes.

Blog posts RSS

ISO week calculation for all years 1-9999 without dependencies 27 Jul 2013
CREATE FUNCTION dbo.fnISOWEEK ( @Year SMALLINT, @Month TINYINT, @Day TINYINT ) RETURNS TINYINT AS BEGIN RETURN ( SELECT CASE WHEN nextYearStart <= theDate THEN 0 WHEN currYearStart <= theDate THEN (theDate - currYearStart) / 7 ELSE (theDate - prevYearStart) ...

Remove all Extended Properties in a database 27 May 2012
During my tests to port several databases to SQL Azure, one of the recurring things that fails export is the Extended Properties. So I just wanted to remove them. This is a simple wayh to list all Extended Properties and the corresponding delete statement. SELECT 'EXEC ...

The one feature that would make me invest in SSIS 2012 26 May 2012
This week I was invited my Microsoft to give two presentations in Slovenia. My presentations went well and I had good energy and the audience was interacting with me. When I had some time over from networking and partying, I attended a few other presentations. At least the ones who where held in ...

New Article series 24 Feb 2012
I have started a new article series at Simple Talk. It's all about the transition from procedural programming to declarative programming. http://www.simple-talk.com/sql/   First article is found ...

How to calculate the covariance in T-SQL 18 Jan 2012
DECLARE @Sample TABLE         (             x INT NOT NULL,             y INT NOT NULL         ) INSERT  @Sample VALUES  (3, 9),         (2, 7),         (4, 12),         (5, 15),         (6, 17) ;WITH cteSource(x, xAvg, y, yAvg, n) AS (         SELECT  1E * ...