Pete Tonkin @sql_pete

Be good to your data, and it'll be good to you. sqlpete.wordpress.com Bournemouth, England Joined August 2015

Tweets

166
Followers

30
Following

64
Likes

41

Pete Tonkin @sql_pete

4 years ago

New blog post! Disaster struck… sqlpete.wordpress.com/2022/03/10/sql…

0 0 1 0 1

Aaron Bertrand @AaronBertrand

4 years ago

[Blog] : Advanced report examples using PIVOT and GROUPING SETS I show how I combine GROUPING SETS and PIVOT to get crosstab-style reports without Excel. mssqltips.com/sqlservertip/7…

2 1 11 0 0

Download Image

Pete Tonkin @sql_pete

4 years ago

New blog post: sqlpete.wordpress.com/2021/12/12/you…

0 0 0 0 0

Pete Tonkin @sql_pete

4 years ago

There’s a special place in hell for people who name their sub-directories in the MMM-YY date format. #baffled

0 0 1 0 0

Pete Tonkin @sql_pete

4 years ago

If I had 50p for every time I forgot that UNION (as opposed to UNION ALL) does an implicit DISTINCT behind the scenes, I’d have well over £5 by now.

0 0 1 0 0

Pete Tonkin @sql_pete

4 years ago

If you ever find yourself having to use DATETIMEOFFSET in SQL Server, can I recommend (a) holy water, (b) finding a less stressful job; base-jumping with live tigers strapped to you, maybe.

0 2 3 0 0

Pete Tonkin @sql_pete

4 years ago

New blog post: sqlpete.wordpress.com/2021/04/07/cre…

0 0 0 0 0

Hannah Fry @FryRsquared

5 years ago

New essay by me in the New Yorker. When it comes to data - in order to count - one must first decide what should be counted. newyorker.com/magazine/2021/…

17 209 777 0 139

Pete Tonkin @sql_pete

5 years ago

Too early in the morning for this nonsense:

0 0 1 0 0

Download Image

Good morning! I constantly feel like a fraud. I know a few of you do too. I'm told it's normal. The principal key to dealing with this is simple: Fake it till you make it. Just do the work. Pretend you are what you are not and do the work.

3 2 24 0 0

Pete Tonkin @sql_pete

5 years ago

New blog post: “Practical queries using binary operations” sqlpete.wordpress.com/2021/02/03/pra…

0 0 1 0 1

Davide Mauri @mauridb

5 years ago

Importing data into #AzureSQL is a common task: I have created a repo to provide working code samples to that task easy and quick. Powershell, AZ CLI, BCP, BULK INSERT, Data Factory and Apache Spark are all covered. Enjoy! lnkd.in/dbnRwxs

1 22 37 0 2

Pete Tonkin @sql_pete

5 years ago

New blog post: ‘Interest and APR: a short explainer’ sqlpete.wordpress.com/2020/12/31/int…

0 0 0 0 0

Pete Tonkin @sql_pete

5 years ago

This was a really informative watch, recommended!

Neo4j @neo4j

5 years ago

This was a really informative watch, recommended!

1 1 4 0 0

0 0 0 0 0

Matt Parker @standupmaths

5 years ago

Ok, this is too much. “the introduction of LAMBDA makes the Excel formula language Turing Complete” techcommunity.microsoft.com/t5/excel-blog/… tl;dr LAMBDA() lets you name any Excel formula you have written so you can then simply call it by name.

15 26 251 0 11

Itzik Ben-Gan @ItzikBenGan

5 years ago

The GREATEST holiday gift that you LEAST expected... reddit.com/r/SQLServer/co… Happy holiday everyone!

3 10 47 0 2

Download Image

Pete Tonkin @sql_pete

5 years ago

Turns out my definition of “self-join” is NOT the same as SQL Server’s ; you can’t join to the same table twice in an indexed view, which has ruined my morning’s work!