New blog post! Disaster struck… sqlpete.wordpress.com/2022/03/10/sql…
[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…
![AaronBertrand's tweet image. [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…](https://pbs.twimg.com/media/FNQOSkwWYAI-CdZ.jpg)
There’s a special place in hell for people who name their sub-directories in the MMM-YY date format. #baffled
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.
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.
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/…
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.
New blog post: “Practical queries using binary operations” sqlpete.wordpress.com/2021/02/03/pra…
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
New blog post: ‘Interest and APR: a short explainer’ sqlpete.wordpress.com/2020/12/31/int…
This was a really informative watch, recommended!
[From the best of the blog archives:] 7 Ways Your Data Is Telling You It’s a Graph by Karen López (@datachick) Read now: r.neo4j.com/2J1h4kS #GraphDatabases #DataModel #GraphDataModel
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.
[From the best of the blog archives:] 7 Ways Your Data Is Telling You It’s a Graph by Karen López (@datachick) Read now: r.neo4j.com/2J1h4kS #GraphDatabases #DataModel #GraphDataModel
The GREATEST holiday gift that you LEAST expected... reddit.com/r/SQLServer/co… Happy holiday everyone!
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!
Every day, it kills me that you can’t do cross-db joins in Azure. It’s like trying to run a race with your legs tied together.
New blog post, “SQL String Fun(ctions)” sqlpete.wordpress.com/2020/03/22/sql…
“Normalise until it hurts, denormalise until the devs stop whining.”
United States 趋势
- 1. Zeraora 8,776 posts
- 2. Peggy 27.3K posts
- 3. Berseria 2,588 posts
- 4. #FaithFreedomNigeria 1,387 posts
- 5. Good Wednesday 34K posts
- 6. Dearborn 334K posts
- 7. Luxray 1,490 posts
- 8. #wednesdaymotivation 7,188 posts
- 9. #Wednesdayvibe 2,440 posts
- 10. Cory Mills 19.5K posts
- 11. #LosVolvieronAEngañar 1,945 posts
- 12. Hump Day 17K posts
- 13. #MissUniverse 25.5K posts
- 14. $NVDA 42.2K posts
- 15. Xillia 2 N/A
- 16. International Men's Day 64.3K posts
- 17. Tom Steyer N/A
- 18. Happy Hump 11.1K posts
- 19. Jessica Tisch N/A
- 20. Sonic 06 1,251 posts
Something went wrong.
Something went wrong.